Print incremental numbers in Google Sheets

Question

Cell A1 holds a numerical value (e.g. 10), and I'd like to output the list of numbers from 1 to that number in B1:

What's the formula I need for B1? It seems trivial, and I know it probably requires ARRAYFORMULA but I just don't know where to go from there.

marikamitsos · Accepted Answer · 2020-03-07 10:45:21Z

5

It is as simple as using the following sequence formula

=SEQUENCE(A1)

Or you even could have something like this:

=SEQUENCE(A2,1,A4,A6)

You could even use the SEQUENCE function for dates

=SEQUENCE(A2,1,A4,A6)

answered Mar 7, 2020 at 10:23

marikamitsos

13.1k4 gold badges34 silver badges59 bronze badges

I was hoping there was an easy way to do this :)
– FloatingRock
Commented Mar 7, 2020 at 12:49
The SEQUENCE function is relatively new but really great. Glad it helped :)
– marikamitsos
Commented Mar 8, 2020 at 6:34

Add a comment |

1 Answer 1