Excel Help
Posted by MaryKay Tesoro on October 26, 2001 6:27 AM
Hi - Was wondering if you could help me. I have a column of random numbers from 0-18. I need to count the column and determine how many 0's, 1's, 2's, etc. appear.
Ex:
1
4
5
1
0
5
I need the next column to show that there is 1-0, 2-1's
2-5's etc. Any idea. Please advise. I appreciate a quick response if possible. It is for work. Thx - MK
Posted by Bob Umlas on October 26, 2001 6:29 AM
------------------------
=countif(A1:A18,1)
=Countif(A1:A18,2)
etc.
If you put 0,1,2... in col C, say, then you can enter & fill this down:
=Countif($A$1:$A$18,c1)
Posted by Juan Pablo on October 26, 2001 8:06 AM
You could use Pivot tables, or check out
