View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
cj21
 
Posts: n/a
Default counting numbers


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