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


--
st120869
------------------------------------------------------------------------
st120869's Profile: http://www.excelforum.com/member.php...o&userid=18330
View this thread: http://www.excelforum.com/showthread...hreadid=496633