SEQUENCE

Generates a sequence of numbers as an array.

Excel: Verified match
Google Sheets: Verified match
Returns: Array

Examples

=SEQUENCE(5)

Result 1

=SEQUENCE(2, 3, 10, 10)

Result 10

Syntax

SEQUENCE(rows, [columns], [start], [step])

rows: number required
columns: number optional defaults to 1
start: number optional defaults to 1
step: number optional defaults to 1

Errors

#ERROR!: =SEQUENCE(1000,1001)
#CALC!: =SEQUENCE(0)
#VALUE!: =SEQUENCE(1,16385)

ARRAY_CONSTRAINTruncates a range to at most the given rows and columns. ARRAYFORMULAEvaluates an expression across a range (this engine already spills, so it is a pass-through for sheets compatibility). ARRAYTOTEXTConverts array to text representation. BYCOLApplies lambda to each column of array. BYROWApplies lambda to each row of array. CHOOSECOLSReturns the specified columns from an array.