FRAME

Creates a data frame ("nested spreadsheet") from a range.

Syntax

FRAME( range, namesOnFirstRow, [auto])

• range - Range to build a frame from.

• namesOnFirstRow - Column names on first row. Default is TRUE.

• [auto] - The bottom boundary of the range is determined by an empty value in a first column. Default is FALSE.

Sample Usage

FRAME(A1:A2)
FRAME(A1:A2, TRUE, TRUE)
FRAME(A1:A2, FALSE, TRUE)
FRAME(A1:A2, FALSE)

Notes

Note: this function is necessary while using lots of other functions, like for example FILTER, ADD_ROW, etc.

See Also

FLIP_FRAME