Home >> Support Board

Support Board

Date/Time: Thu, 25 Apr 2024 17:17:57 +0000

How to Post a Message for Support

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

View Count: 1362

[2013-11-07 16:31:24] #1 [Go To First Post]
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] #2 [Go To First Post]
jackw - Posts: 57
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] #3 [Go To First Post]
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] #4 [Go To First Post]
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.

[2013-11-14 23:23:08] #5 [Go To First Post]
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: