R
RJQMAN
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.
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.