View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
A.S. A.S. is offline
external usenet poster
 
Posts: 79
Default 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.