Generates a list of sequential numbers in an array.
ไวยากรณ์
SEQUENCE(rows, [columns], [start], [step])อาร์กิวเมนต์
rowsจำเป็น
The number of rows to return.
columnsไม่บังคับ
The number of columns to return.
startไม่บังคับ
The starting number in the sequence.
stepไม่บังคับ
The amount to increment each subsequent value.
The SEQUENCE function creates a dynamic array of sequential numbers based on specified dimensions and increments. It is particularly useful for generating lists of dates, times, or index numbers that automatically spill into adjacent cells.
=SEQUENCE(3, 1, 1, 1)→1, 2, 3Creates a vertical list of 3 numbers starting at 1 with a step of 1.
Select the target cell
Click on the cell where you want the sequence to begin.
Enter the formula
Type =SEQUENCE followed by the desired rows, columns, start, and step values.
This error occurs if there is not enough empty space in the adjacent cells to display the entire array.