SEQUENCE
The SEQUENCE function returns an array of sequential, numeric values based on your specifications. You specify the number of rows, the number of columns, the first number to return, and the increment to increase between each value.
SEQUENCE(number-of-rows, number-of-columns, start, step)
number-of-rows: The number of rows to return.
number-of-columns: The number of columns to return.
start: The first number to return.
step: The increment to increase between each value.
Notes
Omit start and step to generate an array starting with 1 and increasing by 1.
Examples |
|---|
=SEQUENCE(2,3,5,5) returns the array below: |
A | B | C | |
|---|---|---|---|
1 | 5 | 10 | 15 |
2 | 20 | 25 | 30 |
=SEQUENCE(3,4) returns the array below: |
A | B | C | D | |
|---|---|---|---|---|
1 | 1 | 2 | 3 | 4 |
2 | 5 | 6 | 7 | 8 |
3 | 9 | 10 | 11 | 12 |
=SEQUENCE(4,7,DATE(2025,4,1),1) returns the array below: |
A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
1 | 4/1/25 | 4/2/25 | 4/3/25 | 4/4/25 | 4/5/25 | 4/6/25 | 4/7/25 |
2 | 4/8/25 | 4/9/25 | 4/10/25 | 4/11/25 | 4/12/25 | 4/13/25 | 4/14/25 |
3 | 4/15/25 | 4/16/25 | 4/17/25 | 4/18/25 | 4/19/25 | 4/20/25 | 4/21/25 |
4 | 4/22/25 | 4/23/25 | 4/24/25 | 4/25/25 | 4/26/25 | 4/27/25 | 4/28/25 |