Summarising a column of numbers

K

Keith

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?
 
B

Bob Phillips

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)
 
K

Keith

Bob Phillips said:
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)




Thanks for that. It worked a treat.
Click to expand...

Keith
 
Top