Hey guys,

I'm trying to filter a column for a particular variable but for some reason, excel filters only less than half the file. The second half og the file shows cells that do not contain the variable.

When clicking on the filter icon, it shows records only up to the point the filter stops. In other words, values after the point where filtering stops is not an option to filter with.

So for example, when I filter from (blanks), rows 1 - 2459 filtered correctly. Only blank rows appeared. But rows 2460 - 15000 show the rest of the data, not filtered.

No other filtering options is turned on. I copied the data from one CSV file to another. The puzzling this is, it filters fine in the original file but not in the second.

Thank you in advance for helping.