Chosing the top 3 values from a list

S

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
 
T

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Weighted randbetween text list 3
Top 3 highest values 7
Top 3 numbers in a list 1
Finding/Copying Top 10 Items From A List 2
Get top 3 values from a list 4
Listing top 3 values 4
Finding the top two in a multi page workbook 5
Return top 3 occurances of word in list 6

Top