Please note that this is an array formula. Within the cell in edit mode (F2)
paste this formula and press Ctrl+Shift+Enter to apply this formula. If
successful in 'Formula Bar' you can notice the curly braces at both ends like
"{=<formula}"

=INDEX(A1:A5,MAX(ROW(A1:A5)))


If this post helps click Yes
---------------
Jacob Skaria


"Chey" wrote:

Does anyone know the formula to retrive the last number in the slected area?
So Like A1:A5
It will have the number in A5.

THanks
Cheyenne