Login Page - Create Account

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.