MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Autofilter: Limits


Posted by M. Sanders on July 25, 2001 7:15 AM

I am trying to use autofilter to search a list of 2,300 records. Only a partial dropdown list. Does anyone know the limit of autofilter? Does anyone know a way to increase the limit or a way around?

Thanks in advance,

Matt


Posted by Mark W. on July 25, 2001 7:57 AM

> Does anyone know the limit of autofilter?

You can Autofilter all the physical rows of a
worksheet, but you can only view the 1st 1,000
unique values in the dropdown.

> Does anyone know a way to increase the limit...

There's no way.

> Does anyone know...a way around?

Use Advanced Autofilter with a criteria.