Results 1 to 10 of 10

formula to get the name of the next player with the same score

Threaded View

  1. #1
    Registered User
    Join Date
    08-12-2012
    Location
    Makati City, Philippines
    MS-Off Ver
    Excel 2003
    Posts
    5

    Question formula to get the name of the next player with the same score

    Good day,

    In the attached file on the 'Game Record' scoresheet, I have to list the top 3 players individual high score for the game.
    Notice that in cell L27-L29, three players got the same score of 141. To get the players name, I used the formula:

    =INDEX('Player Score'!C6:C113,MATCH(L27,('Player Score'!B6:B113='Player Score'!D119)*'Player Score'!DY6:DY113,0))

    This formula is fine if there were no players having the same score, now as in the example attached, this formula will get the
    value 'Tess' for K27, K28 and K29.

    How do I get the name of the next player with the same score?

    Thanks.
    Attached Files Attached Files

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