In this post I am going to show you on how to identify duplicate entries in your excel sheet step by step.

Lets Get Started.

Step 1: Open Your Excel sheet you want to check duplicate entries.

Step 2: Add a new column besides the column you want to check the duplicate entries

Step 3:Select the adjacent cell to the first cell you want to check duplicate entries and paste this code:

=IF(MAX(COUNTIF(A1:A11,A1:A11))>1,”Duplicate”,”No Duplicate”)

Step 4: Change A1:A11 to correspond your cell labels in our case it’s D4:D28.

That’s all Now will see all duplicate entries.