Excel validation lists avoid blanks and errors with TOCOL(ignore) plus FILTER; the spill range stays stable across worksheets.
Google Sheets, Microsoft Excel, and other spreadsheet software offer powerful sorting tools to help you rearrange your data. Knowing how to sort your spreadsheets makes the data easier to see and use.
Some results have been hidden because they may be inaccessible to you
Show inaccessible results