Question

[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

 

[Peo Sjoblom]

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

 

[dhagans]

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

 

[Gord Dibben]

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

 

[dhagans]

Gord,

Thanks a bunch. You all are a life saver.
It worked perfectly.

Thanks,

Darrell

 

[Peo Sjoblom]

Thanks for the heads up Gord. It's the absence of quality hockey here in the
US and especially in D.C. <g>

 

[Gord Dibben]

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