Ranking Ties

[Keith Budzynski]

I am using Excel 2002. I have a spreadsheet that ranks
several geographic areas in the country based on as
score. I create the rank using the RANK function. In
some cases the ranks may be tied, so I created an
adjusted rank that looks to see if the rank has already
occurred. If there is no occurance, the cells takes the
rank, if it has occurred, it takes the rank+1. The
formula (an array) is:
{=IF(OR(O22=O$4:$O21),RANK(O22,$O$4:$O$321,1)+1,RANK
(O22,$O$4:$O$321,1))}

The formula works fine when to tie, but I would like to
make it resolve a three way tie. The second occurance
would be Rank+1, the third, RANK+2.

Any thought? Thanks in advance.
Keith

 

[Peo Sjoblom]

For a possible solution

http://www.cpearson.com/excel/rank.htm

 

[Keith Budzynski]

Thanks for the quick response. This looks promising.

I also tried creating a second adjusted score. It breaks
a three way tie, but a less than optimal solution.

Keith