Excel validation lists avoid blanks and errors with TOCOL(ignore) plus FILTER; the spill range stays stable across worksheets.
What if the Excel you know today could completely transform the way you work tomorrow? Below Jon from Excel Campus explores how the new 2026 updates to Microsoft Excel aren’t just incremental ...
I’ve used Excel, even beyond spreadsheets, for quite some time, and over the years, I’ve naturally developed a few favorite features and shortcuts. They’re probably not the ones you’d expect, though.
Some results have been hidden because they may be inaccessible to you
Show inaccessible results