SEQUENCE function
The SEQUENCE function returns an array of sequential numbers, such as 1, 2, 3, 4.
Parts of a SEQUENCE function
SEQUENCE(rows, columns, start, step)
Part
Description
rows
Required. The number of rows to return
columns
Optional. The number of columns to return. If omitted, the returned array will have one column.
start
Optional. The number to start the sequence at. If omitted, the sequence will start at 1.
step
Optional. The amount to increase/decrease each number in the sequence. If omitted, the sequence will increase by 1.
Sample formulas
Example 1: SEQUENCE(2)
Example 2: SEQUENCE(2, 3)
Example 3: SEQUENCE(2, 3, 3, 2)
Example 4: SEQUENCE(2, 3, 10, -1)
Notes
If columns is omitted, the resulting array will be a vertical list. If a horizontal list is needed, either specify rows as 1 and specify columns or transpose the vertical result.
Result for A1=SEQUENCE(2)
A
B
1
1
2
2
Result for A1= SEQUENCE(2, 3)
A
B
C
1
1
2
3
2
4
5
6
3
Result for A1= SEQUENCE(2, 3, 3, 2)
A
B
C
1
3
5
7
2
9
11
13
3
Result for A1= SEQUENCE(2, 3, 10, -1)
A
B
C
1
10
9
8
2
7
6
5
3
4
3
2