ARRAY

Creates an array of all supplied values

Syntax

=ARRAY(value1, value2, ...)

=ARRAY()

Arguments

ArgumentTypeDescription
valueAnyThe value for the specified item, values can be different types

Examples

=ARRAY("A", 2, true)["A", 2, true]
Creates an array consisting of the values "A", 2, and true

=ARRAY()[]
Creates an empty array

=ARRAY(1, ARRAY(2, 3), 4)[1, [2, 3], 4]
Creates an array consisting of the value 1, an array containing 2 and 3, and the value 4