Return last value in a range.

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.


wrote in message
...
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

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

wrote in message
...
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