Large worksheet function

Posted by Paul on August 31, 2001 12:38 PM

I know how to use the Large worksheet function to get the highest to lowest score, what I would like to do is to have a persons name in A1:A25 and their score in B1:B25 and have the Large function look at B1:B25 but return the name that is in A1:A25. Thanks

Posted by IML on August 31, 2001 12:46 PM

Try

=INDEX(A1:B25,MATCH(LARGE(B1:B25,1),B1:B25,0),1)

If two people have the same high score, it will return the first name listed.

good luck