+ Reply to Thread
Results 1 to 4 of 4

Top 5 Golf Scores with INDEX/MATCH?

  1. #1
    Registered User
    Join Date
    05-04-2014
    Location
    Perth, Australia
    MS-Off Ver
    MS365
    Posts
    35

    Top 5 Golf Scores with INDEX/MATCH?

    Hi - I have a list of 200 names (Col A) with their golf scores (Col B)

    In Col C I have a 5 line list displaying the 5 best scores, and names, maintained as I enter the scores.

    I use this to extract the best 5 scores using
    =SMALL(B1:B200,1),
    =SMALL(B1:B200,2),
    =SMALL(B1:B200,3) etc

    In Col D I match the names to the corresponding scores returned with
    =INDEX(A1:A200,MATCH(C1,B1:B200,0),1)
    =INDEX(A1:A200,MATCH(C2,B1:B200,0),1) etc

    This falls over when I get 2 or more scores the same (draws) . The best scores are returned, say 3 players with 70 each, but only the first name encountered is returned along side those three scores of 70 using my Index/Match formula, that being the first name in the list.

    Can anyone suggest a solution - how can I have the 3 different names returned alongside the 3 best scores of 70,70 and 70?

    Tks!

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,647

    Re: Top 5 Golf Scores with INDEX/MATCH?

    Try this. It should work OK.
    Attached Files Attached Files
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU

  3. #3
    Valued Forum Contributor
    Join Date
    03-20-2011
    Location
    UK
    MS-Off Ver
    Excel 2007/10/16
    Posts
    840

    Re: Top 5 Golf Scores with INDEX/MATCH?

    Hi

    Column C:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    copy down to row 5

    Column D:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    This is a array formula!! Copy this and paste it excel wookbook!! Then press Ctrl+Shift+Enter same time!! Not just Enter ok. Then copy down to row 5

    Regard
    micope21
    Last edited by micope21; 05-04-2014 at 06:41 PM.
    To help you by my post? it would be nice to click on to say "Thank you".
    If you are happy with a solution to your problem?
    Click Thread Tools above your first post,
    select "Mark your thread as Solved".

  4. #4
    Registered User
    Join Date
    05-04-2014
    Location
    Perth, Australia
    MS-Off Ver
    MS365
    Posts
    35

    Re: Top 5 Golf Scores with INDEX/MATCH?

    Brilliant!

    Thanks Glenn and Micope21 for your quick responses. Both solutions solved my problem.

    Regards,
    ANARE

+ 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. Golf Scores
    By kathy14 in forum Excel General
    Replies: 6
    Last Post: 07-16-2012, 06:38 PM
  2. Match/index/large/small - need for top and low scores
    By Lenisghio in forum Excel General
    Replies: 1
    Last Post: 05-29-2012, 10:13 PM
  3. List all scores which meet criteria (INDEX/MATCH?)
    By Sharpshooter in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-01-2010, 08:03 AM
  4. Golf Scores
    By Dubbs in forum Excel General
    Replies: 13
    Last Post: 09-24-2010, 12:48 PM
  5. Golf Scores
    By kevhatch in forum Excel General
    Replies: 10
    Last Post: 05-07-2006, 08:50 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