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

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

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