One user here where I work has got a very strange problem with Excel in one particular sheet of one Excel: when she filters on a column which has only pure text in it and she wants to find the rows where the cells in that column are blanks, then the filter works for about the first 2/3 of all rows, and then the last 1/3 of the rows is ALWAYS shown regardless of the filter in that column is set to ! And strange is that the properly filtered rows have their row numbers correctly shown in blue font (which is the colour of filtered rows), and the last 1/3 of rows have their row numbers in black font, as has every row when no filter is active. It's as if the last third of rows have a special "status" which takes them out of the "filterable" rows. There are only about 130 rows, that's a very small sheet.
When we copied the whole sheet and pasted the values in a new sheet, the same filter on that column worked !
Anybody seen that one before ? Ideas about what it could be due to ?
Thanks for hints