Excel validation lists avoid blanks and errors with TOCOL(ignore) plus FILTER; the spill range stays stable across worksheets.
Use dynamic arrays and tables for fast, scalable cascading drop-down lists in modern Excel.
How-To Geek on MSN
You need to know what the hash sign does in Excel formulas
Smash the hash in a flash!
Much of the data that you use Excel to analyze comes in a list form. You might need to sort the data, filter it, sum it, and perhaps even chart it. Excel tables provide superior tools for working with ...
How to use a custom sort on slicer buttons in Microsoft Excel Your email has been sent Microsoft Excel sorts slider buttons alphabetically and numerically. Fortunately, you can add a custom sort list ...
Results that may be inaccessible to you are currently showing.
Hide inaccessible results