Duplicate Count Formula

[Ivan Howard]

Hi All,

I need a formula that counts the number of duplicates within a range. Any ideas?

Thanks a lot.

 

[Domski]

Hi,

Maybe something like: =SUMPRODUCT(--(COUNTIF($A$1:$A$10,$A$1:$A$10)>1))

Hope it helps,

Dom

 

[Ivan Howard]

Fantastic - that's exactly what I needed.

Thanks very much Domski!
Ivan