On Sep 5, 11:53*pm, K wrote:
Good day.

How do I take a cell (I15)'s result for example say it is 10 and have column
A put 1 to 10 from A1 - A10 or in the respected fields? And if the result
changes to 20 say it fills in the cells from A1 - A20 with 1,2,3, etc. to 20?
is this possible?

Kyle

One way...

=IF($I$15-ROW(1:1)=0,ROW(1:1),"")

filled down as far as needed.

Ken Johnson