RANGE¶

Creates a nested 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 nested list of cell values.

Example

Function

Result

Comment

=RANGE(A1:A1)

[[42]]

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

=RANGE(A1:C1)

[[42, 23, 13]]

Range defines 3 values over 1 row, so returned list contains a list with 3 values.

=RANGE(A1:B2)

[[42, 23], [13, 17]]

Range defines 4 values over 2 rows, so returned list contains 2 lists with 2 values each.