Explanation
TheADDRESS functioncreates a reference based on a given a row and column number.
Note: The CELL function is avolatile functionwhich can cause performance problems in large or complex workbooks.
For example, =ADDRESS(1,1) returns $A$1.
ROW Function
The Excel ROW function returns the row number for a reference.
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.
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.
ROWS Function
The Excel ROWS function returns the count of rows in a given reference.
COLUMNS Function
The Excel COLUMNS function returns the count of columns in a given reference.
