Excel validation lists avoid blanks and errors with TOCOL(ignore) plus FILTER; the spill range stays stable across worksheets.
How-To Geek on MSN
How to use Power Query in Microsoft Excel
Transform messy spreadsheets, remove errors, and refresh tables automatically without writing a single formula.
Finding a decent sample API for testing can really slow things down when you’re trying to build something. You know, waiting ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results