bowling scores

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

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" <[email protected]> wrote in message
news:[email protected]...
> if i use max to find the bowlers high score, how can i find the bowlers
> name
> who bowled the high score??
>
>

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

"Cricket" <[email protected]> wrote in message
news:[email protected]...
> if i use max to find the bowlers high score, how can i find the bowlers
> name
> who bowled the high score??
>
>