Support Board
Date/Time: Sun, 24 Nov 2024 05:58:03 +0000
[User Discussion] - Spreasheet programming question
View Count: 1414
| [2013-09-08 04:00:17] |
| enemyspy - Posts: 306 |
|
Ok here is the scenario. I have a spreadsheet that stores daily statistics on a daily (1 row/day time frame) lets call it "DPR". I have another spreadsheet that stroes intraday stats that works off of a 5 second time frame. lets call it "ZPL". I am currently using the following formula to isolate a specific instance from ZPL that happens once/day. =INDEX([zpl.scwbf]Sheet11!$A$3:A$200000,MATCH(1[zpl.scwbf]Sheet11!C3:C20000000,0)) I need to contain the above formula in each row of "DPR" and modify it to do this: =INDEX([only the part of zpl.scwbf]Sheet11!$A$3:A$200000 that contains the same date as dpr A3,MATCH(1[zpl.scwbf]Sheet11!$C3:C2000000,0)) So that it only finds the occurence that corresponds to the date of the ROW the forumula is in. I hope I explained this properly, and any help would be fantastic. Date Time Of Last Edit: 2013-09-08 04:06:36
|
| [2013-09-08 05:20:50] |
| enemyspy - Posts: 306 |
|
actually let me ask this differently. Is there a way for the A, and C of zpl arrays to autopopulate on the values that correspond to the Date in DPR a3 so that the INDEX MATCH formula searches the correct array size?
|
| [2013-09-08 08:45:10] |
| enemyspy - Posts: 306 |
|
NEVERMIND I FIGURED IT OUT, JUST HAD TO ADD A COLUMN (IFC3=1,A3) AND THEN THE FORMULA WAS CHANGED TO FIND THE ROGUE VALUES IN THAT COLUMN.
|
To post a message in this thread, you need to log in with your Sierra Chart account: