Function to show highest scorer

[jbc]

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]

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)