Excel validation lists avoid blanks and errors with TOCOL(ignore) plus FILTER; the spill range stays stable across worksheets.
Reversing the order of a column would be easy if the column was already listed alphabetically or sequentially; you would just sort in the other direction. However, data may not be in alphabetical or ...
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 ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results