Auto filter limitations

T

Thor Geirbo

I'm using a the auto filter function to navigate around
the more than 10,000 posts in my spreadsheet. However the
auto filter don't seem to cope with all the posts. E.g.the
all streetnames after U are ignored. Has anyone overcome a
similar problem?
 
D

Debra Dalgleish

An AutoFilter dropdown list will only show 1000 entries. If your column
has more than 1000 unique items, they can be filtered, but they can't
all be displayed in the dropdown list.

To AutoFilter for an item that doesn't appear in the dropdown list, you
can choose Custom from the drop-down list, and type the criteria, as
you're currently doing. Also, there are a couple of workarounds here:

http://www.contextures.com/xlautofilter02.html
 

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

Similar Threads

Alternate Row Shading with Filter 1
Auto-filter not grabbing all the data 2
Auto Filter Comma Dilemiation 2
Auto Filter - It's broken! Help! (Office '03) 2
Auto Filter Function getting 'stuck' 3
Auto Filter function only provide 2 criteria input 5
Controlling auto-filter with VBA 1
Auto Filter problems... 4

Top