2 Week Rolling Average... HELP!

I haven't tested this but it should work. Enter in WOH!L3 and fill down

Formula:

Please Login or Register  to view this content.

Here is your workbook with the formula working:

I am assuming that you want the daily average for a 2 week period on a rolling basis in the file uploaded in the previous message.

You're welcome. Thank you for the feedback.

No Problem!

It would kill the formula unless you moved the date along with the COMP as the date is directly above COMP and that relationship has to be maintained.

That's what I figured as I played with it to see what would happen.

Do you have suggestions to manipulate the formula in C3:J3 so that it is pulling the RECVD column data instead of the COMP column data? 11/8 should read 452402 not 450000. Again, I tried playing with it but I am still in the process of learning...

=IFERROR(HLOOKUP(C$2,'Completed Work'!$B$2:$DH$30,ROW()),"N/A")


***Nevermind, I figured that out too! Thanks a bunch again!

I added the dates above the RECVD on the Completed Work worksheet and hid them by formatting the font with the background colour and then used this formula in the WOH worksheet at C3 and filled across and down:

Formula:

Please Login or Register  to view this content.

...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.