Support Board

Date/Time: Mon, 06 May 2024 05:29:03 +0000

Post From: Spreasheet programming question

[2013-09-08 04:00:17] Link To Thread - Link To Post [Go To First Post]
enemyspy - Posts: 304
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