Formula to find group with highest sales per supplier

[JV0710]

Good Evening All
Please can I get some help with a formula :

In the view below I would like a formula in column E that sums the sales by Supplier (column B) in each group (column A) and returns the Group where the highest sales occurred for each supplier, irrespective of product (column c). So, as the table below column E has "Grp3" for all rows with supplier 1 and Grp 2 for all rows with supplier 2 etc

Thanks in advance

 

[JV0710]

Not a problem, try

=INDEX(SORTBY(UNIQUE($A$2:$A$15),SUMIFS(D:D,B:B,B2,A:A,UNIQUE($A$2:$A$15)),-1),1)

This one works perfectly Fluff . . . Thanks very much for your help.

 

[JV0710]

Thanks very much to you both, Fluff and Dante . . . I will use both solutions to publish the final worksheet and for my team to learn new approaches. How do I mark the post solved for both answers ?

 

[Peter_SSs]

How do I mark the post solved for both answers ?

You can't. You just decide which one is best for you. The mark as solution is not to give the helpers a 'score card' but to help future readers by letting them know that an answer to the question exists in the thread and to make it easy to find.

 

[Peter_SSs]

You can't.

.. but I did forget to mention that you can "Upvote" multiple responses if you found them helpful.

 

[Fluff]

Thanks very much to you both, Fluff and Dante

Glad we could help & thanks for the feedback.