ExcelBanter - How do I filter names in Excel to eliminate repeats?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How do I filter names in Excel to eliminate repeats? (https://www.excelbanter.com/excel-discussion-misc-queries/86586-how-do-i-filter-names-excel-eliminate-repeats.html)

Scott

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

Ardus Petus

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

All times are GMT +1. The time now is 08:45 PM.