Match1 Match2 Match3 Match4 Match5 Match6 Total
Winning team is H or A
I have 2 teams (Home & Away) playing 6 matches of multiple games. At the end of the match each team enters their score.
I can calculate:
1) The total for each team.
2) The difference between each team in each individual match using, =ABS(B2-B3)
3) In each match which team won using, =IF(B3>B2,A3,A2), Where teams (home& away) are at A2 & A3.
I would like to calculate which match has the highest difference for the Home team and same for the away team?
Can anybody help.