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