Excel compare two columns for matches and highlight

When you want to compare values in different columns in Microsoft Excel, you can use more than just your eyeballs. You can highlight unique or duplicate values, display True or False for matches, or see which exact values appear in both columns.

How to find duplicate values in excel using formula

How to find duplicates in two columns in excel

Excel compare two columns for matches

How to find duplicates in two columns in google sheets

How to find duplicates in excel

We’ll show you how to compare two columns in Excel using five different methods. This lets you choose the one that best fits your needs and the data in your Excel worksheet.

Highlight Unique or Duplicate Values With Conditional Formatting

If you want to spot the duplicates or the unique values in your columns, you can set up a conditional formatting rule.

Once you see the values highlighted, you can take whatever action you need.

How to find duplicate values in two columns in excel using vlookup

Using this method, the rule compares the values in the columns overall, not per row.

1. Select the columns you want to compare. Then, go to the Home tab, open the Conditional Formatting drop-down menu, and choose New Rule.

1. Pick Format only unique or duplicate values at the top of the New Formatting Rule box.
2. In the Format all drop-down box, choose either unique or duplicate, depending on which yo
   how to find duplicates in two columns sql
   how to find duplicates in multiple columns excel