Simple Excel Formula Needed

[henio]

It's late on Friday (near deadline). I have a large number of rows which I need to number in groups of 24.

ie rows 1 - 24 each have 1001 in a column
rows 25 - 48 each have 1002
.. and so on.

I'm sure that a formula can be devised for this, but my brain is tired...

Cheers,

H

 

[Bowers74]

Assuming that your numbers start on row 1 of the worksheet, enter the following into the first cell and copy it down to the bottom:

=1000+(CEILING(ROW(),24))/24

I hope this helps!



Peace!

Mike

Never say Never!!!
Nothing is impossible!!!

 

[xlbo]

Try this:
=1001+INT(ROW()/24.1)

Rgds, Geoff
[blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244

 

[henio]

Thanks guys,

H

 

[Bowers74]

Glad we could help you meet your deadline . . hmm . . must've been pretty helpful - yet "simple"!!



Peace!

Mike

Never say Never!!!
Nothing is impossible!!!

 

[MJPPaba]

place in cell A1 1001
copy this down to cell A24.
Place in cell A25 =A1+1
Copy cell A25 all the way to the bottom of your data range.

cheers

Crazypabs