This was excellent, i have one more question if two playrers have the same
total the formula grabs the first name. Sometimes two players are tied and i
need to have both in order, can this formula be tweaked to accomodate this.
Example:

Player a has 5 goals, player b has 9 goals player c has 5 goals the order
should show

Player b-9
player a-5
player c-5

any suggestions?

I almost have this working perfect and your help is appreciatted.


"excelent" wrote:

=INDEX($B$2:$B$9,MATCH(LARGE($A$2:$A$9,ROW(1:1)),$ A$2:$A$9,0))


"Randy" skrev:

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