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




"Cricket" wrote in message
...
if i use max to find the bowlers high score, how can i find the bowlers
name
who bowled the high score??