Excel 2007 : Rank players by name

Hi,

I am not the greatest with excel and I am having an issue creating a formula that will show players ranked from 1-? based off other columns i already have created.

Basically I have three ways that i want the ranks to show in the middle of the sheet. Rank by points, by total wins, and by win ratio columns G,H, and I.
In those columns i want to show only names from Column A

Rank points should be from column M, wins from column B, and ratio from column D.

If anyone could help me with this it would be greatly appreciated.

Thanks,

Shawn

Based on the possibility that you may have duplicate rankings, then it is best to use some helper columns for each column you want to rank.

So Insert 2 new columns after column E,

In F3 put formula:

=RANK(B3,$B$3:$B$15)+COUNTIF(B$3:B3,B3)-1

copied down

in G3 put formula:

=RANK(D3,$D$3:$D$15)+COUNTIF(D$3:D3,D3)-1

and in M4 put formula:

=RANK(O4,$O$4:$O$16)+COUNTIF(O$4:O4,O4)-1

copied down

then in what should now be I4:

=IF(H4>MAX($M$4:$M$16),"",INDEX($N$4:$N$16,MATCH(ROWS($A$1:A1),$M$4:$M$16,0)))

copied down

in J4:

=IF($H4>MAX(F$3:F$15),"",INDEX($A$3:$A$15,MATCH(ROWS($A$1:$A1),F$3:F$15,0)))

copied to next column and down.

You may want to adjust the ranges to accomodate getting 20 outputs if necessary.