I have a spreadsheet with stocks that updates to the current prices on loading.
I have a field (E8) for the total value of the portfolio.
I have another field (G8) for the maximum value of the portfolio.
On any given day, I want the value of G8 to automatically update to the value of E8 if the new Total Value (E8) is greater than the previous Maximum (G8).
It appears to be a circular argument, but there has to be a way to accomplish this (other than manually). Isn’t there?
Can anyone suggest a solution?