Microsoft Office Tutorials and References
In Depth Information
Working with Functions That Return Arrays
Figure 3-5:
Making an
easy
calculation using
an array
formula.
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
of data.
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.
Search JabSto ::




Custom Search