Other Functions

BYCOL

This function applies a LAMBDA to each column and returns an array of the results.

BYROW

This function applies a LAMBDA to each row and returns an array of the results.

CHOOSECOLS

The function returns the specified columns from an array.

CHOOSEROWS

The function returns the specified rows from an array.

DROP

The function excludes a specified number of rows or columns from the start or end of an array.

EXPAND

This function expands or pads an array to the specified row and column dimensions.

EURO

This function returns the equivalent of one Euro based on the ISO currency code.

EUROCONVERT

This function converts currency from a Euro member currency (including Euros) to another Euro member currency (including Euros).

HSTACK

The function appends arrays horizontally and in sequence to return a larger array.

ISOMITTED

This function checks whether the value in a LAMBDA is missing.

LAMBDA

This function creates custom, reusable functions and assigns them a desired name.

MAKEARRAY

This function returns a calculated array of a specified row and column size by applying a LAMBDA.

MAP

This function returns an array formed by mapping each value in the array(s) to a new value by applying a LAMBDA to create a new value.

OBJECT

This function converts the property/expression sequence to an object.

PROPERTY

This function returns the value of property path in object.

QUERY

This function returns data from data manager tables in a worksheet.

REDUCE

This function decides how to re-calculate the formula. Can use the evaluateMode argument to specific the formula re-calculate on the reference value changed, evaluate once , re-calculate or interval.

REFRESH

This function reduces an array to an accumulated value by applying a LAMBDA to each value and returning the total value in the accumulator.

SCAN

This function scans an array by applying a LAMBDA to each value and returns an array that has each intermediate value.

TAKE

This function returns a specified number of contiguous rows or columns from the start or end of an array.

TOCOL

This function returns the array in a single column.

TOROW

This function returns the array in a single row.

VSTACK

This function appends arrays vertically and in sequence to return a larger array.

WRAPCOLS

This function wraps the provided row or column of values by columns after a specified number of elements to form a new array.

WRAPSROWS

The function wraps the provided row or column of values by rows after a specified number of elements to form a new array.