Login Page - Create Account

Support Board


Date/Time: Sun, 26 Jun 2022 23:56:08 +0000



[User Discussion] - Spread Sheet study, Find last value of previous month in AA3 column

View Count: 1055

[2013-11-07 16:31:24]
jdconner - Posts: 27
I'm trying to find the last value of previous month in column AA3 and and carry it back in history.

Thanks
JDConner
[2013-11-07 19:47:20]
jackw - Posts: 56
Enter the following formula in cell K2:
=INDEX(AA3:AA1003,MATCH(DATE(YEAR(A3),MONTH(A3),0),A3:A1003,0))
This will give you the value in cell AA3 as of the last day of the prior month.
Then you can just put =K2 in cell K3 and let it copy down.


Date Time Of Last Edit: 2013-11-07 19:47:45
[2013-11-07 21:01:57]
jdconner - Posts: 27
That works but it only shows the last 2 months, is there any way to make it show more history.

Thanks
JD
[2013-11-07 21:23:55]
jackw - Posts: 56
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.

[2013-11-14 23:23:08]
jdconner - Posts: 27
I got it working. Thanks Jack

To post a message in this thread, you need to log in with your Sierra Chart account:

Login

Login Page - Create Account