+ Reply to Thread
Results 1 to 6 of 6

Need to do ranking top 5 scorer

  1. #1
    Registered User
    Join Date
    03-19-2013
    Location
    bsas
    MS-Off Ver
    Excel 2010
    Posts
    7

    Need to do ranking top 5 scorer

    I get a table with players names and amount of goals, need to rank players top scorer and extract their names,rank and goals in other cells.

    Attach the example file.

    Thanks!
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    04-03-2012
    Location
    East Sussex, UK
    MS-Off Ver
    Excel 2003:2010
    Posts
    893

    Re: Need to do ranking top 5 scorer

    Hi,

    Here's one way of doing it.
    I've added a "unique rank" in column E and used that with INDEX/MATCH to look up the names and goals scored data.

    Hope that helps.

    S.
    Attached Files Attached Files
    If I've been of help, please hit the star

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    50,749

    Re: Need to do ranking top 5 scorer

    Hi and welcome to the forum

    You have a few duplicate goal values in D (as would be expected), so i added a helper column in E and used this, copied down, to deal with the duplicates - you can hide this if you want...
    =COUNTIF($D$2:D2,D2)/100+D2

    Then in D44, copied down, use this...
    =INDEX($D$2:$D$41,MATCH(LARGE($E$2:$E$41,ROW(A1)),$E$2:$E$41,0),1)

    and in B44, copied down, use this...
    =INDEX($B$2:$B$41,MATCH(LARGE($E$2:$E$41,ROW(A1)),$E$2:$E$41,0),1)

    let me know if this is what you wanted?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  4. #4
    Registered User
    Join Date
    03-19-2013
    Location
    bsas
    MS-Off Ver
    Excel 2010
    Posts
    7

    Re: Need to do ranking top 5 scorer

    Excelent!! you're a genius solve my issue

    Thank you very much!!

    This forum rocks!

  5. #5
    Registered User
    Join Date
    03-19-2013
    Location
    bsas
    MS-Off Ver
    Excel 2010
    Posts
    7

    Re: Need to do ranking top 5 scorer

    Quote Originally Posted by Spencer101 View Post
    Hi,

    Here's one way of doing it.
    I've added a "unique rank" in column E and used that with INDEX/MATCH to look up the names and goals scored data.

    Hope that helps.

    S.
    Spencer101

    Thank you very much, I use your suggested to me and solved my problem!

  6. #6
    Valued Forum Contributor
    Join Date
    04-03-2012
    Location
    East Sussex, UK
    MS-Off Ver
    Excel 2003:2010
    Posts
    893

    Re: Need to do ranking top 5 scorer

    Glad to help.

    Don't forget to mark your threat as "SOLVED".

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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