double names in a list

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hell

I have a list of names in excel (about 29000), all I want is that the rows that contain double names will be deleted
Is that possible

thank you

Taco
 
Hello Taco,
I have a list of names in excel (about 29000), all I want is that the rows
Click to expand...
that contain double names will be deleted.
Is that possible?
Click to expand...

in Data/Filter/Advanced filter
you can select that no duplicates will be shown and you can output the list
without duplicates in a specified range.

bye

arno
 
Back
Top