Formula/Macro to tally up numbers in Excel

M

Mark

I have a list of numbers in a column, e.g. :-

1
4
6
1
35
14
15
15
2
1
6
6
1
19
15
5

and want the computer to work out for me, how many times number x has
turned up in column B?

I presume this is possible with a function/macro within excel fairly
easily? Any advice/pointers in the right direction would be
appreciated.

Please prefably reply in the newsgroup, or via email to
"[email protected]", removing the .DELETE from
the end of my address.


Thanks, Mark Pyne
 
A

Andy B

Hi

Have a look at COUNTIF() and try something like:
=COUNTIF(B:B,1) to count how many 1s there are etc
 
M

Mark

Hi

Have a look at COUNTIF() and try something like:
=COUNTIF(B:B,1) to count how many 1s there are etc
Click to expand...

Works perfectly for my task, many thanks ! :)

Mark Pyne
 
Top