YEAR | CLIENT | STATION | STATIONCNT | STATIONCNT RANK | |
2019 | A | CHI | 8 | 1 | |
2019 | A | LAX | 2 | 2 | |
2018 | A | DAL | 7 | 3 | |
2018 | A | SFA | 25 | 1 | |
2018 | A | NYO | 8 | 2 | |
2018 | B | SFA | 1 | 4 | |
2018 | B | CHO | 10 | 1 | |
2018 | B | CHI | 4 | 2 | |
2019 | B | LAO | 2 | 3 | |
2019 | B | LAX | 23 | 1 | |
2019 | B | NYA | 4 | 2 |
<tbody>
</tbody>
I normally use SUMPRODUCT if there is only two fields (ie:CLIENT & STATIONCNT) but now have a third column, YEAR, that I need to include the ranking.... Can someone help me with this formula?