Forum Discussion
AlexanderPacha
Sep 16, 2022Copper Contributor
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...
- Sep 16, 2022
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.
AlexanderPacha
Sep 16, 2022Copper Contributor
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.
Riny_van_Eekelen
Sep 16, 2022Platinum Contributor
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.