Display The Cell Of The Maximum Value.

S

sokevin

DISPLAY THE CELL OF THE MAXIMUM VALUE.


Hi again.

I have values in


a2, b2, c2.


i want d2 to display the value of the highest cell out of a2, b2 or c2


e.g

a2=10, b2=15, c2=99 -> d2=99
a2=80, b2=1, c2=1 -> d2=8
 
S

sokevin

Actually i did this...

i actually wanted to write the name of the person who got the highest.

=MAX(J2:L2)=J2,"Jane",IF(MAX(J2:L2)=K2,"Bob",IF(MAX(J2:L2)=L2,"Steve","other")

is this an efficient method?

th
 
S

sokevin

correction

IF(MAX(J2:L2)=J2,"Jane",IF(MAX(J2:L2)=K2,"Bob",IF(MAX(J2:L2)=L2,"Steve","Other"
 
J

JE McGimpsey

I might do this instead:

=INDEX({"Jane","Bob","Steve"},MATCH(MAX(J2:L2),J2:L2,FALSE))
 
F

Frank Kabel

Hi
lets assume you have stored the names in row one. e.g.
J1=Jane

then use the following formula
=INDEX(J1:L1,MATCH(MAX(J2:L2),J2:L2,0)
 
H

hglamy

I wish I would know as much about Excel as you do, Frank !

Thank you so much !

hglamy
 
Top