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

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.


Join Our Telegram Group techguruplus telegram group Join Our WhatsApp Group techguruplus whatsapp group
Nazim Khan - Author Image

Nazim Khan (Author) 📞 +91 9536250020
[MBA in Finance]

Nazim Khan is an expert in Microsoft Excel. He teaches people how to use it better. He has been doing this for more than ten years. He is running this website ( and a YouTube channel called "Business Excel" since 2016. He shares useful tips from his own experiences to help others improve their Excel skills and careers.

Leave a Comment