Microsoft Office Tutorials and References

In Depth Information

**ROW**

ROW
Based on a reference,
ROW
returns the row number.

=ROW(reference)

The
ROW
function returns the row of the cell of the reference. If the reference is ommitted, the

ROW
function assumes the row in which the function is entered. For example,
=Row(C4)
would

result in 4. If the refernce is omitted, such as
=Row()
, then the result is the row of the cell the

formula is entered into.

This is the range or cell you want the row number to refer to.

REFERENCE

ROW
Based on a reference or array,
ROWS
returns the number of rows.

=ROWS(array)

The
ROWS
function returns the number of rows in the form of an array. For example, the

formula
{=ROWS(C20:C25)}
generates the number of rows in the array reference, which is 6.

The same formula not entered as an array produces the same result of 6.

TRANSPOSE

TRANSPOSE
returns a horizontal range of cells as vertical or vice versa.

=TRANSPOSE(array)

The
TRANSPOSE
function operates similar to the
TRANSPOSE
in the Paste Special command. The

trick to making this function work better is by selecting your destination range first before

typing the
TRANSPOSE
function. Use Ctrl+Shft+Enter instead of Enter to fill the entire

highlighted range with the new transposed data. Notice how Figure 9.15 shows building the

TRANSPOSE
function in progress and Figure 9.16 shows the final result. This function must be

entered in the form of an array for the function to work. Select Ctrl+Shft+Enter to activate the

array. Should your initial range not contain the same number of columns and rows, you will

need to select the destination range in the opposite configuration. For example, if the initial

range is B5:E7 (3 rows by 4 columns), you will need to select B9:D12 (4 rows by 3 columns)

as a destination range.

This is the range of cells you want to transpose on the worksheet. This

starts with the first row of the range and then transposes starting with the

first column of the new array.

ARRAY