how do i find and delete duplicates in excel worksheet?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have combined several mail list into one on excel workshett and have quite
a few dupicates. How can I find and delete duplicates?
 
I wasn't able to find anything in excel that would accomplish this. I had
the same problem and bought DIGDB and excel add in. I couldn't live
without, it is a wonderful tool to use in exel.
 
I use the following formula in a list to find duplicates. It doesn't auto
delete but helps you detect easily. Of course you need to ensure your list
is sorted alphabetically and then the formula looks above and below a line
for duplicate:

=IF(OR(A5=A6,A5=A4),"dup",0)
 
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

how do i combine excel worksheets 1
Duplicates Deletion ? 2
How do I display the file name in the worksheet? 4
remove duplicates but retain one not delete both 4
Navigating to Duplicates 2
How to find dublicates in Excel and delete it? 6
Deleting duplicate records 2
Entire Row Duplicates 6

Back
Top