Return last value in a range.

[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

 

[Dave R.]

Try this

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

entered with CTRL SHIFT ENTER.

 

[Aladin Akyurek]

=LOOKUP(9.99999999999999E+307,A1:A20)