Skip to content
Related Articles

Related Articles

Improve Article

How to Find Duplicates in Excel?

  • Difficulty Level : Expert
  • Last Updated : 15 May, 2021

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.

My Personal Notes arrow_drop_up
Recommended Articles
Page :