Forum Discussion
excel filtering issues
Hello Len
There is a limit as in how many individual entries can be shown in the filter box.
However you can use the search box to type the customer name you're looking for.
Hello Len
There is a limit as in how many individual entries can be shown in the filter box.
However you can use the search box to type the customer name you're looking for.
yes thank you thats what i have always done for years but the problem is...'after' 10,000 additions eg there could be 100 'smiths' or '300 hamilton' customers with the same name in first 10,000 and some in after 10,000 is there a way that the filter can find 'after' 10,000? or is there a break or a glitch or a setting missing that prevent s this?....thank you
I quickly set up some sample data. About 50000 records - consisting of four individual names.
When I filter a name I get about 12000 records. No problem there.
hmm might be worth copy and paste all info to a new spreadsheet and see if that makes a difference?
Better try a new workbook.
Does your data set contain blank rows?