| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| LISTS- adding info without repeat to other lists | Excel Discussion (Misc queries) | |||
| Multiple lists with repeated values for dependet drop down lists | Excel Worksheet Functions | |||
| Filter arrows on drop down lists | Excel Discussion (Misc queries) | |||
| Excel auto filter doesn't recoginize case - won't filter AA from A | Excel Discussion (Misc queries) | |||
| "Criteria Range" in the "Data/Filter/Advanced Filter" to select Du | Excel Worksheet Functions | |||
Linear Mode
