Excel validation lists avoid blanks and errors with TOCOL(ignore) plus FILTER; the spill range stays stable across worksheets.
When I started using Microsoft Excel, my spreadsheets were a mess, and I wasted hours trying to make them look professional. If you're struggling with manual formatting, these six simple tips are the ...
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.
Some results have been hidden because they may be inaccessible to you
Show inaccessible results