Return last value in a range.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

My range is from A1:A20. The range could have a possible
of 20 numbers, some number may be exactly the same.
Numbers will be entered starting at A1. I am trying to
return the last number in the range at cell A21.

The problem is that a the last number entered could be in
any cell within the range. How can I return the last value
in a range?

- JTJACKPOT
 
Try this

=INDEX(A1:A20,MAX(IF(A1:A20<>"",ROW(A1:A20))))

entered with CTRL SHIFT ENTER.
 
Back
Top