Thread: How do I filter names in Excel to eliminate repeats?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Scott
 
Posts: n/a
Default How do I filter names in Excel to eliminate repeats?
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