Strange Results with Autofilter

[Peter Bernadyne]

Hello,

This is a weird one that's never happened to me before.

I am using autofilter on what is a fairly substantial worksheet. Fo
whatever reason, when I filter on one of the elements in a colum
(which should return well over 8,000 rows) I instead keep getting muc
smaller numbers (like 62 or 68 or something). There are no breaks i
the column (everything is contiguous) and, as far as I can tell, th
elements appear in the autofilter drop-down list just fine.

The only thing I can think of is that I'm having some sort of memor
problem, given that I have a fairly substantial worksheet of 60,00
rows (columns:A-U).

Does anyone know why my autofilter would be failing me? Is there a
upper limit of memory/rows after which autofilter does not work?

Any help much appreciated!

Thanks,

-Pet

 

[Don Guillett]

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

 

[Alan]

Autofilter has a limit of 1000 unique items, that's it. You need perhaps to
introduce some extra columns to enter some sub categories perhaps and filter
by those,
Regards,

 

[Guest]

Can you tell how much over 1000 you are?

Autofilter has a limit of 1000 unique items, that's it. You need perhaps to
introduce some extra columns to enter some sub categories perhaps and filter
by those,
Regards,

 

[Tom Ogilvy]

Use the Advanced filter to extract the unique entries to another location
and count them.