Display corresponding value...

[cricket_stoner]

I've already got this array formula from daddylonglegs:
=MAX(M5:M24)&"/"&MIN(IF(M5:M24=MAX(M5:M24),IF(L5:L24,L5:L24)) )

It selects the highest value/s in the M column and matches it with the lowest possible corresponding L value in the format M/L

I now want to add another bit, to make it M/L (J). It doesn't matter what's in column J as long as it's from the corresponding row that was used in the M/L.

It's very similar to another problem I've had solved here but I can't seem to make the necessary adaptations to make it work.

[Paul]

Hi cricket_stoner,

Try this function to include the value in column J corresponding to the row used in column M/L:

Please Login or Register  to view this content.

New section is in red.

[cricket_stoner]

Thanks for the help.
That works most of the time but when there are multiple highest M values, it doesn't always select the J in the same row as the L does. It is always in the same line as one of the highest M values, but not the one with the lowest L value. Does that makes sense....?

J L M
4 18 3
6 19 3

3/18 is the best, and so it should read 3/18 (4)

but it says 3/18 (6)

[Paul]

Ok, how about this one:

Please Login or Register  to view this content.

[cricket_stoner]

That's the one. Good stuff.

Cheers mate, much appreciated.