Hello:

Please refer to attached file.
I have data as shown in Sheet1.
I need a formula in Sheet2, cell G20 to give teh address of the last used cell in Column A Sheet1.
In this example it needs to be G20 will be A470

Let me know if you have any questions.
Thanks.

Riz