Login Page - Create Account

Support Board


Date/Time: Fri, 19 Apr 2024 09:20:09 +0000



Post From: Spreadsheet Study Column H question

[2013-04-07 17:31:27]
Sawtooth - Posts: 3973
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.