| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filter used - want the list
Hi, I have 6000 items listed in Excel
Some have the same name, If I use filter the drop down list shows the list of different names but how can I extract that list for use elsewhere without manually picking out each differing name? if you get what I mean? TIA -- Vass |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Filter used - want the list
Look at Debra Dalgleish's site for Advanced filter with unique records.
http://contextures.com/xladvfilter01.html#FilterUR Vass wrote: Hi, I have 6000 items listed in Excel Some have the same name, If I use filter the drop down list shows the list of different names but how can I extract that list for use elsewhere without manually picking out each differing name? if you get what I mean? TIA -- Vass -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Filter used - want the list
"Dave Peterson" wrote in message ... Look at Debra Dalgleish's site for Advanced filter with unique records. http://contextures.com/xladvfilter01.html#FilterUR Perfect Dave, exactly what I needed Many thanks for quick response! -- Vass |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Filter a list please help | Excel Discussion (Misc queries) | |||
| How to filter list from pre-existing list | Excel Discussion (Misc queries) | |||
| Why is it that my list won't filter? | Excel Discussion (Misc queries) | |||
| Filter the results of a list based on a previous vlookup against the same list | Excel Worksheet Functions | |||
| filter a list | Excel Discussion (Misc queries) | |||
Linear Mode
