Thread: How do I filter names in Excel to eliminate repeats?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ardus Petus
 
Posts: n/a
Default How do I filter names in Excel to eliminate repeats?
Have a look at Menu DataFilterAdvanced filter (no dupes)

HTH
--
AP

"Scott" a écrit dans le message de news:
...
I have a list like this:

John Doe
John Doe
Mike Martin
Nancy Smith
Nancy Smith
Nancy Smith

I want to get it like this:
John Doe
Mike Martin
Nancy Smith

John Doe
Nancy Smith
Nancy Smith


Reply With QuoteReply With Quote