Question

  • Thread starter Thread starter dhagans
  • Start date Start date
D

dhagans

Hello! I'm new to the group and I'm working on an excel sheet.

What I'm trying to do is, in a column have a number ex. 36 repeat that
number 72 times and on the 73 row increase the number 36 by 1 (to 37).
I need to do it about 730 times.

I don't know where to start. I've tried to do an auto fill but it's
increments by a decimal.

The sheet should look like this.
Column A
36
36
36
36
36
(72 times)
37
37
37
(72 times)

Can anyone help?

Thanks,


Darrell
 
One way, put in row1

=FLOOR(36+(MOD(ROW(1:1)/73,72)),1)

copy down and it will change to 37 in row 73, to 38 in row 146 and so on,
once you are done copy it and paste special as values in place
 
Thanks Peo Sjoblom,

This worked fine until I got to number 107 in row 5256. Is ther
something that I'm doing wrong?

Thanks,

Darrel
 
Darrell

Change to =FLOOR(36+(MOD(ROW(1:1)/73,730)),1)

to get the 730 times.

Peo set it to repeat 72 times. Dyslexic fingers<g>

Gord Dibben Excel MVP
 
Thanks for the heads up Gord. It's the absence of quality hockey here in the
US and especially in D.C. <g>
 
You oughta see our Parksville Generals Junior B.

5-22-0 with the next two games against the 24-2-0 and 21-4-0 teams.

Rotsaruck.

Gord
 
Back
Top