Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I calculate scores and rank the winners in a competition. The scores are a
total of points from different judges. Awards are given for the order of finish. In the event of a tie, the awards are presented as for a tie. For example, if two groups finish in second place with an identical score of 87.553, there should be two second place awards presented. Sometimes the scores are identical, and the ranking displays them as identical, which is what I want. However, at other times the calculated scores are identical, and the ranking function ranks them - seemingly at random. I opened up the decimal places and cannot find any differences between the two scores, yet the ranking function ranks them. This can cause the awards to be presented incorrectly, as the presenter, if not careful, may not notice that the scores are identical, but instead see the ranking which does not show them as identical. I would like identical scores to be displayed as identical. Any suggestions on how to achieve this? The scores range from 1 to 100 with 3 decimal places displayed. -- RJQ |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Need to rank values with ties | Excel Worksheet Functions | |||
Rank without skipping for ties | Excel Worksheet Functions | |||
Ranking question (ties) | Excel Discussion (Misc queries) | |||
Changing percentrank ties | Excel Discussion (Misc queries) | |||
Ranking of cells from 1 to 20 with ties | Excel Worksheet Functions |