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 |