bowling scores

C

Cricket

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

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
 
B

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
 
Top