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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Auto Matching Duplicates? 0
Conditional Formatting Tricky question 5
- Need Help Finding Duplicate Customers 1
Best Gmail Backup Tool to use in 2025? 3
Best solution to merge multiple Outlook contacts easily 2
Identifying Duplicates in Multiple Sheets 4
Display duplicate records? 8
Display only duplicate values and delete UNIQUE Items 2

Back
Top