I'm trying to find out if it is possible to enter a series of numbers in
a single column, like

Column C
__________
1, 4, 5, 7, 9
1, 2, 5, 6, 7, 8, 9

and then construct a series of COUNTIF statements to tally up the numer
of times each acceptable value appears in the column.

So, for the example above, the results should be:

1 -- 2
2 -- 1
3 -- 0
4 -- 1
5 -- 2
6 -- 1
7 -- 2
8 -- 1
9 -- 2


Is this possible?

Thanks!


--
Steven Anthony


------------------------------------------------------------------------
Steven Anthony's Profile: http://www.excelforum.com/member.php...o&userid=24153
View this thread: http://www.excelforum.com/showthread...hreadid=377805