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

M

MikeD

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?
 
J

JR

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

Gord Dibben

Mike

Select your range then Data>Filter>Advanced Filter.

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

"filter in place".


Gord Dibben Excel MVP
 
Top