13th February 2005, 03:43 PM
|
|
Member
|
|
Join Date: Jan 1970
Posts: 4,428
|
|
Quote:
|
Originally Posted by La Mer
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))
|
Yes La Mer, I could use the rank function,but I export a whole Saturday's racing to the one spreadsheet and find my way easier as it only takes one simple formula to get what I want all the way down the page. |