Comments on: How to compare two columns in Excel and delete duplicates (highlight, color, move)

It will take you about 10 minutes to read this article and in the next 5 minutes (or even faster if you choose the 2nd solution described in the article :) you will easily compare two Excel columns for duplicates and remove or highlight the found dupes. Okay, the countdown is started! Continue reading →

Comments page 3. Total comments: 74

  1. Merely wanted to mention I am lucky that i stumbled upon your site.

  2. Ok, now this is the working one:

    =IF(ISERROR(MATCH(B1;$A$1:$A$10000;0));”Unique”;”Duplicate”)

  3. oh thank god for this article. Can't believe how hard it is to find info online on comparing two columns and deduping.

  4. It highlights the B1,$A$1 part.

  5. First of all, thanks for the article, but...
    This formula doesn't work for me:

    =IF(ISERROR(MATCH(B1,$A$1:$A$10000,0)),"Unique","Duplicate")

    1. Hi, I completely understand your question. This was the same problem with me in excel.

      And then I got a YouTube channel ( Learn With Lokesh Lalwani) I always learn everything about the excel this channel. I would like to suggest that you can also learn from this channel.

      Thanks

  6. You just saved me a ton of stress.

    I really really appreciate you for this.

    From Nigeria, Regards!

    1. It didn't work for me either. But this did
      =IF(ISERROR(MATCH(B2|$A$2:$A$10000|0))|"Unique"|"Duplicate")

  7. Awesome, just as you said took few min to read the article and my job was completed in less than a min.

  8. I can't believe you taught me how to use Excel. Usually it seems so opaque that I give up before trying.

    Thanks!
    Alex

  9. Thanks for the help. This worked like a charm!!!

  10. To the point information, very nice, thx for sharing this information.

  11. Thanks for sharing.

  12. Thanks for sharing. Its very useful :)

  13. Really this article is very useful one.

  14. This is a great well written guide. Thanks for the help.

  15. Thanku so much , Really save lot of work and efforts..

  16. Thank you so much... saved me hours of work.
    Malene

  17. Big Thankyou for the clear and immensly helpful tips. Also thanks to Google for searching your link for me :)

  18. Thanks this puts me in safe hands of the excel

  19. Thanks for sharing it. It is a great help to me in fulfill a project which is based on excel sheet. Thanks once again.

  20. Ur post is superb. Thanks for doing it and educating us.

  21. Awesome, very helpful.
    Thanks for posting.

Post a comment



Thank you for your comment!
When posting a question, please be very clear and concise. This will help us provide a quick and relevant solution to
your query. We cannot guarantee that we will answer every question, but we'll do our best :)