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.
AlexanderPacha That is not bug. That is Excel limitation and it is documented. You can use number filters option to define your filtering criteria. See the below screenshot.
- 1.) Where is that behavior documented? And why is it different between the offline version and the online version?
2.) The number filters that you mention are not working for us, because we don't have numbers. We have textual values. I just simplified the spreadsheet to demonstrate the problem.
