Rank formula using 2 columns in Excel 97

[L.J.]

In the problem below in Column R is the # of wins by a player
Column S is the net points accumulated in each match. T
column is the position as determined by the function
"Rank" which was written as follows =Rank(R3,R3:R10)
Because some players have the same # of wins the true
position should be determined by the wins & points. I.E.
the player in row 4 (3 win 6points)has a better win/point
result than player in row 9 )3wins -6points). Likewise
player in row 7 is better than row 6.
How should this function or formula be written to combine
both column R & S to give a true ranking?
Columns
R S T
Wins Points Position
6 37 1 Row 3 should be ranked 1
5 24 2 Row 4 " " 2
3 6 4 Row 5 " " 4
2 -13 7 Row 6 " " 8
2 -9 7 Row 7 " " 7
4 -10 3 Row 8 " " 3
3 -6 4 Row 9 " " 5
3 -29 4 Row 10 " " 6

..

 

[Biff]

Hi LJ,

This may be easier although it does leave open the
possibility of ties.

Player is in col Q, Wins is in col R, Points is in col S.
In col T, eliminate the rank function and just enter the
numbers 1,2,3...8. Now select the range in cols Q,R, and S
that contain the data. Goto DATA>SORT. In the SORT BY box
select Wins if you have a header or col R if you don't.
Click DESCENDING. In the THEN BY box select Points or col
S and click DESCENDING. Then click OK. That should do it.
The numbers in col T will be the rank. You could automate
this by creating a macro.

Biff

 

[Len J.Canavan]

Hi Biff,
By far this has been the easiest
solution.......and it
works. Thanks a lot. I've had some difficult solutions that
got close
but not "on the money" as you have submitted.
Thanks again,
Best regards,
Len J.Canavan.

 

[Biff]

Sounds great!

Biff

-----Original Message-----
Hi Biff,
By far this has been the easiest
solution.......and it
works. Thanks a lot. I've had some difficult solutions that
got close
but not "on the money" as you have submitted.
Thanks again,
Best regards,
Len J.Canavan.



.