AutoFilter issues

W

WT

I have a medium sized spreadsheet (12 col, 3000 rows) and I have activated
the autofilters across the 12 columns. The sheet is pre-sorted by the first
col which contains text and no filters are set. In seeking a number in the
third column I use the drop list expecting to find a complete listing of all
the numbers in the column however, the number I seek does not appear yet I
know it exists.
Then when I use the Filter and sort the 3 column ascending the number along
with many others magically appear in the drop list. Is there a known issue
using autofilters or a perhaps a limitation in the drop lists???
 
G

Gord Dibben

AutoFilter list has a limit of 1000 unique items.

Use Custom>Equal to or Contains


Gord Dibben MS Excel MVP
 
E

Elkar

The AutoFilter drop-down list is limited to 1000 values. The AutoFilter
still applies to all of your data, but will only the first 1000 will be
displayed on the drop-down list. This is a limitation in Excel 2003 and
earlier versions. I believe the limit was increased in Excel 2007.

HTH
Elkar
 
W

WT

Thank you I had an idea there was a limit. Unfortunately all the items in
column are unique so I will be sure to sort by the column first. Thanks
again.
 

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