Count how many times a number shows up in a list

[lamore48]

Hi All,
I have a question, if I have a list of numbers in different cells I want to count how many times each occurrence of each number comes up. The data looks like this:

3
6
9
12
19
4
10
3
6
8
4
12
11
9


The data would be like 200 lines long, so I need to know how many times for example the #10 came out, the #4 so on and so forth.


Thanks,
Lenny

 

[Joe4]

You can do that with the COUNTIF function.
See: MS Excel: COUNTIF Function (WS)

 

[My Aswer Is This]

Try this:
=COUNTIF(A:A,B1) To find out how many times the value in cell B1 is in column "A"