+ Reply to Thread
Results 1 to 2 of 2

Find Lowest Time, Match with Column Heading

  1. #1
    Registered User
    Join Date
    07-08-2009
    Location
    San Francisco, CA
    MS-Off Ver
    Excel XP
    Posts
    1

    Find Lowest Time, Match with Column Heading

    I want to set up an excel spreadsheet that does the following:

    Tracks the best marks of an athlete and puts in their corresponding meet...

    B2: Finds the lowest (or highest) number in the row (I figured that out using MIN and MAX formulas),

    B3: In the next column have the corresponding header go with the min or max that it just formulated...

    ie if you have data B4:H4,
    A4=Meet 1, A5=Meet 2, A6= Meet 3, etc
    and B4=3, B5=2, B6=1
    then B2 would be the lowest score (B6)
    and B3 would be Meet 3

    Any help is appreciated!
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    04-14-2009
    Location
    Taiwan
    MS-Off Ver
    Excel 2016,2019,O365
    Posts
    1,981

    Re: Find Lowest Time, Match with Column Heading

    Try this,
    C2
    =INDEX($D$1:$H$1,1,MATCH(B2,D2:H2,0))

    Copied down

    Hope this helps,
    windknife

+ 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