|
Arrays are a list of values separated by commas. The most common arrays are found in fuctions such as Average and Maximum, where you're finding one value stemming from a group of values.
Function | Description | Arguments |
---|---|---|
Array (x,...) | Creates an array, initializes it with the given array elements, and returns it. | The given arguments are array elements with which to initialize the array. The number of array elements can be any number from 1 to 1000. All the arguments must be of the same type. Unlike Visual Basic, you may not have zero elements. |
MakeArray (x, ...) | Creates an array, initializes it with the given array elements, and returns it. | The given arguments are array elements with which to initialize the array. The number of array elements can be any number from 1 to 1000. All the arguments must be of the same type. |
UBound (array) | Returns a Number containing the largest available subscript for the given array. | array is an array value, expression, or variable. |
SummaryFunction (x) | Summarizes the values in an array of constants, data field values, or formulas (a*b, c/d, and so on) separated by commas. | x is an array of values that can be evaluated by the function being used. |
|