3305 Main Street Ste 019 Vancouver, WA 98663



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.


= OCList ( Range )


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


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.