If you need a legend longer than your data, you’ve gone too far.
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 ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results