Generates a list of sequential numbers in an array.
This function works the same in Google Sheets as it does in Excel — same syntax and arguments.
SEQUENCE(rows, [columns], [start], [step])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)Result: 1, 2, 3
Creates a vertical list of 3 numbers starting at 1 with a step of 1.
This error occurs if there is not enough empty space in the adjacent cells to display the entire array.