array function

An array function returns an array of values rather than a single value. Array functions are commonly used to provide values to another function. Functions that return arrays are FREQUENCY, LINEST, INDIRECT, INTERSECT.RANGES, OFFSET, TRANSPOSE and UNION.RANGES. The INDEX function can be used to read the arrays returned by these functions.

Here are some examples of array functions:

=FREQUENCY($A$1:$F$5,$B$8:$E$8) returns an array of values, based on specified intervals.

=INDEX(FREQUENCY($A$1:$F$5,$B$8:$E$8),5) would return the fifth value in the array returned by the FREQUENCY function.

=TRANSPOSE($A$1:$E$3) returns an array containing the transposed values in the array $A$1:$E$3.