Filter/AutoFilter Limitation
Filter/AutoFilter Limitation
(OP)
Does anyone know how to overcome the limitations of the data filtering (AutoFilter)? When you click the arrow for the filter, "only the first 1000 unique entries in the list appear".





RE: Filter/AutoFilter Limitation
=====================================
Eng-tips forums: The best place on the web for engineering discussions.
RE: Filter/AutoFilter Limitation
the following tip: Excel's AutoFilter will only show 1000 unique items from a list. If you have more this and the value you want is not in the drop-down list, you can click Custom and type the value in.
Cheers,
Joerd
Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.
RE: Filter/AutoFilter Limitation