That page is good if I were to break the ties, but in these cases we don't.
Unfortunately it doesn't cover the issue we're having. It looks like the
maximum it will let me do is 30 decimal places and the numbers are still
identical. Bummer. This list is small, but I am also doing a rank of 400
employees and don't feel this is gonna be accurrate now.
"Jim May" wrote:
For any question of RANKING go to:
http://www.cpearson.com/excel/rank.aspx
Jim May
"57Caddy" wrote:
Hello,
I am trying to rank our employees but for some reason when a bunch of people
are tied, it tends to through the rank off. For example, we have four people
with a score of 3.00000 ranked at 5th place. However, we have another person
with a 3.00000 that is ranked 9th. I've included my formula below. I
doublechecked the range, and it is correct. All the cells are formatted as
numbers as well. Any ideas what may be causing this?
Thanks
=RANK(R6,$R$6:$R$23)