Excel validation lists avoid blanks and errors with TOCOL(ignore) plus FILTER; the spill range stays stable across worksheets.
Our community, make sure to read the rules carefully. This table is not meant to be used online and you will most likely be banned if you attempt to do so. Absolutely make sure to use the command as ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results