I have found within this website/forum the formula of RANK and COUNTIF... for some reason, it keeps returning problems. See below - any help greatly appreciated: (starts at E26)
<colgroup><col><col><col></colgroup><tbody>
</tbody>
Formula for Column G for team 4 is: =RANK(F29,$F$26:$F$31,0)+COUNTIF($F$26:F29,F29)-1
Formula for Column G for team 5 is: =RANK(F30,$F$26:$F$31,0)+COUNTIF($F$26:F30,F30)-1
Formula for Column G for team 6 is: =RANK(F31,$F$26:$F$31,0)+COUNTIF($F$26:F31,F31)-1
Team 5 and 6 repeat their RANK in column G, and I can't figure out why... other renditions of the formula spit out a number outside of the range (if only 6 numbers, one will show a rank of "7")
Struggle is real - thanks for any help
RANKINGS - COL E F G | ||
Team 1 | 14.00 | 6.00 |
Team 2 | 14.80 | 1.00 |
Team 3 | 14.20 | 4.00 |
Team 4 | 14.10 | 5.00 |
Team 5 | 14.70 | 3.00 |
Team 6 | 14.80 | 3.00 |
<colgroup><col><col><col></colgroup><tbody>
</tbody>
Formula for Column G for team 4 is: =RANK(F29,$F$26:$F$31,0)+COUNTIF($F$26:F29,F29)-1
Formula for Column G for team 5 is: =RANK(F30,$F$26:$F$31,0)+COUNTIF($F$26:F30,F30)-1
Formula for Column G for team 6 is: =RANK(F31,$F$26:$F$31,0)+COUNTIF($F$26:F31,F31)-1
Team 5 and 6 repeat their RANK in column G, and I can't figure out why... other renditions of the formula spit out a number outside of the range (if only 6 numbers, one will show a rank of "7")
Struggle is real - thanks for any help