Chosing the top 3 values from a list
 

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

Chosing the top 3 values from a list
 

=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).

--
Regards,
Tom Ogilvy

"st120869" wrote in
message ...

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

Chosing the top 3 values from a list
 

Thanks - this has really helped


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