Archive of Mr Excel Message Board
Back to Data in Excel archive index
Back to archive home
AutoFilter giving limited results
Posted by James Verwey on January 20, 2000 4:10 PM
I have a sheet of 8000+ records in which I would like use autofilter to quickly view groups of like records.
Unfortunately autofilter only displays the top 500 some-od values in the drop down list. Are there limits to how many values autofilter will display in this list?
Re: AutoFilter giving limited results
Posted by Dian on March 05, 2000 8:22 AM
-------------------------------------------------
Yes, there is a limit to the display. However, if you choose custom in the list and type in the data that you are looking for it will be there.
Re: AutoFilter giving limited results
Posted by Frank Donsbach on May 26, 2000 3:22 AM
I tried to use autofilter by choosing custom with 6000 values, but I still can't see the filtered items. I think there is an upper limit where Autofilter failed anyhow.
This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our
online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.