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
| Argument | Description |
|---|---|
| Range | This 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. |