Support Board
Date/Time: Sun, 24 Nov 2024 05:28:50 +0000
Post From: Spreasheet programming question
| [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
|