Excel validation lists avoid blanks and errors with TOCOL(ignore) plus FILTER; the spill range stays stable across worksheets.
Department of Environmental and Occupational Health Sciences, University of Washington, Seattle, United States College of Health Solutions, Arizona State University, Phoenix, United States ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results