OCList

Description

This function provides a quick way to use a range of cells to create a list that can be used with the Prefix argument of the GLAmount function, or the Prefixes argument of other GL functions. The list is built from distinct non-blank values contained in the range of cells identified.

Syntax

= OCList ( Range )

Example

=OCList(A10:A14)
Returns a comma-separated list of the values in the referenced cells.
Example: "('10','20','21','22','50')"

Arguments

ArgumentDescription
RangeThis argument specifies the cells that hold a list of values. When assembling the list from this range of cells, any blank cells are automatically skipped. If no cells contain values, this function returns nothing.