How to Remove Duplicate Customers in a File

  • Thread starter Thread starter la90292
  • Start date Start date
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
 
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
 
Back
Top