Name and place who has the max Qty.

[Deepak Sharma]

Hello All,

Please provide the solution! File attached! Please see sheet1.

Regards,

 

[Hui]

I11: =INDEX(B3:B13,MATCH(MAX(D3:D13),D3:D13,0))&" - "&INDEX(C3:C13,MATCH(MAX(D3:D13),D3:D13,0))

The following are the corrected solutions:
I8: =INDEX(B3:B13,MATCH(MAX(E3:E13),E3:E13,0))
I9: =INDEX(B3:B13,MATCH(MIN(E3:E13),E3:E13,0))

Your last question, I13, is ambiguous

 

[rahulshewale1]

Hii ,

Non array formula.(excel 2OI6)

Formula in cell : I 1I
=MAXIFS($D$3:$D$13,$C$3:$C$13,$I$7,$B$3:$B$13,$I$8)

I 13
=MINIFS($D$3:$D$13,$C$3:$C$13,$I$7,$B$3:$B$13,$I$9)


Array formula below excel 2OI3 version..

https://exceljet.net/formula/max-if-criteria-match


Regard
Rahul Shewale

 

[Deepak Sharma]

Thank you so much Hui & Rahul !!! It works now!