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