Need a formula to count the count of duplicate values

[ykamble]

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....!!

[Bob Phillips]

Do you want to try that one again?

[NBVC]

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)