How to Remove Duplicate Customers in a File

L

la90292

I have copied to separate customer list into one list and now need to remove
any duplicate customers. How would I do that.

Thanks,
victor
 
B

Bob Umlas

Select the column, use Filter/Advanced filter, check the Unique checkbox,
copy to another location, enter the address for the new location and you
will have a new list containing only the unique items.

Bob Umlas
Excel MVP
 
Top