Help deciphering formula

[mq1973]

I need help in deciphering/ modifying this formula. Reference thread is here:

https://chandoo.org/forum/threads/index-with-sequential-criteria.36836/

This is the formula

FR13=IF(COUNTIF(E13:FQ13,"Y"),INDEX($E$4:$FQ$4,MATCH(SUMPRODUCT(MAX(($E13:$FQ13="Y")*($E$67:$FQ$67+$E$10:$FQ$10/100000))),INDEX(($E13:$FQ13="Y")*($E$67:$FQ$67+$E$10:$FQ$10/100000),0),0)),"")

This formula is looking for the product with max value in (E67:FQ67) and max value (E10:FQ10) but I need to modify it to identify the product with max value in (E67:FQ67) and smallest value in (E11:FQ11)

 

[Luke M]

mq1973, this is your 2nd warning about cross-posting. You have previously acknowledged the first warning. Please take a moment to re-read the forum rules.

Acknowledgement:
https://chandoo.org/forum/threads/index-with-sequential-criteria.36836/#post-221098

Cross-post:
https://www.excelforum.com/excel-fo...-and-dependent-dropdown-list.html#post4814677