Microsoft Office Tutorials and References

In Depth Information

**Understanding lookup and reference functions**

contains ten rows. And the formula =COLUMNS(A1:C10) returns
3
because the range

A1:C10 contains three columns.

The AREAS function

You can use the AREAS function to determine the number of areas in a reference.
Areas

refer to individual cell or range references, not regions. The single argument to this

function can be a cell reference, a range reference, or several range references. If you use

several range references, you must enclose them in a set of parentheses so that Excel doesnâ€™t

misinterpret the commas that separate the ranges. (Although this function takes only one

argument, Excel still interprets unenclosed commas as argument separators.) For example,

suppose you assign the name
Test
to the group of ranges A1:C5,D6,E7:G10. The function

=AREAS(Test) returns
3
, the number of areas in the group.

The TRANSPOSE function

The TRANSPOSE function changes the horizontal or vertical orientation of an array. It takes

a single argument,
array
. If the argument refers to a vertically oriented range, the resulting

array is horizontal. If the range is horizontal, the resulting array is vertical. The first row of

a horizontal array becomes the first column of the vertical array result, and vice versa. You

must type the TRANSPOSE function as an array formula in a range that has the same

number of rows and columns as the
array
argument has columns and rows, respectively.

Note

For quick and easy transposition, select the range you want to transpose, press Ctrl+C

to copy the range, click the cell where you want the upper-left corner of the transposed

range to begin, click the Paste button on the Home tab, and then click the Transpose

button.