Reputation: 37
How to fill cells below each other with a number sequence, filling only the first cell with a number, how many cells to fill?
In other words - Fill the first cell with a number to return an array of counted numbers.
Example 03
If I enter number 100 to A1
Result:
A1: 100
...
A100: 1
01.
I looked at the ArrayFormula() function, but I didn't know how to use it for this purpose or I don't know if it is even possible to use it for this purpose.
This is not the required solution.
02.
Pulling the edge is not suitable.
Upvotes: 0
Views: 51