cell formula for using progressive information in other cells
 

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

cell formula for using progressive information in other cells
 

This will get the last NUMERIC value in the column

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

"EG" wrote:

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

cell formula for using progressive information in other cells
 

=LOOKUP(10^10,M:M)


"EG" wrote:

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

cell formula for using progressive information in other cells
 

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

"Duke Carey" wrote:

This will get the last NUMERIC value in the column

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

"EG" wrote:

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

cell formula for using progressive information in other cells
 

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

"EG" wrote in message
...
What is the 9.9999999999999E+307 about? why did you choose those numbers?

"Duke Carey" wrote:

This will get the last NUMERIC value in the column

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

"EG" wrote:

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

cell formula for using progressive information in other cells
 

great - thanks! EG

"Bob Phillips" wrote:

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

"EG" wrote in message
...
What is the 9.9999999999999E+307 about? why did you choose those numbers?

"Duke Carey" wrote:

This will get the last NUMERIC value in the column

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

"EG" wrote:

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