I have a spreadsheet that have set on autofilter.
I know that if there are no blanks in a column, "Blanks" and "Nonblanks"
will not appear in the drop-down as an option.
However, in this spreadsheet, I have a date column that DOES have blanks,
and the drop-down does not have an option to filter by blanks.
It used to work. I don't know what changed.
I even tried removing the auto filter and resetting it, and it still doesn't
work.
Any ideas?