Display The Cell Of The Maximum Value.

[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

 

[JE McGimpsey]

One way:

D2: =MAX(A2:C2)

 

[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

 

[sokevin]

correction

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

 

[JE McGimpsey]

I might do this instead:

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

 

[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)

 

[hglamy]

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

Thank you so much !

hglamy