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?