Leading the way in Microsoft Office Development
 Home|Excel|Word|PowerPoint|Consultancy|Feedback|Contact 
 Microsoft Excel > Array Formulas > Functions that return Arrays< Previous | Next > 
 

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.

 
 
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.
 

 Copyright © 2004-2007 Better Solutions Limited. All Rights Reserved.< Previous | Top | Next >