Chosing the top 3 values from a list

[st120869]

an earlier Excel tip from this forum for picking the top person from a
list

INDEX, MATCH, and MAX functions in the following formula:
=INDEX(A2:A9,MATCH(MAX(B2:B9),B2:B9,0))


How can the formula be amended to pick the 2nd and 3rd highest person.
I have a list with names, would like to be able to chose and show the
score and name of the top 3 people
Thanks
Stephen

 

[Tom Ogilvy]

=INDEX(A2:A9,MATCH(Large(B2:B9,1),B2:B9,0))
=INDEX(A2:A9,MATCH(Large(B2:B9,2),B2:B9,0))
=INDEX(A2:A9,MATCH(Large(B2:B9,3),B2:B9,0))

It gets more complicated if there could be ties (ex, the top 3 each have the
value 10).

 

[st120869]

Thanks - this has really helped