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.
