I need help creating a formula in excel. I have two columns of info i would
like to analyze column a for the highest total once identified take the name
from column b and put the result in column c. I need to do this for 22
players and show the results from highest to lowest.

Column A Column B Column C-result

Goals Player leaders

5 a H
15 b c
22 c f
3 d e
18 e b
19 f a
0 g d
40 h g