+ Reply to Thread
Results 1 to 3 of 3

Index, Match, and Large

  1. #1
    Forum Contributor
    Join Date
    04-25-2006
    Posts
    215

    Index, Match, and Large

    I have a column range, X9:X32 containin percentages. I have another column range to the left, D9:D32 containing the hours of the day. I need to look at the range, X9:X32 and find the highest percentage, and then return the time from the range, D9:D32.

    Thanks for any help..

    -ep

  2. #2
    Forum Contributor
    Join Date
    04-25-2006
    Posts
    215
    Got it!

    =INDEX(D9:X32,MATCH(LARGE(X9:X32,1),X9:X32,FALSE),D9:D32,1)

  3. #3
    Forum Contributor
    Join Date
    03-13-2005
    Posts
    6,196
    Quote Originally Posted by edwardpestian
    Got it!

    =INDEX(D9:X32,MATCH(LARGE(X9:X32,1),X9:X32,FALSE),D9:D32,1)
    or

    =OFFSET(D9,MATCH(LARGE(X9:X18,1),X9:X18,0)-1,0)

    ( a variation on yours)

    ---

+ Reply to Thread

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