I have a column of numbers and daily add a new number to the bottom of the list.

In a separate reference cell (B1002) I have

=(1001-COUNTBLANK(B2:B1001))

This gives me the number of cells in the range that have numbers in them.

Then in cell B1003 I have

=ADDRESS(B1002,2)

This gives me the absolute reference of the bottom cell in the list that has a number in it.

I am simply trying to convert that absolute reference into a formula in another cell so that I have a cell containing the same number as is in the last cell used in the column.

The answer to this simple little challenge continues to elude me.