Numbers Quick Filter not working
In one of my spreadsheets, I did a quick filter on a column that has text in some of the rows. I need to quickly hide all the rows without values, in order to do some calculations with only the rows that have values in this column. So... I selected the column, quick filter, deselected BLANK and left the rest of the values checked. I should have ended up with about 60 rows. The result was only a few rows. Most of the rows that should have been selected, they were hidden.
I used to have Excel (Windows platform)... super easy/intuitive/quick. So I'm familiar with the whole concept.
Does Numbers - Quick Filter - work? If so, what are the steps to 'quick filter' a column?
MacBook Air, macOS 13.5