duplicate entries in rows

J

Jim

I have a list of names from a few different sources, I need to compile
them into one list, and would like to eliminate any multiple entries by
using, I'm assuming, a filter.

To clarify what I need, here is an example:
here are the rows:

mitch
gary
clark
mitch


I'd like to use a filter where I could select all of the names, and
eliminate the duplicate entry of the name "mitch". Is there any easy way
to do this? Thank you.
 
K

Ken

One way:

Highlight the column.
Go to Data>Filter>Advanced Filter...
Select Copy to another location.
In Copy to: enter B:B or whatever row you want.
Check the unique records only box.
Click OK.
 
Top