ARRAY
Creates an array of all supplied values
Syntax
=ARRAY(value1, value2, ...)
=ARRAY()
Arguments
| Argument | Type | Description |
|---|---|---|
| value | Any | The 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
Updated 9 months ago