How To Compare Columns To Find Duplicates

In this lesson you will learn how to find duplicates in Excel. This is quick way to search bunch of data in just a second.

You have 3 columns with data and you want to highlight duplicates.

Compare Columns Table

First select whole table.

Compare Columns Data

Go to the Ribbon. Home tab > Styles section. Click Conditional Formatting > Highlight Cell Rules > Duplicate Values

Compare Columns Duplicate Values

Dialog box appears. Choose how Excel will highlight duplicates.

Compare Columns Values

Excel highlights duplicates from your table.

Excel compare columns find duplicates

Template

You can download the Template here – Download