How to Find Duplicates in Excel?

Duplicates are those which appear more than one time. In this article, we will look at how we can find Duplicates in Excel. 

To do so follow the steps below:

Step 1: Formatting data. 

Step 2: Finding duplicates element in the column 

First, highlight the data in which we want to see whether there are any duplicate elements or not.

Step 3: Then, click to Home on the Ribbon. In the Styles group, click Conditional Formatting.

Step 4: In the resulting menu, click Highlight Cells Rules.

Step 5: Then in the resulting menu, click Duplicate Values…

Step 6: In the Duplicate Values box we have to select the formatting which we want to apply to the duplicate values, and then click Ok.

We will find the duplicates elements.