I have a sheet with columns that have "X"s in the cells. When I turn on the filters, none of them show the "X" as something to select. I only have the "Select All" and "Blanks".
There are no protections on the file or sheet.
I have even copied/pasted the data over into a new file and still cannot get it to work.
There are no protections on the file or sheet.
I have even copied/pasted the data over into a new file and still cannot get it to work.