+ Reply to Thread
Results 1 to 6 of 6

Formula for Highest Score from number but display Name

  1. #1
    Registered User
    Join Date
    12-12-2013
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    2

    Formula for Highest Score from number but display Name

    Hello,
    I'm trying to create a formula that allows me to compare scores to see who has either
    a) The highest Score
    or
    b) The Highest 10 scores
    and then get the name and display it in a cell (a) or in a column of 10 (b). I've been trying to make this but I just can't seem to figure it out.

    Thank you if you can help me
    Last edited by wariodemon; 12-12-2013 at 02:34 AM.

  2. #2
    Forum Contributor geliedee's Avatar
    Join Date
    10-14-2013
    Location
    Manila, philippines
    MS-Off Ver
    Excel 2007
    Posts
    399

    Arrow Re: Formula for Highest Score from number but display Name

    HI wariodemon ,

    Try this one. Not quite sure what you want.TOP 10.xlsx

  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
    51,384

    Re: Formula for Highest Score from number but display Name

    geliedee, you have a good answer there You may want to add something to cater for duplicate scores though? (assuming duplicates are possible?)
    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
    Forum Contributor geliedee's Avatar
    Join Date
    10-14-2013
    Location
    Manila, philippines
    MS-Off Ver
    Excel 2007
    Posts
    399

    Smile Re: Formula for Highest Score from number but display Name

    Hi ford,

    Duplicates are the hardest. Haha. Been there.
    I created another column that will add .0001 to the actual scores. So if you have 2 people that has the score of 100,
    it will automatically add .0001 on the second 100 score and the score would be 100.00010.

    Please see the attached file
    Attached Files Attached Files
    Last edited by geliedee; 12-12-2013 at 05:53 AM.

  5. #5
    Registered User
    Join Date
    12-12-2013
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Formula for Highest Score from number but display Name

    Thank you so much this is exactly what i needed. I'll try this out on my thing.
    THANK YOU

  6. #6
    Forum Guru Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Formula for Highest Score from number but display Name

    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. how to hide formula in formula box, view lookup result in formula box?
    By vengatvj in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-14-2013, 04:06 PM

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