Count entries in list

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

KiwiBrian - 07 Sep 2004 06:55 GMT

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

Reply to this Message

- 07 Sep 2004 06:56 GMT

use the countif function

> 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
[quoted text clipped - 16 lines]
> Many thanks
> Brian Tozer

Reply to this Message

Gord Dibben - 07 Sep 2004 19:45 GMT

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

>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
[quoted text clipped - 16 lines]
>Many thanks
>Brian Tozer

Reply to this Message