Generates a list of sequential numbers in an array.
Söz dizimi
SEQUENCE(rows, [columns], [start], [step])Bağımsız değişkenler
rowszorunlu
The number of rows to return.
columnsisteğe bağlı
The number of columns to return.
startisteğe bağlı
The starting number in the sequence.
stepisteğe bağlı
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.