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.
|