Login Page - Create Account

Support Board


Date/Time: Fri, 29 Mar 2024 00:00:15 +0000



Post From: Spread Sheet study, Find last value of previous month in AA3 column

[2013-11-07 21:23:55]
jackw - Posts: 57
In the formula, the reference to cells A1003 and AA1003 assume there are 1000 rows of data loaded. If you have more rows loaded, they should be adjusted (i.e. for 2000 rows, use A2003 and AA2003).

Also, if you need more rows of data loaded into the spreadsheet, You can increase the number of rows in the study settings.

If I'm misunderstanding you, please post again with more details.