Paste down where last number ended

[I.am.Rustam]

Hi Guys,

please help with this:

Column A:

Column B:
$ dollar value (eg. 10)

Column C:
number value (eg 3)

So I need to paste $10 in column A down 3 times. so it would be:

A1: $10
A2: $10
A3: $10
A4:
A5:

Now, in column E: (actually, it could be even the same cell in column B)
$ dollar value (eg $5)

Column F: (could be the same column C)
Number value (eg. 4)

So I need to paste $5 in column A down 4 times, but starting at where 10 dollars ended.

So it would look like this:

A1: $10
A2: $10
A3: $10
A4: $5
A5: $5
A6: $5
A7: $5

etc...

And I need to have at least 4, 5 bumps like that.

Please advise if you have any ideas!!!


Thanks a lot!

[jason.b75]

Try listing your dollar amounts in column B, starting in B1, and the number of times to repeat the values in column C.

Then enter this array formula in A1 and fill down until it returns a blank cell.

=IFERROR(INDEX(B:B,MATCH(TRUE,SUBTOTAL(9,OFFSET($C$1,0,0,ROW(INDIRECT("1:"&COUNT(C:C))),1))>=ROW(),0)),"")

*** note that this is an array formula and must be confirmed with Shift Ctrl and Enter, not just Enter ***

[I.am.Rustam]

Jason,

Thanks a lot. Works perfectly. I thought I was too confusing that I re-posted this question with the spreadsheet attached

Thanks again.