Thu 9 Aug 2007, 12:25Delegate Bowen said...
Bowen has attended:
Excel Advanced course
Filtering
Is their a maximum number of rows that Excel will accept for a filter? I have less than 1200 rows and yet the Filter will not display in the drop down any more than about 1150. I have tried turning the filter off and then on again to no avail. Suggestions welcomed.
Thu 9 Aug 2007, 12:42Trainer Tracy said...
RE: Filtering
Hi Bowen,
Thanks for the question.
In answer to your question there is a limit of 1000 unique entries when using the AutoFilter. Your AutoFilter will function correctly if you have more that 1000 unique entries in your data list column, but you'll have to use a Custom selection or use an Advanced Filter with a criteria setting.
Tracy
