Forum Discussion
Michael1105
Jun 23, 2021Brass Contributor
Assistance with "Fill Series" when referencing a cell
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 Ser...
- Jun 23, 2021
No, 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.
SergeiBaklan
Jun 23, 2021Diamond Contributor
No, 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.
Michael1105
Jun 23, 2021Brass Contributor
Thank you very much Sergei for your prompt response.
Unfortunately I am using Excel 2016, and as you are aware the SEQUENCE() function isn't available. However, your suggestion works for what I need to have done.
I appreciate your help!
Unfortunately I am using Excel 2016, and as you are aware the SEQUENCE() function isn't available. However, your suggestion works for what I need to have done.
I appreciate your help!