
How to Compare Two Columns in Excel to Find Matches
Compare two Excel columns for matches or differences using Conditional Formatting, a simple formula flag, COUNTIF or MATCH, and Go To Special row differences.
6 min read
Everything tagged Data Cleanup.
2 articles

Compare two Excel columns for matches or differences using Conditional Formatting, a simple formula flag, COUNTIF or MATCH, and Go To Special row differences.

Use the Data tab's Remove Duplicates tool to delete repeat rows, and see why highlighting them with Conditional Formatting first is the safer move.