Functions
SEQUENCE
Generate a sequence of numbers
Try it
When to use it
When should I use SEQUENCE instead of manually listing numbers?
Use SEQUENCE when you need to generate a series of numbers automatically, such as row numbers, step indices, or evenly spaced values, without typing each one.
Used in
Syntax
SEQUENCE(rows, [cols], [start], [step])Examples
=SEQUENCE(2) // => 1
=SEQUENCE(2,3) // => 1
=SEQUENCE(2,3,3,2) // => 3