Compare Two Columns in Excel to Find Differences or Similarities

W vid

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?

Crisp and clear, thanks!

Really useful, thanks!

ISTEXT at the beginning of Vlookup somehow return the same value

This was perfect. Thanks mate

Great video!

Yes! Very clear. Well done indeed.

Thanks!

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

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

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

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

Brilliant video and tip!

Very informative and useful. Thnx

Thank you so much! this is so helpful!

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

Beautiful. Thank you X

Great! Thank you so much!

Thank you !..:)

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?

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.

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

Thankyou so much :)

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

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.

Clever 👌👌👌👌