Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Tricky Ranking Question | Excel Discussion (Misc queries) | |||
Ranking Question Listing Same Sheet! | Excel Discussion (Misc queries) | |||
Ranking question (ties) | Excel Discussion (Misc queries) | |||
Ranking formula question? | Excel Discussion (Misc queries) | |||
Another ranking question | Excel Worksheet Functions |