Ranking Cells

Posted by Dennis Jarzombek on September 01, 2000 10:25 AM

I have a spreadsheet that calculates finish times of sailboats in regattas. I would like to have a cell calculate the position a boat finished the race in. If col A had a list of finish times, I want col B to display a 1 for the fastest boat, a 2 for the secon fastest etc..

Posted by Scott on September 01, 0100 10:43 AM

Dennis:

Try the RANK function. Syntax is as follows:

Assume cells A1-A5 have your scores, in B1 type =RANK(a1,$a$1:$a$5,1). The value in B1 will be the corresponding position cell A1 has in cells A1 to A5. Make sure your use an absolute reference for the cell range containing your scores. Also, the parameter of 1 at the end of the formula assumes the comparison list is sorted in ascending order.

Let me know how it works!
Thanks!
Scott