Microsoft Office Tutorials and References
In Depth Information
Using Functions to Describe the Shape of a Contiguous Reference
Using Functions to Describe the Shape of a Contiguous Reference
Four functions can be used to identify the location and shape of a contiguous
range:
COLUMN(
reference) This returns the column number of the upper-
left corner of a reference, using numbers from 1 to 16,384. If reference
is omitted, the function returns the column number of the cell where
the formula is entered.
ROW(
COLUMN(reference
reference) This returns the row number of the upper-left
corner of the reference, using numbers from 1 to 1,048,576. If reference
is omitted, the function returns the row number of the cell where the
formula is entered.
COLUMNS(
ROW(reference
reference) This returns the number of columns in a ref-
erence. In this case, referencemust be a single contiguous range.
ROWS(
COLUMNS(reference
reference) This returns the number of rows in a reference.
Again, referencemust be a single contiguous range.
Figure 12.34 displays the ROW, COLUMN, ROWS, and COLUMNS functions of
a named range. The range occupies the black cells in B7:D11.
ROWS(reference
Search JabSto ::




Custom Search