W Will Fleenor Dec 19, 2003 #1 Is there a limit on the number of rows you can use with a filter in Excel 2002? It it the same limit in Excel 2003? Thanks, Will
Is there a limit on the number of rows you can use with a filter in Excel 2002? It it the same limit in Excel 2003? Thanks, Will
P Peo Sjoblom Dec 19, 2003 #2 There is no limit per say, the limit is that there are about 1000 unique records visible in the dropdown. You can over-ride that by using custom or using help column http://www.contextures.com/xlautofilter02.html#Limits
There is no limit per say, the limit is that there are about 1000 unique records visible in the dropdown. You can over-ride that by using custom or using help column http://www.contextures.com/xlautofilter02.html#Limits
