RANGE¶

Creates a flat JSON array from specified cell range. Basically this is the same as using ARRAY with nested and flat parameter set to true.

Syntax

=RANGE(Cellrange)

Arguments

Name

Description

Cellrange

Source Range to retrieve data from.

Return Value

A comma separated list of cell values.

Example

Function

Result

Comment

=RANGE(A1:A1)

[42]

Range defines only one cell, so returned list contains only one value.

=RANGE(A1, B2)

[42, 23, 13, 17]

Range defines 4 values, so returned list contains 4 values.