How do I filter names in Excel to eliminate repeats?

Giganews Newsgroups
Subject: How do I filter names in Excel to eliminate repeats?
Posted by:  Scott
Date: Wed, 3 May 2006

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

Replies