Ranking sometimes shows ties and sometimes not

[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.

 

[T. Valko]

The scores range from 1 to 100 with 3 decimal places displayed.

Try rounding in the formula that accumulates the points to terminate at 3
decimal places.

=ROUND(your_formula,3)

 

[RJQMAN]

Thank you - that is an excellent idea. It will take me a few days to test
it, as I am in the process of updating and upgrading the entire program, but
I am fairly confident that your solution will work. I appreciate your help.

 

[T. Valko]

You're welcome.

If that doesn't solve the problem just post back and let us know.