Compare Two Columns in Excel to Find Differences or Similarities

[@Chrisbajs]

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

[@ChesterTugwell]

Many thanks

[@Chrisbajs]

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

[@justgainz4407]

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

[@lemuelisaac9386]

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

[@a_wee_scotch4813]

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

[@savaskazantzides]

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

[@bernieryan8717]

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

[@64mustangfan]

Crisp and clear, thanks!

[@Chrisbajs]

Thanks!

[@ChesterTugwell]

Many thanks for your gift - much appreciated.

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

[@robertcassina3953]

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

[@jared8038]

This was perfect. Thanks mate

[@paxvidz4727]

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

[@BenMatern]

Really useful, thanks!

[@R4venSt0ne]

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.

[@chickencoopblue9813]

Brilliant video and tip!

[@souravmukherjee01]

Very informative and useful. Thnx

[@bolanleiyowu2072]

Thank you so much! this is so helpful!

[@mustang5gtx]

Yes! Very clear. Well done indeed.

[@sdrawdy6816]

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

[@donna8]

Beautiful. Thank you X

[@someofmythoughts]

Great! Thank you so much!

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

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

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

[@suchetagw]

Thankyou so much :)

[@Prashanthmuthu]

Thank you !..:)

[@RaviPahwa-b1t]

ISTEXT at the beginning of Vlookup somehow return the same value

[@dhunpagla3871]

Clever 👌👌👌👌

[@Bramandin]

W vid