MAX #, display name

[fastballfreddy]

I have 10 cells w/ various amounts of numbers. I want a formula to find the max number and instead of showing that amount, have it show the name that goes w/ that amount. Do I use the IF and MAX function?

names in A1, A2, A3 and so on
numbers in B1,B2,B3 and so on

thanks,

[Niek Otten]

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

--
Kind regards,

Niek Otten

"fastballfreddy" <[email protected]> wrote in message
news:[email protected]...
|
| I have 10 cells w/ various amounts of numbers. I want a formula to find
| the max number and instead of showing that amount, have it show the name
| that goes w/ that amount. Do I use the IF and MAX function?
|
| names in A1, A2, A3 and so on
| numbers in B1,B2,B3 and so on
|
| thanks,
|
|
| --
| fastballfreddy
| ------------------------------------------------------------------------
| fastballfreddy's Profile: http://www.excelforum.com/member.php...o&userid=33986
| View this thread: http://www.excelforum.com/showthread...hreadid=539672
|

[Ragdyer]

Try this:

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

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"fastballfreddy"
<[email protected]> wrote in
message news:[email protected]...
>
> I have 10 cells w/ various amounts of numbers. I want a formula to find
> the max number and instead of showing that amount, have it show the name
> that goes w/ that amount. Do I use the IF and MAX function?
>
> names in A1, A2, A3 and so on
> numbers in B1,B2,B3 and so on
>
> thanks,
>
>
> --
> fastballfreddy
> ------------------------------------------------------------------------
> fastballfreddy's Profile:
http://www.excelforum.com/member.php...o&userid=33986
> View this thread: http://www.excelforum.com/showthread...hreadid=539672
>

[fastballfreddy]

thanks for the help so far,

here's the formula that I'm using:

=INDEX($C$35:$AF$35,MATCH(MAX(C41:AF41),C41:AF41,0))
where $C$35:$AF$35 contains names of people & C41:AF41 contains #'s.

This works great if there isn't a tie. Is there a formula to search the range, find the max # and if there are two answers display both names.

ex. the max# is 3 and both joe and sam have 3. it would then show joe / sam or something like that. Is this possible?

If not, then if there is a tie for the max #, to have the cell just display tie.

Thanks,