Duplicated Names In List

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
 
G

Gord Dibben

Data>Filter>Advanced Filter.

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


Gord Dibben MS Excel MVP
 
Top