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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Find consecutively and copy 2
Count Duplicates 8
Excel Excel attendance record 0
I want to count rows between the occurence of one word. 2
InputBox for a string of 2 to 3 keywords, separated with commas. 2
Show the occurence # of a recuring event 3
Counting occurences of text string in a text file 1
Skip later occurence in a series 2

Top