Forum Discussion
Solved
Excel Filter only works for 10000 unique values
We have a quite large spreadsheet with more than 10000 rows (each containing a different value). We like to use filters to filter in the spreadsheet, however, the filter dialog only allows filteri...
AlexanderPacha Google for "Excel limitations" and you'll find it. You can't reconfigure it. And the Filter option also work with texts. It has options like "Begins with", "Contains" etc.
Same here. We have textual values, not numbers. I just used numbers in the example to demonstrate the problem. We have textual values and more than 10000 unique values. Is this limitation configurable somewhere?
And no, I'm NOT filtering with the and parameter selected. When you type something in the search-box, it automatically updates the value above and when I entered 10002, it failed to find anything, thus kept the value 10001 in the equal box. If you want, I can record a screencast to show this behavior.
The funny thing is that Excel on my iPad Pro does not have that limitation. It is goofy at best that this quick, easy and commonly used function is different on different platforms.