MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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?


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.

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.