Version 1.44

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

PreviousROWSNextSORT