Autofilter Limitations

G

Guest

I have a data set with about 21,000 records and about 4,000 unique values in
the column I want to filter. Not all the values appear in the filter drop
down, so I just entered the value in the custom filter box. Not all records
associated with that value appear. When I search the document for the
filtered value, I find 8 records, but the autofilter only finds 6.
 
P

Peo Sjoblom

The only limitation is that the dropdown is only about 1000 items, you
should still get all the filtered values if you use custom from the
dropdown. Also make sure there are no blanks in-between
If that's the case remove the filter, then manually select the whole table
down to the 21000th record, then apply the filter
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top