Ranking Formula Question
 

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)

Ranking Formula Question
 

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)

Ranking Formula Question
 

If you expand the number of decimal places further you may find that
four employees have a value of 3.0000004 and the other employee has
3.0000001 - you can overcome this discrepancy by putting ROUND( ... ,
2) around your formulae in column R (indicated by ... ).

Hope this helps.

Pete

On Sep 26, 12:22 am, 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)

Ranking Formula Question
 

Actually Pete, I had thought of that as well and took it out to 20 decimal
places and they still matched up.

"Pete_UK" wrote:

If you expand the number of decimal places further you may find that
four employees have a value of 3.0000004 and the other employee has
3.0000001 - you can overcome this discrepancy by putting ROUND( ... ,
2) around your formulae in column R (indicated by ... ).

Hope this helps.

Pete

On Sep 26, 12:22 am, 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)

Ranking Formula Question
 

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)

Ranking Formula Question
 

But did you try modifying your formula with ROUND, and did this have
any effect on the rankings?

Pete

On Sep 26, 4:58 pm, 57Caddy wrote:
Actually Pete, I had thought of that as well and took it out to 20 decimal
places and they still matched up.



"Pete_UK" wrote:
If you expand the number of decimal places further you may find that
four employees have a value of 3.0000004 and the other employee has
3.0000001 - you can overcome this discrepancy by putting ROUND( ... ,
2) around your formulae in column R (indicated by ... ).

Hope this helps.

Pete

On Sep 26, 12:22 am, 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)- Hide quoted text -

- Show quoted text -