SEQUENCE

Returns a range of sequential numbers.

Syntax 1

SEQUENCE(range)

• range - a range that is to be filled with sequential numbers - Value type: widget

Returns a range with the same number of rows and columns as range, filled with a sequence of integers, starting from 1. The integers are incremented row-by-row.

Syntax 2

SEQUENCE(numRows; numColumns)

• numRows - the number of rows of the result range - Value type: number

• numColumns - the number of columns of the result range - Value type: number

Returns a range with numRows and numColumns, with a sequence of integer values, starting from 1, up to numRows x numColumns.

Remarks

• The maximum amount of cells which can be created by the SEQUENCE function is 100,000

• Each parameter allows a maximum value of 9,999.

Examples