Forum Discussion
Filter search doesn't show value, but Ctrl F finds the value
Hi JoeUser2004, thanks for the quick response. Here is a https://data.world/niccolley/us-zipcode-to-county-state/workspace/file?filename=ZIP-COUNTY-FIPS_2018-03.csv I downloaded, which I then saved as an Excel file. Per your other suggestions:
1. I have run into this issue multiple times, but the most recent one involves the city "West milford". It doesn't show up when I try to filter for it. Same problem with the zip code for this city. Funny thing is, if I first filter on NJ in the State field, then "West milford" shows up in the city filter.
2. There are no conditions for the filter. I'm just applying a filter to all my columns (from the Data pane) and using the dropdown arrow on the city column to open the filter options, and then using the search bar to find what I need. I went through the process of taking a screenshot, but I'm not able to upload images to my post. Seems weird.
3. Nothing fancy here, either. I'm literally just using the Ctrl + F shortcut on my keyboard to bring up the search bar.
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.
- Apologies for the link. I've just uploaded the file to Dropbox: https://www.dropbox.com/s/lrbmo84tg6zt4lx/ZIP-COUNTY-Master.xlsx?dl=0
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.
