bowling scores

[Cricket]

if i use max to find the bowlers high score, how can i find the bowlers name
who bowled the high score??

 

[Peo Sjoblom]

What do you want to do with ties?

=INDEX(A2:A50,MATCH(MAX(B2:B50),B2:B50,0))

will match the first occurrence of a max value on B and return name from A

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

Portland, Oregon

 

[Biff]

Hi!

Try this:

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

What happens if more than 1 person rolls the high score?

Biff