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
Search JabSto ::




Custom Search