=COUNTIF(A:A,10)

etc.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"cj21" wrote in message
...

I have a list of numbers. e.g

10
10
5
0
5
10
20
25
20
15
60
60
10
20


I want a formula that tells me how many there are of each value. For
example, the number of 10's is 4, the number of 20's is 3.

Antone got any ideas?


Thanks

Chris


--
cj21
------------------------------------------------------------------------
cj21's Profile:
http://www.excelforum.com/member.php...o&userid=25673
View this thread: http://www.excelforum.com/showthread...hreadid=513150