Forum Discussion
Filter search doesn't show value, but Ctrl F finds the value
Just a guess here without seeing the CSV (the link requires login). Does your data happen to have blank rows mixed in? It sounds like the filter may not be considering all rows so when the search is done via the filter, the item is not found. Something worth trying, clear the filter, select your entire range, apply filter, and try to locate the item through the filter's search.
As far as your suggestion, my dataset doesn't have any blank rows.
A filter drop down list can display a maximum of 10,000 unique items - see Excel specifications and limits
Your City column contains 18,488 unique cities - almost double the maximum number the drop down list can show.
- But if I'm using the search bar in the filter, shouldn't that not matter? For example, I'll search for "milford" and it returns 3 cities in the dropdown list: "Milford", "New milford", and 'South milford". It's just "West milford" that doesn't show.
The dropdown list is incomplete if there are more than 10,000 unique values.
Filtering the incomplete dropdown list does not magically add items that weren't present.
At least, that's my guess. I have no inside knowledge of how this works.
