Hi Glenn,
I am having a major problem trying to get a couple of other formulas to work on this. If I could get you to assist me that would be great since you are familiar with the whole project so far. Sample Attached "MySample8"
I am trying to get "G7- (Max F - Min D)" From our boots on the ground day, "2" Site Work, Row 26 this sample" all the way to "Row 49, this sample" and put that result in "L4" Scheduled Lag Days. I tried this but it really doesn't work correctly and cant figure out how to subtract the G7 before it?
=MAX(INDIRECT("F"&11+MATCH("2",$A$12:$A$49,0)&":F"&11-1))-INDIRECT("D"&11+MATCH("2",$A$12:$A$49,0))
Second, I am trying to Do a "Rounddown for a total of G Column * total of L Column, from our boots on the ground day, "2" Site Work to the end, row 49, this sample" and put result in "O5"
And Finally, I am trying to "Max Days Column E - Max Days in Column L" from our boots on the ground day, "2" Site Work to the end, Row 49, this sample and the result of that would go in "O7".
Bookmarks