Hi all, I've recently made a spreadsheet for this seasons champions league but am having problems with the head to head on there. The issue involves Group F as 3 teams (Arsenal, Borussia Dortmund and Napoli) are all tied on 6 points (Marseille are fine as they have 0 and are ranked 4th). The issue that I am having is that they haven't been ranked properly
Ranking should be 1st Arsenal, 2nd B Dortmund and 3rd Napoli but the ranking that i have at the minute is 1st B Dortmund, 2nd Arsenal and 3rd Napoli

Is there a certain formula that i need to insert in order to get the group to rank correctly?



Here is the spreadsheet below
cltemp 13-14.xlsx