Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Ranking Duplicate Numbers
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). |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Ranking numbers that are a variance of 100% | Excel Worksheet Functions | |||
RANKING WHEN THERE ARE 2 SAME NUMBERS | Excel Discussion (Misc queries) | |||
Ranking numbers | Excel Discussion (Misc queries) | |||
Ranking numbers | Excel Discussion (Misc queries) | |||
Numbers used for Ranking | Excel Worksheet Functions |