HI all



Any idea's how to do this in excel, be gentle

I need to fill in rows cells a certain number of times...

c4 = 6 so fill in row e1 to e6 with the values 1 to 6
c5 = 4 so continue row e7 to e11 with the values 1 to 4
c6 = 5 continue row e12 to e17 with the values 1 to 5


help appreciated Phil.....

Enter in E1 and copy down:

=IF(ROWS($1:1)<=$C$4,ROWS($1:1),IF(ROWS($1:1)<=$C$ 4+$C$5,ROW()-$C$4,IF(ROWS($1:1)<=$C$4+$C$5+$C$6,ROW()-$C$4-$C$5"")))

If you start in another cell than E1, for example H8 the formula should look like this:

IF(ROWS($1:1)<=$C$4,ROWS($1:1),IF(ROWS($1:1)<=$C$4 +$C$5,ROW()-CELL("row",$H$8)+1-$C$4,IF(ROWS($1:1)<=$C$4+$C$5+$C$6,ROW()-CELL("row",$H$8)+1-$C$4-$C$5;"")))

The two CELL functions must have the start cell as second argument.

thanks for the reply

I don't think my explanation was very good.

c4 = 6 so fill in row e1 to e6 with the values 1 to 6
c5 = 4 so continue row e7 to e11 with the values 1 to 4
c6 = 5 continue row e12 to e17 with the values 1 to 5

all these numbers in column C are dynamic

c4 = 35
c5 =126
c6 = 1256
c7 , c8 etc ......down Column C

Help appreciated phil

What you wrote originally and what you write in line 3 to 5 above is exactly what my proposal does.

Attached Files

FillRow.xlsx (33.9 KB, 11 views)

That Works but not for me

I need to explain my problem more fully I have a formula that i repeat many times down, in cell a1 i have '=C1 * d1 /e1'

this formula is copied down 1000's times, however the value of C1 & D1 change intermittently
I want to automate the process the value of c1 & d1 will remain the same for 20 rows and then change to new values for a further 50 rows and this continues.

At the moment I have in cell C1 '=$F$1' & D1 '=$G$1' which is the first 20 rows then I manually change the value C1 to =$F$2 & D1 =$G$2 for 50 rows and so on

Again Be gentle and thank you for your help