Compare Two Columns in Excel (for Matches & Differences)

In this video, I will show you six examples to compare two columns in Excel for matches and differences.
------------------------------------------------------------------------------------------------------------------------------------------
00:00 Intro
00: 10 Compare two columns based on row values
01:04 Compare and highlight values that are in both the columns (using conditional formatting)
01:42 Compare and highlight values that are in one column and not in the other column
02:17 Find names that are in column 1 and not in column 2 (using VLOOKUP)
04:05 Lookup and get matching data point
04:37 Pull matching data point when there is a partial match
------------------------------------------------------------------------------------------------------------------------------------------

Based on your dataset, you may need to change or adjust the method. However, the basic principles would remain the same.

This YouTube channel is managed by Sumit Bansal (who also runs the TrumpExcel website). This channel is meant for people who want to learn Excel.

It covers a lot of Excel basics and advanced Excel topics such as Excel Formulas, Functions, Pivot Table, Shortcuts, Excel VBA, Macros, Excel Dashboards, Excel Charts, Conditional Formatting, Power Query, etc. Please subscribe to this channel to be the first to know when new Excel tutorials come out.

⚙️ Gear I Recommend:

Note: Some of these links here are affiliate links!

#Excel #ExcelTips #ExcelTutorial

[Superztar]

Best instructions on YouTube. Simple and quick. Let’s say I’ve been looking for a straight forward video for hours and nothing. What a life saver. Thanks!

[erwinargyle]

All instruction videos should be like this. You provide the easy answer and then peel layers to get to the complete solution. You set the bar high. Well done.

[RobertProlPMP]

You win the Internet today. Simple and focused instructions anyone can follow. Thank you!

[ricardovergara]

This has been the most valuable content I've seen on youtube in a long time. Thank you.

[thabonape]

You sir deserve an award for this presentation. The most insightful I've seen on YouTube, hands down. I'm wow'd.

[sachinkumarg]

I had watched many videos on Excel. The way you have explained I have never seen other. Very crisp explanation covering all possible combinations to work. Thanks a lot!!!

[adefisayoakande]

one of the few videos I have watched from an Indian instructor that is straight to the point and I didn't have to fast forward until the middles of the video to get the main point.

[SallijaBule]

Watched through so many youtube videos of this topic of 15, 10, 20 mins, but none of them covered the uses and most importantly, the RESULTS I was searching for! Thank you!

[ivandemiguelurain]

1, 000, 000 times more informative and useful that "official" Excel Help. Thank you!

[mibraheem]

Brother- You are an angle for me- Thankyou Thankyou Thankyou soo much- One of your formula has made up my Life- TY again- God bless you-

[tamarastewart]

You just saved me so much time sifting through transactions to find the discrepancy! Unbelievable. Thank you for sharing!

[desireepinsent]

I just stumbled upon your video when I did a google search on how to compare data in Excel. Thank you, Sumit, this is FANTASTIC and just what I needed. Easy to understand and follow. I've subscribed and look forward to more learning.

[piyushverma]

sir, you are real teacher with the best intentions. Thanks

[sanjeevkumar-vzxg]

One of the most informative video in excel.
Content, delivery, presentation all superb
Usually I don't comment on any video, but the quality of this video bound me to praise it.👌

[NahanCentral]

Age is no bar for learning.... I m a banker of age 47, just learning... due to my busy schedule i was thinking of these tricks to search on Y/Tube, today i got some time... and this first video has made me to so learned and happy that now i may save my valuable time and utilize it in more productive thank you so much for such a nice video and the way u explained it.... Keep going, Keep subscibed

[suwarnabaraskar]

most imp content that i found on youtube I search this concept on youtube but not available anywhere . Thankyou for this.

[lambportuza]

I did not find this useful, I found it EXTREMELY useful, thank you very much.

[aditya-tech]

Thanks bro... Finally, I got the result that I was looking for. Simplest, easiest and cleanest.

[nataliestubbs]

omg, this was soo helpful. I was having issues trying to find 10 names out of 1400 names on another listing and found them by using this.thank you.

[shrs.]

LIke many viewers have commented before, somehow I always find what I need in your channel - amazing!
Thank you so much.
Blessings from LA.