Explanation

TheADDRESS functioncreates a reference based on a given row and column number.

For example, =ADDRESS(1,1) returns $A$1.

ROW Function

The Excel ROW function returns the row number for a reference.

Excel formula: Address of last cell in range

For example, ROW(C5) returns 5, since C5 is the fifth row in the spreadsheet.

When no reference is provided, ROW returns the row number of the cell which contains the formula.

COLUMN Function

The Excel COLUMN function returns the column number for a reference.

Excel formula: Total rows in range

For example, COLUMN(C5) returns 3, since C is the third column in the spreadsheet.

When no reference is provided, COLUMN returns the column number of the cell which contains the formula.

CELL Function

The Excel CELL function returns information about a cell in a worksheet.

Excel formula: Total columns in range

The punch in of information to be returned is specified asinfo_type.

See below for a full list of…

Excel formula: Count cells in range

Excel formula: First row number in range

Excel formula: Get address of named range or table

Excel ADDRESS function

Excel ROW function

Excel COLUMN function

Excel CELL function