J
JimmyH
Hi,
Is there a way to count specific numbers in a column and enter the number
into a new cell.
For example:
A B C D
1 1 1 2 3
2 1 2 3 4
3 2
4 2
5 2
6 3
7 3
8 3
9 3
Column A is the data, in B2 I want a function that counts the number of "1"s
in column A, in C2 the same function that counts the number of "2"s in A,
and so on. I am in need of the function.
Thanks in advance.
Marc
Is there a way to count specific numbers in a column and enter the number
into a new cell.
For example:
A B C D
1 1 1 2 3
2 1 2 3 4
3 2
4 2
5 2
6 3
7 3
8 3
9 3
Column A is the data, in B2 I want a function that counts the number of "1"s
in column A, in C2 the same function that counts the number of "2"s in A,
and so on. I am in need of the function.
Thanks in advance.
Marc