+ Reply to Thread
Results 1 to 3 of 3

Finding the highest hit and display the proper related number

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    11-13-2010
    Location
    Warren, Michigan
    MS-Off Ver
    Excel 2008 for Mac
    Posts
    307

    Finding the highest hit and display the proper related number

    EXAMPLE:

    Row2 A2:12 B2:25 C2:36 D2:48 E2:56 G2:56
    Row3 A3:1 B3:0 C3:1 D3:2 E3:4

    Row2 shows 5 different numbers

    Row3 relates to the Row2 number, Row 3 is the number of times Row2 number has hit.

    I'm looking for a formula which picks the "highest" hit number (Row3) and places the appropriate Row2 number in the G2 cell.

    This would be an automatic update since hits per number increase over time.

    Thanks for the help...
    Last edited by khank; 12-21-2010 at 09:24 AM.

  2. #2
    Forum Expert daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    Microsoft 365
    Posts
    14,730

    Re: Finding the highest hit and display the proper related number

    Try

    =INDEX(A$2:E$2,MATCH(MAX(A3:E3),A3:E3,0))
    Audere est facere

  3. #3
    Forum Expert ConneXionLost's Avatar
    Join Date
    03-11-2009
    Location
    Victoria, Canada
    MS-Off Ver
    2010
    Posts
    2,952

    Re: Finding the highest hit and display the proper related number

    Try:

    =INDEX(A2:E3,1,MATCH(MAX(A3:E3),A3:E3,0))
    This assumes there will always be a "single" highest hit number. i.e., If there's a tie, you won't get both.
    Would you like to say thanks? Please click the: " Add Reputation" button, on the grey bar below the post.

+ 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