Results 1 to 8 of 8

Incorporating the results of a MAX function in to an OFFSET Function

Threaded View

  1. #1
    Registered User
    Join Date
    11-15-2013
    Location
    Dayton Ohio
    MS-Off Ver
    Excel 2010
    Posts
    4

    Incorporating the results of a MAX function in to an OFFSET Function

    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!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Incorporating a CountIF function into VBA
    By jbumps in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-14-2012, 06:21 PM
  2. Incorporating IF Function into DAYS360 Function
    By Journee22 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-26-2012, 02:25 PM
  3. Offset function with unexpected results
    By Coaster in forum Excel General
    Replies: 10
    Last Post: 07-01-2010, 04:09 AM
  4. Offset based on results of Max function
    By Paul987 in forum Excel General
    Replies: 4
    Last Post: 02-15-2008, 02:43 PM
  5. [SOLVED] Function with results in offset cell
    By Andibevan in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-12-2005, 02:05 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1