Question

what is the address of the last cell represented by range 1​

Answer 1

Answer:

Thanks for free points

Answer 2

Answer:

The ADDRESS function creates a reference based on a given a row and column number. In this case, we want to get the last row and the last column used by the named range data (B5:D14).

To get the last row used, we use the ROW function together with the MAX function like this: