Home Excel Tips and Tricks How to compare columns to find duplicates?

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

Further reading: 
Basic concepts 
Getting started with Excel
Cell References