Show cell info. in another cell

  • Thread starter Thread starter Jim W.
  • Start date Start date
J

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
 
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)
 
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.
 
Back
Top