Filter lists

[Guest]

I have a large list of names in a column and I use the auto filter to speed
up my search for names in this column when attempting to cross reference with
other lists. I noticed that not all the names in the list show up when
clicking the filter arrow. Why is this. Is there a limit to the number of
items in a filter list.

 

[Roger Govier]

Hi

Autofilter has a display list limit of 1000 rows.
There are workarounds to this available at Debra Dalgleish's site
http://www.contextures.com/xlautofilter02.html#Limits

 

[Guest]

Thanks, it adds a column but the workarounds work. many thanks