ARRAY.SEQUENCE function

This article describes the formula syntax of the ARRAY.SEQUENCE function.

Description

Return a one column array from start to stop with specified optional increment.

Syntax

ARRAY.SEQUENCE(start, stop, _incr)

start	is the first value in the sequence.
stop	is the last value in the sequence.
_incr	is an optional value to increment by. Default is 1.

Return a one columns array {start; start + incr; ...; stop}. If _incr is greater than 1 return _incr values from start to stop