Forum Discussion
comparing cell values to determine which is highest, then returning the name assocaited with it
Okay, so I've exhausted everything I can find and I'm still nowhere on this. The problem is this: Part 1: The formula to look at both A2 and B2 to determine which is highest, then in...
Hi kemble999,
To enhance the flavor of your cocktail, I added a red color in the attached file. The formula in D3 is:
=IF(MAX(A3:C3)>D$1,
LOOKUP(2,1/(FREQUENCY(0,1/A3:C3)),A$2:C$2),
"None")
Conversely, the array formula (entered with Ctrl+Shift+Enter) in J3 is:
=IF(MAX(MMULT(TRANSPOSE(--(F$3:F3=F3)),G$3:I3))>J$1,
LOOKUP(2,1/(FREQUENCY(0,1/MMULT(TRANSPOSE(--(F$3:F3=F3)),G$3:I3))),G$2:I$2),
"None")
Note that the values in K7:M14 were presented only for verification purposes. Thus, they are not referred to in the foregoing formula.
Cheers,