MAX #, display name

F

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,
 
N

Niek Otten

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

--
Kind regards,

Niek Otten

|
| 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?action=getinfo&userid=33986
| View this thread: http://www.excelforum.com/showthread.php?threadid=539672
|
 
F

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,
 
Top