Forum Discussion

JMFJones's avatar
JMFJones
Copper Contributor
Jun 20, 2019

Auto Fill using a formula

I am looking for a function that would allow me to auto fill  a certain number of rows based on data entered in the first row. So, say I want to fill 20 rows, I'd want the function to automatically ...
Formulas and Functions
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Jun 20, 2019

JMFJones 

 

In simple variant

in C4

=IF(ROW()-ROW(StartCell) <=CellsToFill, StartCell, "")

and drag it down with some gap against your possible range

  • Zack Barresse's avatar
    Zack Barresse
    Iron Contributor
    Jun 20, 2019
    Depending on the OP's actual needs, this is inherently bad practices, for the reasons I specified above. Also, when using named ranges in your formulas in lieu of absolute cell referencing, it's probably best to qualify them.

    Kind regards