Skip to content
Related Articles

Related Articles

How to Find Duplicates in Excel?

View Discussion
Improve Article
Save Article
  • Difficulty Level : Expert
  • Last Updated : 15 May, 2021
View Discussion
Improve Article
Save Article

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 :

Start Your Coding Journey Now!