ARRAY
Creates an array in a cell. The items in the array can be numbers, cell references, boolean values, strings, and other arrays. #ARRAY is displayed in cells that contain arrays. Use these functions to work with arrays:
- ArrayLength: Returns the number of items in an array.
- ArrayToString: Returns all the items in an array as a string.
- GetArrayItem: Returns a single item from an array.
Functions such as GETKEY return properties of XML variables as strings. Similarly, these functions with the 'A' suffix, return properties of XML variables as arrays:
- GetKeysA
- GetKeyValuesA
- GetPropertiesA
- GetPropertyValuesA
- FindKeysA
Syntax
You can create an array of different types of item, such as numbers, boolean values, and strings.
=ARRAY(item, item, "string", "string separated by a separator", item..."separator")
Example
=ARRAY(123,789,TRUE,FALSE,"Test","a","b","c",",")
Example
This example references cells that contain arrays:
=ARRAY(C23,C25,C27,C29)
Use, for example, ARRAYTOSTRING to return the values of the referenced arrays as a string.