Count

G

Gaza

Hi
Can someone help me with a cal I have been trying to do
I want to be able to put a formula at the bottom of a sheet that will
return a count of 1 if the number is repeated more than once,this could
have as many as 50 entries or more
1234
7856
1234
2589
= 3
Thanks
Gaza
 
B

Bob Phillips

=SUMPRODUCT((A2:A200<>"")/COUNTIF(A2:A200,A2:A200&""))

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
Top