Support Board
Date/Time: Tue, 04 Nov 2025 18:18:53 +0000
Post From: Spreadsheet Study Column H question
| [2013-04-07 17:31:27] |
| Sawtooth - Posts: 4285 |
|
For a 10 bar rolling numberline, you could reference H3 to H12 in, for example, K3 with something like this: IF(ROW()>12,0,H3) Then you would have to daily manually update H3-H12 with your ratings, shifting the ratings down to match the dates. |
