Functions that always return an Array

The following is a list of functions that always return an array.

FREQUENCYThe number of times a value occurs in a given array or cell range.
LINESTThe array of values for a straight line that best fits your data.


Functions that can return an Array

The following is a list of functions that can return an array, depending on the arguments.

COLUMNThe column number of the cell reference.
FORECASTThe future value along a linear trend by using existing values.
GROWTHThe predicted exponential growth using existing data.
LOGESTThe array of values for an exponential curve that best fits your data.
MINVERSEThe inverse matrix of an array.
MMULTThe matrix product of two arrays.
ROWThe row number of the cell reference.
TRANSPOSEThe array with its orientation changed.
TRENDThe y-values along a linear trend given a set of x-values.


Functions that cannot return an Array

The following is a list of functions that cannot return an array.

ABSThe absolute value, i.e. a number without its sign.


Using Database Functions

If you are using array formulas to help filter out data by using conditions, then it is far more efficient to use the database functions instead.



Copyright © 2001 - 2016 Better Solutions Limited | All Rights Reserved.    Previous

    Next