Need some help ranking, this is just a small sample. I found a formula on here to rank the teams based on columns D & F, but can't figure out how to use L as a tiebreaker instead of order in the spreadsheet. Obviously this is just a small sample of the sheet there are more columns so the formula won't match up completely. I labeled the columns as I have them in my sheet. I hope I did this right.
<tbody>
</tbody>
Code:
=COUNTIFS(D:D,D2,F:F,">"&F2)+COUNTIFS(D$2:D2,D2,F$2:F2,F2)
Column D | Column F | Column L | |
Class | PR | SF | Desired Rank |
1A | 12 | 2 | 1 |
1A | 10 | 3 | 2 |
1A | 10 | 2 | 3 |
2A | 14 | 4 | 1 |
2A | 12 | 3 | 2 |
2A | 12 | 3 | 3 |
3A | 12 | 5 | 1 |
3A | 10 | 2 | 2 |
3A | 10 | 2 | 3 |
<tbody>
</tbody>