Excel validation lists avoid blanks and errors with TOCOL(ignore) plus FILTER; the spill range stays stable across worksheets.
Christopher Mims is a columnist who writes about technology for The Wall Street Journal's tech bureau in San Francisco. The subjects of his columns vary widely from one week to the next. He has ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results