Work out highest number and display another column

[danielseward408]

Hey guys,

Can you please help, i have a list of people that are in a compertition and accumilate points. How do i get excel 2010 to figure out who has the most points and display the name of that person.

Daniel

[NBVC]

Is there going to be only one max every time?

If so...

=INDEX(A1:A10,MATCH(MAX(B2:B10),B2:B10,0))

where A1:A10 contain the names, and B2:B10 contain the points.

If not....

=IFERROR(INDEX(A$1:A$10,SMALL(IF(B$2:B$10=MAX(B$2:B$10),ROW(B$2:B$10)-ROW(B$2)+1),ROWS(B$2:B2))),"")

confirmed with CTRL+SHIFT+ENTER not just ENTER and copied down as far as needed to get all

[tlafferty]

Assuming there are no ties, sort your data in descending order. Use a vlookup:
=VLOOKUP(MAX(SELECT RANGE OF SCORES),SELECT RANGE OF SCORES AND NAMES,2,FALSE)

Note, this assumes that scores appear in the left hand column and names in the column next to it...

[danielseward408]

Cheers NBVC,

The first statement was the one i was after. I'm sure i will have loads more questions later.

Many Thanks