I'm pulling my hair out on what I thought would be simple. I have a spreadsheeet with 31 tabs for each day of the month starting with tab ONE and ending with THIRTYONE then the last tab is a "ROLLUP" TAB. In that Tab I want to find the MAX number in all of the Cells D20 across all 31 tabs (no problem using the formula =MAX(ONE:THIRTYONE!D20) ) but want to be able to have another formula to take that result and return the value in P20 of the SAME Sheet that had the Max Value. I thought I could use the offset command and use the MAX function as the reference then just offset the result by 12 columns. I thought this formula would work but doesn't: =OFFSET(MAX(ONE:THIRTYONE!D20)0,12). I've attched a file same. On the rollup tab in Cell D13 is where I'm trying to use the results on the max function from C13. Any suggestions on this? Thanks so much for your help!
Bookmarks