LinkBack URL
About LinkBacks
DDL, the OP wanted 8 weeks, and after your post, I noticed I thought each column was a day, not a week...thanks need to revise my formula...
=AVERAGEIF(OFFSET($A$1,6,MATCH(MAX(4:4),4:4,0)-8,,56),"RP",OFFSET($A$1,4,MATCH(MAX(4:4),4:4,0)-8,,56))
DDL, the OP wanted 8 weeks, and after your post, I noticed I thought each column was a day, not a week...thanks need to revise my formula...
=AVERAGEIF(OFFSET($A$1,6,MATCH(MAX(4:4),4:4,0)-8,,56),"RP",OFFSET($A$1,4,MATCH(MAX(4:4),4:4,0)-8,,56))
Last edited by FDibbins; 12-23-2013 at 09:08 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks