How do I create/filter a list of names without duplications
 

I have a list of names some of which appear more than once. How do I
create/filter this column to produce a list of names without duplications?

Click on the first name in the list. Then go to "Data", then "Filter", then
"Auto Filter".

"MikeD" wrote:

I have a list of names some of which appear more than once. How do I
create/filter this column to produce a list of names without duplications?

Mike

Select your range then DataFilterAdvanced Filter.

"Unique records only" and "Copy to a new location" if don't want

"filter in place".


Gord Dibben Excel MVP

On Thu, 6 Oct 2005 07:16:14 -0700, "MikeD"
wrote:

I have a list of names some of which appear more than once. How do I
create/filter this column to produce a list of names without duplications?