26
Folks,
I'm seeking a way to calculate positions in a series from the number of points where the lower number of points gets the higher position. Now this is fine except when the number of points gained is a tie.
In an example series, the person with 3 points is in 1st place and he with 6 points is in 2nd place. However, there are two people with 8 points and two others with 11 points and a need to determine the relative positions. To solve this, there is a rule which states that in the event of a tie, the person with the best score in a single event is deemed to win the tie break - so if the tie is 8 points, the person with individual event scores of 1, 2 and 5 beats the person with an individual score of 1, 3 and 4.
I've been struggling with this, of and on for a month . I have access to all the data but despite all sorts of loops, cannot get the "right" answer. Has anyone come across this sort of thing before or can suggest a way forward?
Thanks in anticipation to anyone who may be able to help
Best Regards
Helm
