Filter used - want the list

  • Thread starter Thread starter Vass
  • Start date Start date
V

Vass

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Filtered drop down list 2
Data validation list using filtered range 3
Filter a Drop List ? 1
Validation Filtering 1
Combining two non-contiguous lists into one for data validation, with one range being dynamic 0
alt down arrow shortcut not working 0
Filter lists 2
Drop Down Lists - Shrinking the List 5

Back
Top