Autofilter problem unresolved

[Jamie R]

The sheet does not have blank lines. All of the columns data in them. It does
at this time have 2280 lines with data. This will increase every week.

 

[Ron de Bruin]

Hi Jamie

There is a limit of 100 unique items in the dropdown
See Debra's site for more info
http://www.contextures.com/xlautofilter02.html#Limits

 

[Sean Timmons]

Depedning on your lookup value, autofilter will only show a certain number of
items. You can find this out quickly by sorting by your desired column. If
your values end at, say, w, then you aren't capturing anything from y down.

 

[Cheers,]

Hi,

this is version dependent.

2003 - 1000 unique items
2007 - 10,000 unique items

If this helps, please click the Yes button

Cheers,
Shane Devenshire

 

[Gord Dibben]

The autofilter list will show only 1000 unique items.

Work around that limitation by using Custom and one of the parameters found
there.

i.e. starts with.........contains or similar.


Gord Dibben MS Excel MVP