H
Howard Brazee
I have a handicap calculator in Excel. I discovered a bug in the
part that looks for the top 10 scores:
The following creates a rank for me:
=RANK(R13,R$10:S$29,1)
Trouble is it doesn't handle ties. I have 3 identical scores ranked
#8. I need to process the top 10 scores (it doesn't matter which
of the 3 identical scores 8-11 I discard).
Excel help said to resolve this, use the following:
=RANK(R10,R$10:S$29,1)+COUNT(R$10:S$29)+1-RANK(R10,R$10:S$29,0) -
RANK(R10,R$10:S$29,1)
That changed the three "9" scores to three "11" scores, which didn't
help.
Anybody know how to do this?
part that looks for the top 10 scores:
The following creates a rank for me:
=RANK(R13,R$10:S$29,1)
Trouble is it doesn't handle ties. I have 3 identical scores ranked
#8. I need to process the top 10 scores (it doesn't matter which
of the 3 identical scores 8-11 I discard).
Excel help said to resolve this, use the following:
=RANK(R10,R$10:S$29,1)+COUNT(R$10:S$29)+1-RANK(R10,R$10:S$29,0) -
RANK(R10,R$10:S$29,1)
That changed the three "9" scores to three "11" scores, which didn't
help.
Anybody know how to do this?