Ranking Duplicate Numbers
On Jan 16, 11:10*pm, " wrote:
My program calculates the scores in a competition, and there can be a
lot of variables entering into the calculation, including some
averaging. *I used the Ranking function in Excel to list the finishers
in order. *It seemed to work fine for a long time, but this season an
odd thing happenned.
In one event there were two tie scores, and instead of showing them as
a tie (as it had done in all of my tests), it ranked them one behind
the other, causing some problems at the event. *There was no averaging
in this particular event - just adding together numbers. *I do not
understand why the ranking did not show a tie.
Also, nex season, in some events the sponsor would like to show the
tie scores as ties (and I thought that the program would do that), in
in some other events, if the scores are tied, the sponsor would like
to break the ties using a secondary criteria. *I am looking for some
way to do the following;
1) If the scores are tied, be certain that the program shows them as
tie scores, and
2) If the sponsor so desires (I can set up a macro he could choose to
use if I know how to develop the logic), the ranking would occur based
on the secondary criteria.
I think if I could just get the ties to display as ties for sure, I
could develop the logic for the second option ok. *Can anyone explain
what I should do to insure that the ranking shows tie scores as ties?
Thanks in advance (again).
I am reposting this question again - perhaps there is an obvious
answer that someone has already posted, but I am unable to find it. I
would appreciate just a touch of help here to set me on the right path
- I do not mind doing the work, but just do not know how to get there
from here.
|