Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to use large function? | Excel Discussion (Misc queries) | |||
Using LARGE Function | Excel Discussion (Misc queries) | |||
Large Function | Excel Worksheet Functions | |||
IF Function too Large | Excel Discussion (Misc queries) | |||
Using LARGE Function | Excel Worksheet Functions |