software

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: www.excelforum.com/member.php...oamp;userid=33986
View this thread: www.excelforum.com/showthread...hreadid=539672=INDEX(A1:A10,MATCH(MAX(B1:B10),B1:B10,0))

--
Kind regards,

Niek Otten

quot;fastballfreddyquot; gt; wrote in message
news:fastballfreddy.27gaxm_1147028100.846@excelfor um-nospam.com...
|
| 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: www.excelforum.com/member.php...oamp;userid=33986
| View this thread: www.excelforum.com/showthread...hreadid=539672
|
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 !
---------------------------------------------------------------------------
quot;fastballfreddyquot;
gt; wrote in
message news:fastballfreddy.27gaxm_1147028100.846@excelfor um-nospam.com...
gt;
gt; I have 10 cells w/ various amounts of numbers. I want a formula to find
gt; the max number and instead of showing that amount, have it show the name
gt; that goes w/ that amount. Do I use the IF and MAX function?
gt;
gt; names in A1, A2, A3 and so on
gt; numbers in B1,B2,B3 and so on
gt;
gt; thanks,
gt;
gt;
gt; --
gt; fastballfreddy
gt; ------------------------------------------------------------------------
gt; fastballfreddy's Profile:
www.excelforum.com/member.php...oamp;userid=33986
gt; View this thread: www.excelforum.com/showthread...hreadid=539672
gt;
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 amp; 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,--
fastballfreddy
------------------------------------------------------------------------
fastballfreddy's Profile: www.excelforum.com/member.php...oamp;userid=33986
View this thread: www.excelforum.com/showthread...hreadid=539672