count the occurence of number in a column

L

Laura

hi,
may i ask: how do i count the occurence of a number in a column? an example:

1
5
8
1
3
4
1
5
1


occurence of 1 = 4
occurence of 3 = 1
occurence of 4 = 1
occurence of 5 = 2
occurence of 8 = 1

what would be the formula for that in excel, please? i have no clue at all.
i tried google and it came up with something but i could not really find the
answer to my question.
tks,

l.
 
Top