How to compare 2 columns in Excel for matches and differences




About this tutorial:

Video duration: 5:16
See 3 simple ways to compare two columns in Excel:
– Use the combination of IF and COUNTIF functions
– Conditional Formatting
– or Duplicate Remover add-in

You can read a thorough post on this topic in our blog:

Post Author: OfficeTutes.com

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads

12 thoughts on “How to compare 2 columns in Excel for matches and differences

    Kenny Akinnuoye

    (February 14, 2020 - 10:37 pm)

    Wish I could see what the typed there last…smh 2:48

    Alan Pontius

    (February 14, 2020 - 10:37 pm)

    This really helped. I was making a simple mistake but could not see what I was doing wrong until watching this.

    Karin Abidin

    (February 14, 2020 - 10:37 pm)

    hi, what is the name of the add-in. thanks

    CSM1470

    (February 14, 2020 - 10:37 pm)

    This is what I was looking for within my lottery spreadsheets. AWESOME!!

    Rob aka The Property Guy Germany

    (February 14, 2020 - 10:37 pm)

    Worked thanks!

    Daniel Rodriguez

    (February 14, 2020 - 10:37 pm)

    I haven't finished my spreadsheet, but thank you very much for this information, it's extremely useful

    Marigold G

    (February 14, 2020 - 10:37 pm)

    Super thank you for this! God bless!

    Rom Leibner

    (February 14, 2020 - 10:37 pm)

    best video on youtube !!

    Kevin May

    (February 14, 2020 - 10:37 pm)

    I love Douglas Adams' books! Saw them there at the top of the list.

    lavandar87

    (February 14, 2020 - 10:37 pm)

    This just saved me hours and hours of work. Thank you for your help.

    Joseph Craig

    (February 14, 2020 - 10:37 pm)

    This did exactly what I needed it to. Thanks!

    Aaron Chacon

    (February 14, 2020 - 10:37 pm)

    I need to find a way to compare number sets on sheet 1 and sheet 2 and have sheet 2 show the rise and fall of values from sheet 1

Leave a Reply

Your email address will not be published. Required fields are marked *