I have to find average score for each match but because the scores are in same cell I cannot just use average function Any ideas please?
<colgroup><col span="10"></colgroup><tbody>
</tbody>
Regards
Johnbe
Match 1 | Match 2 | Match 3 | Match 4 | Match 5 | Match 6 | Match 7 | Match 8 | Match 9 | Match 10 |
1 - 2 | 1 - 1 | 2 - 0 | 1 - 0 | 2 - 2 | 1 - 1 | 2 - 1 | 1 - 2 | 3 - 0 | 1 - 1 |
1 - 1 | 2 - 1 | 2 - 0 | 2 - 1 | 1 - 1 | 2 - 2 | 2 - 1 | 2 - 1 | 3 - 0 | 1 - 1 |
1 - 1 | 1 - 1 | 3 - 1 | 2 - 0 | 1 - 1 | 1 - 2 | 2 - 1 | 2 - 1 | 2 - 0 | 2 - 1 |
0 - 3 | 1 - 3 | 3 - 0 | 2 - 1 | 1 - 1 | 0 - 2 | 2 - 0 | 0 - 1 | 3 - 0 | 2 - 1 |
0 - 2 | 1 - 0 | 2 - 1 | 2 - 1 | 1 - 1 | 2 - 1 | 1 - 1 | 1 - 2 | 3 - 0 | 1 - 1 |
0 - 2 | 1 - 1 | 2 - 0 | 2 - 1 | 0 - 0 | 1 - 1 | 2 - 1 | 0 - 1 | 2 - 0 | 1 - 1 |
0 - 2 | 1 - 1 | 3 - 1 | 1 - 2 | 0 - 1 | 0 - 2 | 2 - 2 | 1 - 1 | 4 - 1 | 0 - 2 |
0 - 3 | 2 - 1 | 2 - 0 | 2 - 1 | 1 - 1 | 1 - 1 | 2 - 0 | 0 - 1 | 3 - 0 | 1 - 2 |
1 - 3 | 1 - 1 | 3 - 0 | 2 - 1 | 1 - 1 | 2 - 0 | 3 - 1 | 0 - 2 | 3 - 0 | 2 - 2 |
0 - 2 | 2 - 2 | 3 - 0 | 2 - 1 | 1 - 1 | 1 - 2 | 2 - 0 | 1 - 2 | 3 - 0 | 1 - 1 |
1 - 3 | 1 - 1 | 2 - 0 | 2 - 2 | 2 - 1 | 1 - 1 | 3 - 1 | 1 - 1 | 4 - 0 | 0 - 0 |
1 - 1 | 1 - 1 | 3 - 0 | 2 - 0 | 2 - 1 | 2 - 1 | 2 - 0 | 1 - 2 | 4 - 0 | 1 - 2 |
0 - 2 | 1 - 1 | 3 - 1 | 1 - 1 | 0 - 1 | 2 - 2 | 2 - 0 | 0 - 1 | 4 - 0 | 1 - 1 |
1 - 3 | 1 - 1 | 2 - 1 | 1 - 1 | 1 - 2 | 1 - 2 | 2 - 1 | 1 - 1 | 3 - 1 | 1 - 1 |
0 - 3 | 2 - 1 | 3 - 0 | 1 - 0 | 1 - 2 | 1 - 2 | 2 - 0 | 1 - 0 | 4 - 0 | 1 - 1 |
0 - 2 | 2 - 2 | 2 - 0 | 1 - 1 | 2 - 0 | 1 - 1 | 2 - 1 | 0 - 1 | 3 - 1 | 2 - 2 |
0 - 2 | 1 - 2 | 2 - 0 | 3 - 1 | 0 - 2 | 1 - 1 | 1 - 1 | 1 - 1 | 2 - 0 | 0 - 0 |
3 - 0 | 1 - 2 | 2 - 0 | 1 - 0 | 1 - 1 | 1 - 2 | 2 - 0 | 0 - 1 | 2 - 0 | 1 - 1 |
0 - 3 | 1 - 1 | 2 - 0 | 0 - 1 | 1 - 1 | 1 - 2 | 2 - 0 | 0 - 2 | 3 - 0 | 1 - 1 |
<colgroup><col span="10"></colgroup><tbody>
</tbody>
Regards
Johnbe