Hey fellas.
Me & my friends running a football prediction competition for English Premier League. I was wondering if there is a formula that could automatically compare actual results with predicted results and assign points.


The scoring system is as like this:

Correct Result: 7 points
Correct Result With Goal Difference: 5 points
Only Correct Winner: 3 Points
Wrong Result: 1 Points

Example:
Like Liverpool vs Norwich

Actual Result: 3-1

Player 1: 3-1 (7 Points)
Player 2: 2-0 or 4-2 or 5-3 or ... (5 Points)
Player 3: 1-0 or 2-1 or 3-0 or ... (3 Points)
Player 4: 0-0 or 0-1 or 1-3 or ... (1 Points)

Example.xlsx

Thank You so much!