HELP PLS with MAX IF formula (possibly without array) for Excel 2013

vinay salian
vinay salian used Ask the Experts™
on
Hi,

Please help with a MAX (IF) condition formula without array if possible for Excel 2013.
Sample sheet attached.  I would like the result for each row as per column "L" in the attached sheet
Thanks
MAX-formula-sample.xlsx
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Excel & VBA Expert
Most Valuable Expert 2018
Awarded 2015
Commented:
Try this...
In L2
=IF(I2=MAX(INDEX(($F$2:$F$8=F2)*($G$2:$G$8=G2)*($I$2:$I$8),)),"Yes","")

Open in new window

and then copy it down.

Author

Commented:
Perfect. Thanks for your help Neeraj!!
Subodh Tiwari (Neeraj)Excel & VBA Expert
Most Valuable Expert 2018
Awarded 2015

Commented:
You're welcome Vinay!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial