
13th February 2005, 03:39 PM
|
Member
|
|
Join Date: Jan 1970
Posts: 578
|
|
Quote:
Originally Posted by Chrome Prince
Hi xptdriver,
Now here's a little ranking trick I use to give the rating a rank.
First sort by ranking as above.
Now in a new column enter this formula:
=IF(B1&C1<>B2&C2,1,L1+1)
Assuming the track is in column B, the Race number is in column C and this formula is going in column L.
Now copy this and paste it all the way down column L.
Copy(column L) & paste special (Values).
You now have the rankings. Regards.
|
Chrome, any reason why you just wouldn't use the rank worksheet function?
The following is an example:
=IF(A1="","",RANK(A1,A$1:A$26))
|