Excel validation lists avoid blanks and errors with TOCOL(ignore) plus FILTER; the spill range stays stable across worksheets.
How-To Geek on MSN
The game-changing Excel ribbon feature I wish I'd used sooner
Stop hunting through tabs—build a portable custom ribbon containing your favorite commands and Excel's most useful secret tools.
How-To Geek on MSN
Microsoft Excel's navigation pane is more useful than you think
Turn Excel into a structured workspace by navigating sheets, renaming objects, finding elements, and clearing hidden clutter.
Some results have been hidden because they may be inaccessible to you
Show inaccessible results