Hello,

I have a large spreadsheet of data - each row representing an individual in the company and each column a given metric. When I select all the data and add filters (so I can filter by highest or lowest in a given metric), I run into two problems:
- First, when sorting it asks me so sort from A-Z or Z-A. Aside from the column head where the filter option is, every cell in the column is either blank or a number.
- When I sort from 'A-Z', it filters from low to high, totally fine. But when I filter from 'Z-A', the first rows are the cells with names but no data, followed by the completely empty rows, then the rest of the data from high to low.

Note: When adding the filters, I select the entire data range, empty cells and all. I've seen that feedback come up a lot in similar posts.