Question

Write the cell address of the following

• First row and first column ………..

• First column and second row ………...​

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