Excel validation lists avoid blanks and errors with TOCOL(ignore) plus FILTER; the spill range stays stable across worksheets.

Microsoft has introduced a powerful new function in its Excel spreadsheet application, allowing users to simplify their workflows by reducing the need for complex formulas. Excel’s latest beta version ...