Ranking Duplicate Numbers

[RJQMAN]

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

 

[RJQMAN]

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.

 

[JP]

Check out http://www.cpearson.com/excel/Rank.aspx and see if there's
anything there that can help you.

--JP