Show cell info. in another cell

[Jim W.]

My worksheet requires me to enter a value daily into a
column and, of course, is always the last entry in that
column. The value I enter is "freehand" and differs from
day to day.

I would like to show this value in another cell near the
top of the worksheet for quick reference.

Thanks, Jim

 

[Tom Ogilvy]

Assume no blank cells and the value is in column A

=INDEX(A:A,COUNTA(A:A))

or
=Offset(A1,CountA(A:A)-1,0)

 

[Tom Ogilvy]

If you do have empty cells intermingled in the column:

=INDEX(A:A,MATCH(REPT("z",255),A:A))
Assumes the cells contain text, not numbers or at least the last cell will.