Support Board
Date/Time: Sun, 24 Nov 2024 05:26:19 +0000
Post From: Spreadsheet Study Column H question
| [2013-04-07 17:31:27] |
| Sawtooth - Posts: 4118 |
|
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. |