Question

Write cell address of first row last column

Answer 1

Answer:

To get the address of the first cell in a named range, you can use the ADDRESS function together with ROW and COLUMN functions. In the example shown, the formula in G6 is: = ADDRESS ( ROW ( data ) + ROWS ( data ) - 1 , COLUMN ( data ) + COLUMNS

Explanation:

MARK AS BRAINLIEST

IF IT IS HELPFUL

Answer 2

Answer:

ADDRESS(1,1) - returns the address of the first cell (i.e. the cell at the intersection of the first row and first column) as an absolute cell reference $A$1.