[Solved] average the same ones and then find the max on the list

by


Assuming the table as you give it is in A1:B6 (with headers in row 1):

=LOOKUP(1,0/FREQUENCY(0,1/(1+AVERAGEIF(A2:A6,A2:A6,B2:B6))),A2:A6)

If more than one company share the highest average score than that occurring first within the list will be returned.

Regards

2

solved average the same ones and then find the max on the list