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!
Bookmarks