Duplicated Names In List

  • Thread starter Thread starter mik00725
  • Start date Start date
M

mik00725

Hello all !!

I have in column A list of over 1,000 names. In this list the name
are duplicated. How can I filter/retrieve or modify this list to hav
all the names but not duplicated.


You help is greatly appreciated.
MI
 
Data>Filter>Advanced Filter.

"Unique records only" and "Copy to a new location".


Gord Dibben MS Excel MVP
 
You must log in or register to reply here.

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

Single list ~ not duplicates 3
is there a simple formula that will remove all duplicates in a simple list 1
duplicates 1
Duplicates Deletion ? 2
Best solution to merge multiple Outlook contacts easily 2
VBA - retrieve data on last create named range from previous inserted named range 0
Delete Duplicates: Sum values & Consolidate 1
Count how many different cells are in a range 1

Back
Top