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