# array functions

work on whole ranges at once and return multiple values.

33 functions.

- [ARRAY_CONSTRAIN](https://deepcalc.com/functions/array-constrain.md) — truncates a range to at most the given rows and columns
- [ARRAYFORMULA](https://deepcalc.com/functions/arrayformula.md) — evaluates an expression across a range (this engine already spills, so it is a pass-through for sheets compatibility)
- [ARRAYTOTEXT](https://deepcalc.com/functions/arraytotext.md) — converts array to text representation
- [BYCOL](https://deepcalc.com/functions/bycol.md) — applies lambda to each column of array
- [BYROW](https://deepcalc.com/functions/byrow.md) — applies lambda to each row of array
- [CHOOSECOLS](https://deepcalc.com/functions/choosecols.md) — returns the specified columns from an array
- [CHOOSEROWS](https://deepcalc.com/functions/chooserows.md) — returns the specified rows from an array
- [DROP](https://deepcalc.com/functions/drop.md) — removes rows or columns from the start or end of an array
- [EXPAND](https://deepcalc.com/functions/expand.md) — pads an array to a given size with a fill value
- [FILTER](https://deepcalc.com/functions/filter.md) — returns the rows or columns of a range that meet a condition
- [FLATTEN](https://deepcalc.com/functions/flatten.md) — collapses one or more ranges into a single column
- [HSTACK](https://deepcalc.com/functions/hstack.md) — joins arrays side by side into one array
- [ISOMITTED](https://deepcalc.com/functions/isomitted.md) — checks if lambda argument is omitted
- [LAMBDA](https://deepcalc.com/functions/lambda.md) — creates a custom reusable function
- [LET](https://deepcalc.com/functions/let.md) — assigns names to values in a formula
- [MAKEARRAY](https://deepcalc.com/functions/makearray.md) — creates array from lambda over indices
- [MAP](https://deepcalc.com/functions/map.md) — maps lambda over array values
- [RANDARRAY](https://deepcalc.com/functions/randarray.md) — returns an array of random numbers
- [REDUCE](https://deepcalc.com/functions/reduce.md) — reduces array to value with lambda
- [SCAN](https://deepcalc.com/functions/scan.md) — scans array with lambda keeping intermediates
- [SEQUENCE](https://deepcalc.com/functions/sequence.md) — generates a sequence of numbers as an array
- [SORT](https://deepcalc.com/functions/sort.md) — sorts the contents of a range or array
- [SORTBY](https://deepcalc.com/functions/sortby.md) — sorts a range or array by values in a corresponding range
- [SORTN](https://deepcalc.com/functions/sortn.md) — the first n rows of a range after sorting
- [TAKE](https://deepcalc.com/functions/take.md) — returns rows or columns from the start or end of an array
- [TOCOL](https://deepcalc.com/functions/tocol.md) — returns an array as a single column
- [TOROW](https://deepcalc.com/functions/torow.md) — returns an array as a single row
- [TRANSPOSE](https://deepcalc.com/functions/transpose.md) — flips the orientation of a range or array
- [TRIMRANGE](https://deepcalc.com/functions/trimrange.md) — trims empty rows and columns from the edges of a range
- [UNIQUE](https://deepcalc.com/functions/unique.md) — returns the distinct values from a range or array
- [VSTACK](https://deepcalc.com/functions/vstack.md) — stacks arrays on top of each other into one array
- [WRAPCOLS](https://deepcalc.com/functions/wrapcols.md) — wraps a row or column into a 2-D array by columns
- [WRAPROWS](https://deepcalc.com/functions/wraprows.md) — wraps a row or column into a 2-D array by rows

## navigate

- [function index](https://deepcalc.com/functions.md)
- [error values](https://deepcalc.com/errors.md) · [concepts](https://deepcalc.com/concepts.md) · [limits](https://deepcalc.com/limits.md)

source: https://deepcalc.com/functions/array-functions