So, I am a little stuck with a case here in excel.

Say if there are multiple sport matches with home and away results. I want to know how to make, with functions, to get the highest win home, highest win away, biggest loss home and away.

I've got help today with automatic results. But i forgot to ask how to get the automatic home and away win/loss numbers.

For example;

match 1 = Team 1 (2-0) Team 2

match 2 = Team 3 (3-0) Team 4

match 3 = Team 1 (0-3) Team 2

match 4 = Team 3 (0-4) Team 4

I already got the index, match, min, max functions to calculate highest score. But I want to get the highest home and away wins of the different teams.

Maybe a confusing question, hope someone can help. I am wondering maybe to use the =IF function on this one.

Excel edition 2016