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