# Other Functions

## Content

Spread provides the following other functions, listed alphabetically.

| Function | Description |
| -------- | ----------- |
| [BYCOL](/spreadjs/docs/v16/formulareference/FormulaFunctions/other-functions/bycol-function) | This function applies a LAMBDA to each column and returns an array of the results. |
| [BYROW](/spreadjs/docs/v16/formulareference/FormulaFunctions/other-functions/byrow-function) | This function applies a LAMBDA to each row and returns an array of the results. |
| [CHOOSECOLS](/spreadjs/docs/v16/formulareference/FormulaFunctions/other-functions/choosecols) | <span style="color: rgb(58, 70, 82); font-family: Montserrat, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 16px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 300; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial; display: inline !important; float: none;">The function returns the specified columns from an array.</span> |
| [CHOOSEROWS](/spreadjs/docs/v16/formulareference/FormulaFunctions/other-functions/chooserows) | <span style="color: rgb(58, 70, 82); font-family: Montserrat, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 16px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 300; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial; display: inline !important; float: none;">The function returns the specified rows from an array.</span> |
| [DROP](/spreadjs/docs/v16/formulareference/FormulaFunctions/other-functions/drop) | <span style="color: rgb(58, 70, 82); font-family: Montserrat, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 16px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 300; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial; display: inline !important; float: none;">The function excludes a specified number of rows or columns from the start or end of an array.</span> |
| [EXPAND](/spreadjs/docs/v16/formulareference/FormulaFunctions/other-functions/expand) | <span style="color: rgb(58, 70, 82); font-family: Montserrat, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 16px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 300; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial; display: inline !important; float: none;">This function expands or pads an array to the specified row and column dimensions.</span> |
| [EURO](/spreadjs/docs/v16/formulareference/FormulaFunctions/other-functions/EURO) | This function returns the equivalent of one Euro based on the ISO currency code. |
| [EUROCONVERT](/spreadjs/docs/v16/formulareference/FormulaFunctions/other-functions/EUROCONVERT) | This function converts currency from a Euro member currency (including Euros) to another Euro member currency (including Euros). |
| [HSTACK](/spreadjs/docs/v16/formulareference/FormulaFunctions/other-functions/hstack) | <span style="color: rgb(58, 70, 82); font-family: Montserrat, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 16px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 300; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial; display: inline !important; float: none;">The function appends arrays horizontally and in sequence to return a larger array.</span> |
| [ISOMITTED](/spreadjs/docs/v16/formulareference/FormulaFunctions/other-functions/isomitted-function) | This function checks whether the value in a LAMBDA is missing. |
| [LAMBDA](/spreadjs/docs/v16/formulareference/FormulaFunctions/other-functions/lambda-function) | This function creates custom, reusable functions and assigns them a desired name. |
| [MAKEARRAY](/spreadjs/docs/v16/formulareference/FormulaFunctions/other-functions/makearray-function) | This function returns a calculated array of a specified row and column size by applying a LAMBDA. |
| [MAP](/spreadjs/docs/v16/formulareference/FormulaFunctions/other-functions/map-function) | 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](/spreadjs/docs/v16/formulareference/FormulaFunctions/other-functions/object-function) | This function converts the property/expression sequence to an object. |
| [PROPERTY](/spreadjs/docs/v16/formulareference/FormulaFunctions/other-functions/property-function) | This function returns the value of property path in object. |
| [QUERY](/spreadjs/docs/v16/formulareference/FormulaFunctions/other-functions/query-function) | This function returns data from data manager tables in a worksheet. |
| [REDUCE](/spreadjs/docs/v16/formulareference/FormulaFunctions/other-functions/reduce-function) | 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](/spreadjs/docs/v16/formulareference/FormulaFunctions/other-functions/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](/spreadjs/docs/v16/formulareference/FormulaFunctions/other-functions/scan-function) | This function scans an array by applying a LAMBDA to each value and returns an array that has each intermediate value. |
| TAKE | <span style="color: rgb(58, 70, 82); font-family: Montserrat, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 16px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 300; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial; display: inline !important; float: none;">This function returns a specified number of contiguous rows or columns from the start or end of an array.</span> |
| TOCOL | This <span style="color: rgb(58, 70, 82); font-family: Montserrat, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 16px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 300; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial; display: inline !important; float: none;">function returns the array in a single column.</span> |
| TOROW | This function <span style="color: rgb(58, 70, 82); font-family: Montserrat, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 16px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 300; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial; display: inline !important; float: none;">returns the array in a single row.</span> |
| 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. |