Array

Functions and macros of the Array add-in.

Array functions.

Array functions

\ARRAY Return a handle to the in-memory array.
ARRAY.ACF Return auto covariance of the array.
ARRAY.COLUMNS Return the number of columns of an array.
ARRAY.DIFF Return adjacent differences of array.
ARRAY.DROP Drop items from front (n > 0) or back (n < 0) of array.
ARRAY.GRADE Grade _count elements of array in increasing (_count >= 0) or decreasing (n < 0) order.
ARRAY.INDEX Return rows and columns of array.
ARRAY.JOIN Return the concatenation of two arrays.
ARRAY.MASK Return array values where corresponding mask is non-zero.
ARRAY.RESIZE Resize an array.
ARRAY.ROWS Return the number of rows of an array.
ARRAY.SEQUENCE Return a one column array from start to stop with specified optional increment.
ARRAY.SHIFT Return shifted array.
ARRAY.SIZE Return the size of an array.
ARRAY.SORT Sort _count elements of array in increasing (_count >= 0) or decreasing (n < 0) order.
ARRAY.TAKE Take items from front (n > 0) or back (n < 0) of array.
ARRAY.UNIQUE Remove consecutive duplicates from array.