View Single Post
  #5  
Old 13th February 2005, 03:39 PM
La Mer La Mer is offline
Member
 
Join Date: Jan 1970
Posts: 578
Default

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))
Reply With Quote