Count
 

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


--
Gaza
------------------------------------------------------------------------
Gaza's Profile: http://www.excelforum.com/member.php...o&userid=36663
View this thread: http://www.excelforum.com/showthread...hreadid=566378

Count
 

This website should help

look up "Counting Unique Entries In A Range"



http://www.cpearson.com/excel/duplicat.htm

VBA Noob


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=566378

Count
 

Thanks VBA Noob
I will check it out


--
Gaza
------------------------------------------------------------------------
Gaza's Profile: http://www.excelforum.com/member.php...o&userid=36663
View this thread: http://www.excelforum.com/showthread...hreadid=566378

Count
 

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

--
HTH

Bob Phillips

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

"Gaza" wrote in message
...

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


--
Gaza
------------------------------------------------------------------------
Gaza's Profile:
http://www.excelforum.com/member.php...o&userid=36663
View this thread: http://www.excelforum.com/showthread...hreadid=566378