Last Number in Column
 

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

Last Number in Column
 

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

Last Number in Column
 

Try:

=Lookup(9.9999999e+307,A1:A5)


--
NBVC

Where there is a will there are many ways.
'The Code Cage' (http;//www.thecodecage.com)
------------------------------------------------------------------------
NBVC's Profile: http://www.thecodecage.com/forumz/member.php?userid=74
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=111135

Last Number in Column
 

=A5
if you know that A1:A5 will have numbers in it.

=lookup(1E+100,A1:A5)
will return the last number in A1:A5.

=if(count(a1:a5)=0,"no numbers",lookup(1E+100,A1:A5))
will check to see if there's at least one number in the range.

1E+100
is scientific notation for a big number: 1 followed by 100 0's.



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

--

Dave Peterson