Jun 23 2021 11:44 AM
Hello, I am in need of assistance with the "Fill Series" option with a log I am creating for my employer.
I need for a number that is populated from an input cell to be able to perform the "Fill Series" option when pulling down the number.
If the number is populated into the receiving cell (Example 2 Cell F11 (F11=C4) from the reference cell (C4) and I drag down on Cell F11 the option of "Fill Series" isn't there and the cells populated below are copied from the cells below C4.
I need for Cell F11 to allow for the "Fill Series" option as shown in Example 1.
Or is there a way to have Cell F11 populate the reference value of C4 and automatically fill the sequential series down to a certain cell (In this instance F11=C4 and automatically sequentially fill the series down to cell F35?
In either instance I would greatly appreciate any assistance.
Thank you.
Jun 23 2021 11:56 AM
SolutionNo, that doesn't work such way. You may use in F12 formula =F11+1 and drag it down. Or, if you are on 365, use SEQUENCE() function.
Jun 23 2021 12:17 PM
Jun 23 2021 11:56 AM
SolutionNo, that doesn't work such way. You may use in F12 formula =F11+1 and drag it down. Or, if you are on 365, use SEQUENCE() function.