How do I filter names in Excel to eliminate repeats?

[Scott]

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

 

[Ardus Petus]

Have a look at Menu Data>Filter>Advanced filter (no dupes)

HTH