Max Cell Value
"JE McGimpsey" wrote:
One way:
Choose Tools/Options/Calculation and check the Iteration checkbox.
to monitor cell A1 in cell B1, enter this in B1:
=IF(A1B1, A1, B1)
In article ,
Saskatoon Jerry wrote:
Looking for a function or macro that captures and retains the maximum value
of a fluctuating real number in a cell
how would you capture the MINUMUM of a fluctuating real number in another
cell using the formula you give above.
|