Filter lists
 

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.
--
Joroti

Filter lists
 

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
--
Regards

Roger Govier


"JRTB" wrote in message
...
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.
--
Joroti

Filter lists
 

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


"Roger Govier" wrote:

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
--
Regards

Roger Govier


"JRTB" wrote in message
...
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.
--
Joroti