How to Find Duplicates in Excel within 10 Seconds (with Example)

how to find duplicate in excel

Within 10 seconds we can find duplicates in excel. Finding duplicates in a excel sheet is very easy now these days, we don’t need any type of formula for it. We just need to follow these steps and we can find duplicate cells.

How to Identify Duplicates in Excel :

To find duplicates in excel we will take an example as given in image below

Example for how to find duplicates in excel :

find duplicates in excel

  • First of all we need some data to trace duplicate cells in excel, so we have taken above sheet, now Go to Home tab and click on “Condition Formatting” in button then click on “Highlight Cells Rules” Now click on  “Duplicate Values” .

find duplicates in excel

  • Now Just click on “OK” Button and your duplicate content is Highlighted with Red Color in Excel Sheet Cells.

find duplicates in excel

So Friends this is done !! we have find duplicate data in our excel sheet by data validation option. Actually Data Validation is a very useful option in excel with the help of which we can do many more things. in our next article we will tell you more things about data validation.

if you have any suggestion or any question, you can comment in the comment box, we will solve your query as soon as possible.

 

Leave a Reply

Your email address will not be published. Required fields are marked *

*