I have a column of numbers ranging from 1 to 365.

What I want to do is produce a table that says something like:

Days Count
365 1000
364 25
363 47
etc...

So in the example above the column of numbers has 1000 entries at 365 and 25
at 364

Is there any way of doing this?

On a new sheet, enter 365 In A2, 364 in A3, select both and drag-copy down
to 1

In B2, add

=COUNTIF(Sheet1!A:A,A2)

and copy down

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Keith" wrote in message
...
I have a column of numbers ranging from 1 to 365.

What I want to do is produce a table that says something like:

Days Count
365 1000
364 25
363 47
etc...

So in the example above the column of numbers has 1000 entries at 365 and
25
at 364

Is there any way of doing this?

"Bob Phillips" wrote:

On a new sheet, enter 365 In A2, 364 in A3, select both and drag-copy down
to 1

In B2, add

=COUNTIF(Sheet1!A:A,A2)

and copy down

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Keith" wrote in message
...
I have a column of numbers ranging from 1 to 365.

What I want to do is produce a table that says something like:

Days Count
365 1000
364 25
363 47
etc...

So in the example above the column of numbers has 1000 entries at 365 and
25
at 364

Is there any way of doing this?


Thanks for that. It worked a treat.

Keith

You can try the Data, Subtotals command, but will have sort the table on Days
first
HTH
Sheila
www.c-i-m-s.com

"Keith" wrote:

I have a column of numbers ranging from 1 to 365.

What I want to do is produce a table that says something like:

Days Count
365 1000
364 25
363 47
etc...

So in the example above the column of numbers has 1000 entries at 365 and 25
at 364

Is there any way of doing this?