I've an excel sheet with around 1000+ rows. I've applied filter on the first column with value "GS1 - Indian History". It is just supposed to show 16 rows, but it is showing rows containing other values (including blanks) for this column.
I've tried clearing formatting & reformatting entire column. I've changed the format of the cell contents from "General" to "Text". Still it isn't working.
Why on the earth is this happening? And how to fix it?
I just found something else fishy:
There are lot more records than 512. Any by any chance is this 512 any limit imposed? (as 512 fits in the series of 512, 1024, 2048 etc)