Excel validation lists avoid blanks and errors with TOCOL(ignore) plus FILTER; the spill range stays stable across worksheets ...
Launch Microsoft Excel Create a table or use an existing table from your files Place the formula into the cell you want to see the result Press the Enter Key Launch Microsoft Excel. Create a table or ...