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.

[@bernieryan8717]

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

[@savaskazantzides]

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

[@lemuelisaac9386]

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

[@Chrisbajs]

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

[@ChesterTugwell]

Many thanks

[@robertcassina3953]

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

[@a_wee_scotch4813]

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

[@jared8038]

This was perfect. Thanks mate

[@sdrawdy6816]

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

[@souravmukherjee01]

Very informative and useful. Thnx

[@chickencoopblue9813]

Brilliant video and tip!

[@BenMatern]

Really useful, thanks!

[@bolanleiyowu2072]

Thank you so much! this is so helpful!

[@MiaryMathieu]

Thank you very much, sir !

[@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.

[@donna8]

Beautiful. Thank you X

[@someofmythoughts]

Great! Thank you so much!

[@je2993]

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.

[@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?

[@cIownie]

im lookin for this too. any luck?

[@paxvidz4727]

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

[@suchetagw]

Thankyou so much :)

[@Prashanthmuthu]

Thank you !..:)

[@Chrisbajs]

Thanks!

[@ChesterTugwell]

Many thanks for your gift - much appreciated.

[@Bramandin]

W vid

[@dhunpagla3871]

Clever 👌👌👌👌

[@dyingimmortal]

Great video!

[@RaviPahwa-b1t]

ISTEXT at the beginning of Vlookup somehow return the same value

[@dannymorrison4978]

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?

[@justgainz4407]

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

[@64mustangfan]

Crisp and clear, thanks!

[@mustang5gtx]

Yes! Very clear. Well done indeed.

[@Lordxfx]

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

[@Lordxfx]

Data set contained trailing spaces after the values.