Results 1 to 7 of 7

Find the Max and Time then drag formula

Threaded View

  1. #1
    Registered User
    Join Date
    09-25-2011
    Location
    Wichita Falls,Texas
    MS-Off Ver
    Excel 2010
    Posts
    6

    Find the Max and Time then drag formula

    BONDS TEST.xlsx

    I'm trying to find the max in column c3:c11 and then give the time in column A that will allow me to drag that formula to find the max and time of c12:c20 etc. The formula I have in column I is =(INDEX(A:A,(ROW(A1)*9)+2)) and in column J is =INDEX(A3:A11,MATCH(MAX(C3:C11),C3:C11,0)). This formula I tried using but it's not right =INDEX(INDEX(A:A,(ROW(A1)*9)-6):INDEX(A:A,(ROW(A1)*9)+2)),MATCH(MAX(INDEX(C:C,(ROW(A1)*9)-6):INDEX(C:C,(ROW(A1)*9)+2)),INDEX(C:C,(ROW(A1)*9)-6):INDEX(C:C,(ROW(A1)*9)+2),0). I attached a picture.

    Thanks
    JdConner
    Attached Images Attached Images
    Last edited by JDCONNER; 02-04-2013 at 10:55 PM.

Thread Information

Users Browsing this Thread

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

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