ExcelBanter - Excel AutoFilter

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Excel AutoFilter (https://www.excelbanter.com/excel-worksheet-functions/7854-excel-autofilter.html)

Gail

Excel AutoFilter

Is there a limit to the number of rows or unique values that AutoFilter can
display in its dropdown menus?

Gail

Frank Kabel

Hi
see:
http://www.contextures.com/xlautofilter02.html#Limits

"Gail" wrote:

Is there a limit to the number of rows or unique values that AutoFilter can
display in its dropdown menus?

Gail

Ron de Bruin

hi Gail

See
http://www.contextures.com/xlautofilter02.html#Limits

If you want to Filter on one column see
http://www.rondebruin.nl/easyfilter.htm

--
Regards Ron de Bruin
http://www.rondebruin.nl

"Gail" wrote in message ...
Is there a limit to the number of rows or unique values that AutoFilter can
display in its dropdown menus?

Gail

All times are GMT +1. The time now is 05:39 AM.