Excel validation lists avoid blanks and errors with TOCOL(ignore) plus FILTER; the spill range stays stable across worksheets ...
How-To Geek on MSN
You need to know what the hash sign does in Excel formulas
Smash the hash in a flash!
Create a table of contents in an Excel sheet using hyperlinks Your email has been sent Hyperlinks have been around for a long time, but some Excel users just don’t use them. One way your users can put ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results