cell formula for using progressive information in other cells

[EG]

I would like to write a formula for cell P8 which equals the value of the
last cell in which a value was entered in column M. Thus, if cell M1 is the
only cell in column M that has data in it, then P8=M1. when the next set of
data is added to column M, now M2=10.38. Thus, P8 would now = M2, or 10.38.
In other words, what ever the last data value is of the last cell filled in
column M, that is what cell P8 equals. is there a way to do this??

Thx.

EG

 

[Duke Carey]

This will get the last NUMERIC value in the column

=INDEX(M:M,MATCH(9.99999999999999E+307,M:M))

 

[Teethless mama]

=LOOKUP(10^10,M:M)

 

[EG]

What is the 9.9999999999999E+307 about? why did you choose those numbers?

 

[Bob Phillips]

It is just a very big number that is very unlikely to be used within the
spreadsheet, so it will match the last number in the column

 

[EG]

great - thanks! EG

It is just a very big number that is very unlikely to be used within the
spreadsheet, so it will match the last number in the column


--
__________________________________
HTH

Bob