Generating Numbers With SEQUENCE
Build a list of consecutive numbers or a grid in one formula.
What SEQUENCE Does
Sometimes you need a list of consecutive numbers, 1 through 10, or a row of dates, or a numbered grid. Typing them by hand is slow and breaks when the count changes.
The SEQUENCE function generates a list of numbers in one formula and spills them into the cells around it. Change the count and the list resizes instantly.
=SEQUENCE(10)The SEQUENCE Syntax
SEQUENCE takes up to four arguments:
- rows how many rows of numbers to generate
- columns how many columns (default 1)
- start the first number (default 1)
- step how much to increase each time (default 1)
Only rows is required. Everything else has a sensible default.
=SEQUENCE(rows, [columns], [start], [step])All lessons in this course
- Ordering Results With SORT
- Sorting by Another Column With SORTBY
- Generating Numbers With SEQUENCE
- Creating Random Data With RANDARRAY