Need a Formula (For deciding which customer is giving most profit)

[ahmad08]

Hi Gyus,
I am a beginner in this forum.
In my sheet attached below, I have 3 columns.

A=S.No
B=Customer
C=Profit

I want to calculate automatically, which customer is giving most profit out of these?

below is link of my file

Customer giving most profit.xlsx - Google Drive

 

[mart37]

only the first:
=INDEX(B2:B33,MATCH(MAX(C2:C33),C2:C33;0))

 

[ahmad08]

Formula is working only for maximum value cell. if a customer is not giving a maximum value at once but giving small profits number of times which sums upto most profit. At that time formula is not working properly.
See below sheet.

Formula of customer giving most profit not working properly.xlsx - Google Drive

 

[mart37]

{=INDEX(B2:B12,SUMPRODUCT(MIN((IF(MAX((SUMIF($B$2:$B$12,$B2:$B12,$C$2:$C$12)))=((SUMIF($B$2:$B$12,$B2:$B12,$C$2:$C$12))),ROW(1:11))))))}


Entered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}. Note: Do not try and enter the {} manually yourself.

 

[ahmad08]

Thanks mart37

it is working.