Function to show highest scorer

jbc · Oct 11, 2003

Hi,

I have a workbook that is used to calculate user scores.
How do I get Excel to show the person's name and score.

A B
1 Roger 100
2 Steve 50
3 Paul 35
4 Mary 45

I would like the formula to show

A B
5 Roger 100

Thanks

jbc

Bob Phillips · Oct 11, 2003

In B5
=MAX(B1:B4)

In A5:
=INDEX(A1:A4,MATCH(B5,B1:B4,0))

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)