Rank function - can it be amended?

[w_r_fox]

You have a list of values in column A and you want their ranks (1 against
the highest value and so on) in column B. The Rank function does this.
However with tied values, the function gives such values the same rank - the
lowest of the ranks they would have got. It would be much more useful to
give tied values the mean of the ranks they would have got. (For example
you'd have a check on the sum of the ranks.) Is it possible to do this?

 

[Tushar Mehta]

I'm reasonably sure this has been answered before. Check the
google.com archives of the XL NGs.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

 

[Dave Peterson]

Chip Pearson has a bunch of stuff on ranking at:
http://www.cpearson.com/excel/rank.htm
Look for: Unique Ranks

And there's a workbook that you can download, too.