How do I filter names in Excel to eliminate repeats?

G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Remove Repeats in a Column 3
Separate Names 3
Combine multiple columns and rows for one record into one row. 2
Transfer specific clients. 2
Excel Linking Multiple cells to One cell for Results 0
vlookup using match and date range 1
Multiple Iifs 4
Summing Fields with Multiple Criteria 1

Top