Autofilter problem unresolved

J

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.
 
S

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.
 
C

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
 
G

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
 
Top