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