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
https://www.ablebits.com/excel-remove...
You can read a thorough post on this topic in our blog:
https://www.ablebits.com/office-addin...
