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