numbers in sequence =IF(ROW()-ROW(A$8)<=B3,ROW()-ROW(A$8),"")

[anillinda]

I would like to populate a value in cell say
a9 to a50 based on a value in cell say g5

I want to populate cells from a9 to a50 based on the following conditions:

the cell a9 will be 1 and the value cannot exceed the value in cell g5

assuming the value in g5 is 20, then the cell values from a9 to a50 must begin at 1 and terminate at 21.

Thank you,

I used the following but refinement of formula would be appreciated:
=IF(ROW()-ROW(A$8)<=B3,ROW()-ROW(A$8),"")

 

[pgc01]

Hi

In A9:
=IF(ROWS($A$9:A9)<=$G$5,ROWS($A$9:A9),"")

Copy down till A50