COLLECT function

This article describes the formula syntax of the COLLECT function

Description

Collect cells into a range

Syntax

COLLECT(cell, cell, cell, cell, cell, cell, cell, cell, cell, cell, cell, cell, cell, cell, cell, cell, cell, cell, cell, cell, cell, cell, cell, cell, cell, cell, cell, cell, cell, cell)

cell is a cell to collect.
cell is a cell to collect.
cell is a cell to collect.
cell is a cell to collect.
cell is a cell to collect.
cell is a cell to collect.
cell is a cell to collect.
cell is a cell to collect.
cell is a cell to collect.
cell is a cell to collect.
cell is a cell to collect.
cell is a cell to collect.
cell is a cell to collect.
cell is a cell to collect.
cell is a cell to collect.
cell is a cell to collect.
cell is a cell to collect.
cell is a cell to collect.
cell is a cell to collect.
cell is a cell to collect.
cell is a cell to collect.
cell is a cell to collect.
cell is a cell to collect.
cell is a cell to collect.
cell is a cell to collect.
cell is a cell to collect.
cell is a cell to collect.
cell is a cell to collect.
cell is a cell to collect.
cell is a cell to collect.

Assemble up to 30 spreadsheet cells into a range. If all arguments to COLLECT have the same number of columns then the ranges are stacked.