Microsoft Office Tutorials and References
In Depth Information
Working with Functions That Return Arrays
Working with Functions
That Return Arrays
A few functions actually return arrays of data. Instead of providing a single
result, as most functions do, these functions return several values. The
number of actual returned values is directly related to the function’s
arguments. The returned values go into a range of cells.
Excel array functions accept arrays as arguments and possibly return arrays
A good example of this is the TRANSPOSE function. This interesting function
is used to reorient data. Data situated a given way in columns and rows is
transposed (changed to be presented instead in rows and columns). Figure 3-6
shows how this works.