How to compare 2 columns in Excel for matches and differences

See 3 simple ways to compare two columns in Excel:
- Use the combination of IF and COUNTIF functions
- Conditional Formatting
- or Duplicate Remover add-in

You can read a thorough post on this topic in our blog:

[lavandar]

This just saved me hours and hours of work. Thank you for your help.

[Danilo]

I haven't finished my spreadsheet, but thank you very much for this information, it's extremely useful

[lotteryplayer]

This is what I was looking for within my lottery spreadsheets. AWESOME!!

[KevinMay]

I love Douglas Adams' books! Saw them there at the top of the list.

[GerardoEnriqueHerasAraujo]

hi, I need to compare two columns, for similar data, but no identical, we have a function to do that, thanks

[karinabidin]

hi, what is the name of the add-in. thanks

[aaronchacon]

I need to find a way to compare number sets on sheet 1 and sheet 2 and have sheet 2 show the rise and fall of values from sheet 1

[kennakin]

Wish I could see what the typed there last...smh 2:48