Strange Results with Autofilter
Can you tell how much over 1000 you are?
"Alan" wrote: 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, "Peter Bernadyne" wrote in message ... Hello, This is a weird one that's never happened to me before. I am using autofilter on what is a fairly substantial worksheet. For whatever reason, when I filter on one of the elements in a column (which should return well over 8,000 rows) I instead keep getting much smaller numbers (like 62 or 68 or something). There are no breaks in the column (everything is contiguous) and, as far as I can tell, the 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 memory problem, given that I have a fairly substantial worksheet of 60,000 rows (columns:A-U). Does anyone know why my autofilter would be failing me? Is there an upper limit of memory/rows after which autofilter does not work? Any help much appreciated! Thanks, -Pete -- Peter Bernadyne ------------------------------------------------------------------------ Peter Bernadyne's Profile: http://www.excelforum.com/member.php...fo&userid=7017 View this thread: http://www.excelforum.com/showthread...hreadid=266242 |
Use the Advanced filter to extract the unique entries to another location
and count them. -- Regards, Tom Ogilvy "Joyce" wrote in message ... Can you tell how much over 1000 you are? "Alan" wrote: 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, "Peter Bernadyne" wrote in message ... Hello, This is a weird one that's never happened to me before. I am using autofilter on what is a fairly substantial worksheet. For whatever reason, when I filter on one of the elements in a column (which should return well over 8,000 rows) I instead keep getting much smaller numbers (like 62 or 68 or something). There are no breaks in the column (everything is contiguous) and, as far as I can tell, the 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 memory problem, given that I have a fairly substantial worksheet of 60,000 rows (columns:A-U). Does anyone know why my autofilter would be failing me? Is there an upper limit of memory/rows after which autofilter does not work? Any help much appreciated! Thanks, -Pete -- Peter Bernadyne ------------------------------------------------------------------------ Peter Bernadyne's Profile: http://www.excelforum.com/member.php...fo&userid=7017 View this thread: http://www.excelforum.com/showthread...hreadid=266242 |
All times are GMT +1. The time now is 02:11 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com