J
JohnT
I have a sheet that contains scores for a R/C flying competition.
Scores are given per round of the contest. If enough rounds are flown
some scores are dropped (each competitors lowest) The number of score
dropped depends on the number of rounds flown . (typically for each
rounds 1 is dropped)
When the final scores are ranked, there is occasion when we get
flyers with an equal rank. In this instance I want to be able to us
the dropped rounds in the rank calculation for just the equal ranke
flyers.
The number of pilots is variable as is the number of dropped rounds.
Does that make sense.
This is the current formula for the ranking based on the number o
rounds being scored as a variable in Cell A1 and the scores being i
the named range 'Scores' (Thanx to Peo for that one)
=SUMPRODUCT(LARGE(Scores,ROW(INDIRECT("1:"&A1)))
Scores are given per round of the contest. If enough rounds are flown
some scores are dropped (each competitors lowest) The number of score
dropped depends on the number of rounds flown . (typically for each
rounds 1 is dropped)
When the final scores are ranked, there is occasion when we get
flyers with an equal rank. In this instance I want to be able to us
the dropped rounds in the rank calculation for just the equal ranke
flyers.
The number of pilots is variable as is the number of dropped rounds.
Does that make sense.
This is the current formula for the ranking based on the number o
rounds being scored as a variable in Cell A1 and the scores being i
the named range 'Scores' (Thanx to Peo for that one)
=SUMPRODUCT(LARGE(Scores,ROW(INDIRECT("1:"&A1)))