We show you 5 different methods
How to Compare Two Columns in Excel to Find Differences (The Easiest Way)
When you want to compare values in different columns in Microsoft Excel, you can use more than just your eyes. You can highlight unique or duplicate values, display True or False for matches, or see which exact values appear in both columns.
We'll show you how to compare two columns in Excel using five different methods, so you can choose the method that best suits your needs and the data in your Excel spreadsheet.
If you want to spot the duplicates or the unique values in your columns, you can set a conditional formatting rule. Once you see the values highlighted, you can take the desired action.
