| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
1 | Requres File / Settings / Calculations / Iterative calculation: ON | |||||
2 | ||||||
3 | Value to watch | 20 | ||||
4 | ||||||
5 | Historical | |||||
6 | Min | 20 | (Clear output cells to reset) | |||
7 | Max | 20 | ||||
8 | ||||||
9 | ||||||
10 | ||||||
11 | ||||||
12 | =let(watch, C3, me, indirect("RC",false), prevMin, offset(me, 0,1), prevMax, offset(me, 1,1), vstack( hstack("Min", min(watch, prevMin)), hstack("Max", max(watch, prevMax)))) | |||||
13 | ||||||
14 | ||||||
15 | ||||||
16 | ||||||
17 | ||||||
18 | ||||||
19 | ||||||
20 |