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

How to sort a single column in Excel without disrupting the rest of the spreadsheet Your email has been sent We tend to view spreadsheet data as a whole, and that’s as it should be. Seldom does a ...

Seems Excel doesn't like sorting multiple decimal place lists. I tried to write a customer filter, but wild cards don't seem to work. Writing a full filter for 1, 1.1, 1.1.1, 1.1.2, etc. would be an ...