max or large function
 

Hi,
I have data in column J, associate with column I, data in column M,
assoicated with coumn L, and data in column P, assoicated with coumn O. I
need to find the large or max of J,M,P then it puts the corresponding info
from where the max is from column I, L, O. How would I do this? For ex:

ABC 1 DEF 6 FGH 3

So in this case the formula find the max, which is 6, then gives me DEF
because that is data next to it. Thanks.

max or large function
 

With
I1: abc
J1: 1
L1: def
M1: 6
O1: fgh
P1: 3

Here are a couple options

Q1: =IF(J1=MAX(J1,M1,P1),I1,IF(M1=MAX(J1,M1,P1),L1,IF( P1=MAX(J1,M1,P1),O1)))

or
R1: =MAX(J1,M1,P1)
Q1: =IF(J1=R1,I1,IF(M1=R1,L1,IF(P1=R1,O1)))

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"A.S." wrote:

Hi,
I have data in column J, associate with column I, data in column M,
assoicated with coumn L, and data in column P, assoicated with coumn O. I
need to find the large or max of J,M,P then it puts the corresponding info
from where the max is from column I, L, O. How would I do this? For ex:

ABC 1 DEF 6 FGH 3

So in this case the formula find the max, which is 6, then gives me DEF
because that is data next to it. Thanks.

max or large function
 

=INDEX(I1:O1,MATCH(MAX(J1:P1),J1:P1,0))

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"A.S." wrote in message
...
Hi,
I have data in column J, associate with column I, data in column M,
assoicated with coumn L, and data in column P, assoicated with coumn O. I
need to find the large or max of J,M,P then it puts the corresponding info
from where the max is from column I, L, O. How would I do this? For ex:

ABC 1 DEF 6 FGH 3

So in this case the formula find the max, which is 6, then gives me DEF
because that is data next to it. Thanks.

max or large function
 

Yep, that did it. Thanks!

"Ron Coderre" wrote:

With
I1: abc
J1: 1
L1: def
M1: 6
O1: fgh
P1: 3

Here are a couple options

Q1: =IF(J1=MAX(J1,M1,P1),I1,IF(M1=MAX(J1,M1,P1),L1,IF( P1=MAX(J1,M1,P1),O1)))

or
R1: =MAX(J1,M1,P1)
Q1: =IF(J1=R1,I1,IF(M1=R1,L1,IF(P1=R1,O1)))

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"A.S." wrote:

Hi,
I have data in column J, associate with column I, data in column M,
assoicated with coumn L, and data in column P, assoicated with coumn O. I
need to find the large or max of J,M,P then it puts the corresponding info
from where the max is from column I, L, O. How would I do this? For ex:

ABC 1 DEF 6 FGH 3

So in this case the formula find the max, which is 6, then gives me DEF
because that is data next to it. Thanks.