=SUMPRODUCT(--(COUNTIF(A1:A10,A1:A10)=1))

will count the numbers that occurs once

for twice

=SUMPRODUCT(--(COUNTIF(A1:A10,A1:A10)=2))/2

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey


"new2XL" wrote in
message ...

thanks for the input, that wasn't quite what I was looking for.

If anyone else understands this issue and is the having the same
problems, see this link:

http://www.ozgrid.com/Excel/count-list.htm


--
new2XL
------------------------------------------------------------------------
new2XL's Profile:
http://www.excelforum.com/member.php...o&userid=35161
View this thread: http://www.excelforum.com/showthread...hreadid=549290