Do you want to try that one again?
Hello Friends,
Can somebody help me with the excel formula to get the count of Duplicate values in a list. I don't need the number time the duplicate values are appearing in a list. Need to know how duplicate values are duplicate.
Thanks....!!
Do you want to try that one again?
The easiest way is to first add a helper column to find those duplicates.
=COUNTIF($A$2:$A2,$A2)=2
copied down. As soon as a second is found, it is marked.
Then separately to get count of duplicates =COUNTIF(B:B,TRUE)
Bookmarks