Count entries in list

[KiwiBrian]

I have a list in Column A of a mix of 100 numbers between 1 and 9.
How do I create a report/table/list/??? showing me how many entries there
are of each number?

e.g.

1 15
2 7
3 26
4 21
5 3
6 13
8 4
9 11

I do not have to deal with exceptions, missing entries, 0s etc as none of
these situations will occur.

Many thanks
Brian Tozer

 

[Guest]

use the countif function

 

[Gord Dibben]

Brian

Assume numbers are in A1:A100

In B1 enter =ROW() & "'s " & COUNTIF($A$1:$A$150,ROW())

Copy down to B9.

If you wish to use the results as numbers, just enter

=COUNTIF($A$1:$A$100,ROW())

NOTE the Absolute cell reference for $A$1:$A$100

Gord Dibben Excel MVP