Strange Results with Autofilter

  • Thread starter Peter Bernadyne
  • Start date
P

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
 
A

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,
 
G

Guest

Can you tell how much over 1000 you are?

Alan said:
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,
 
T

Tom Ogilvy

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

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