Compare Two Columns in Excel to Find Differences or Similarities

This video demonstrates how to compare two columns in Excel to find similarities or differences. We look at two methods, one using conditional formatting and the other using a formula.

This video will be useful to you if you are asking the following questions:
How do I compare two columns in Excel?
How do I check if two columns match in Excel?
How do I compare two columns in Excel using Vlookup?
How do I compare two sets of data in Excel?
How do I find duplicates in two columns?
How do I compare two columns for differences?
How do I compare two columns and return common values?
How do I match two columns and output a third column?
How do I find duplicates in two columns using Vlookup?
What is the formula to compare two columns and return a value?
------------------------

[Chrisbajs]

I often come back to this video. Short, consise and to the point.

[justgainz]

Exactly what I needed! All the other videos on YouTube are so involved, needed this.

[savaskazantzides]

Well done! Clear, fast and effective explanation. You rock!

[a_wee_scotch]

Good videos. Clear explanation, succinct and explaining method best suited to different needs. Thank you.

[lemuelisaac]

After long search, the Vlookup step youve explained here helped me crack it. cheers Chester. Thanks.

[bernieryan]

Thank you! Now I don't have to stay up all night doing tedious comparisons. Well done!

[dannymorrison]

Great video! Thank you so much!! I’m wondering if there’s a way to than count the duplicate or unique values in a column?

[Chrisbajs]

Thanks again, saves me a lot of work at my office, this video

[robertcassina]

Thank you for taking the time to create this instruction video, this is exactly what I was looking for :)

[maxw-h]

Hi Chester. Is it possible to extract the old values and automatically add them into another column. For example, I have 2 lists; A and B. I want to extract data from list A, that does not appear in list B, and put that data into list C. Thanks.

[bolanleiyowu]

Thank you so much! this is so helpful!

[Lordxfx]

Very nice. I needed this. But how can I make the formula to not be case sensitive ?

[sdrawdy]

Thank you! You’ve saved me a whole lot of time!! 💕

[paxvidz]

Thank you much for sharing this. @Chester Tugwell you saved me hours of work.

[cianog]

Can you match rows that have slight differences. Example would be a full stop after the name in one column but not in the corresponding table?

[je]

Can you do one where it shows how to calculate the % increase in customer spending from Jan compared to Feb? Same spreadsheet you are using.

[RaviPahwa-bt]

ISTEXT at the beginning of Vlookup somehow return the same value