Google Sheets - Compare Two Lists for Matches or Differences

Learn how to identify repeated values in your spreadsheet table. We discuss a method using conditional formatting and one using an IF function.

Timestamps:
0:00 Intro
0:23 Conditional Formatting
3:06 IF Function

Learn more from Prolific Oaktree:

#googlehseets #spreadhseet #conditionalformatting

[World]

This just saved me like 4 hours of comparing thank you so much!

[PianoWithJonny]

Thank you SO MUCH!! I've looked through so many tutorials on YouTube trying to figure this out and no one could explain it as simply as you did. Thank you!!

[SylvioMedeiros]

Looks like every 2 months or so i have to go back to this video, its so good. Save me hours of work in less than 3 minutes

[joycefamilara]

LIFESAVER! I could almost cry. Every other solution was so complicated compared to yours. Thank you!

[thomasfox]

Thank you for such a quick, clear instruction. The time invested in your video and building the formula has saved me hours already.

[tomcha]

Thank you for the short and sweet tutorial. Exactly the function I was looking for.

[kaiawang]

I've watched multiple videos and read articles on this problem and yours is the easiest to follow! Thank you so much!! Wondering how to organize all the highlighted cells in one column... Again thank you!

[bewatter]

Bro i appreciate it!!! For people who dont know if you have values in your sheet you have to first format it into numbers. Thats why i kinda lost to much time on my work LOL

[nicolemasureik]

That was THE MOST HELPFUL video I have seen on using custom formula to identify duplicates! Thanks!

[annczeponis]

This was so amazing - trying to do attendance for an entire school for our new remote learning due to school closures. What a lifesaver - stay well.

[GunHudson]

Amazing tutorial. I could listen to your voice all day, your mic + voice + your explaining style is one of the best tutorial voices I've heard. :)

[michaelbodner]

Thanks for this- clear, concise, and it works! Much appreciated.

[matthewrowlands]

I watched about 347 tutorials trying to find how to do this. Brilliant thanks

[likewhaaaat]

Thank you SO much! This was EXACTLY what I was looking for! Seriously appreciate it!

[pedroestima]

Just saved hours of manual work. Thank you very much!!!!

[TAP]

Yep, exactly what I was looking for and thanks for using simple data for the demostration

[davideckhardt]

How could you select the matching values and add just those values to a new column?

[alphabeta]

Thanks so much, finally found a match to my requirements. Tried earlier with IFS, OR but MATCH functions seems so much better. Thank you!

[teddypcadieux]

This is amazing!! Thanks so much, saved my life!

[austiningram]

Awesome, clear, visual. Thank you very much Professor Oak!