Hi Folks
Just wondering if someone can help me speed up a process.
In the attached sheet you will see some sets of soccer results which I type in as text on sheet 1. What I want to do is combine the sets of results from both teams in order to find the most likely scoreline at full time,and also show the percentage alongside.
On sheet 2 is what I would like to achieve and you can see there how both sets of results have been combined for both teams on Sheet 1.
So if I could just type in the scores into sheet 1 and once typed,sheet 2 will auto combine the results from sheet 1 that would be great.
Any help would be much appreciated (and also speed up the process for me
)
<tbody>
</tbody>
The above chart is the data I would type into sheet 1. While the combined version on sheet 2 is shown below.
<tbody>
</tbody>
Just wondering if someone can help me speed up a process.
In the attached sheet you will see some sets of soccer results which I type in as text on sheet 1. What I want to do is combine the sets of results from both teams in order to find the most likely scoreline at full time,and also show the percentage alongside.
On sheet 2 is what I would like to achieve and you can see there how both sets of results have been combined for both teams on Sheet 1.
So if I could just type in the scores into sheet 1 and once typed,sheet 2 will auto combine the results from sheet 1 that would be great.
Any help would be much appreciated (and also speed up the process for me
Home Team Scores | No. of times occured | % | Away Team Scores | No of times occured | % | |
1-1 | 3 | 17.6% | 3-0 | 4 | 25% | |
1-0 | 3 | 17.6% | 1-1 | 2 | 12.5% | |
1-2 | 2 | 17.6% | 1-0 | 2 | 12.5% | |
2-1 | 2 | 11.8% | 5-1 | 1 | 6.3% | |
0-0 | 2 | 11.8% | 2-3 | 1 | 6.3% | |
3-2 | 1 | 11.8% | 2-2 | 1 | 6.3% | |
2-2 | 1 | 5.9% | 1-2 | 1 | 6.3% | |
0-2 | 1 | 5.9% | 0-2 | 1 | 6.3% | |
4-0 | 1 | 5.9% | 3-1 | 1 | 6.3% | |
2-0 | 1 | 5.9% | 0-1 | 1 | 6.3% | |
0-0 | 1 | 6.3% | ||||
<tbody>
</tbody>
The above chart is the data I would type into sheet 1. While the combined version on sheet 2 is shown below.
Most Likely Score | Combined No. Of Times Occurred | % Chance |
1-1 | 5 | 15.1% |
1-0 | 5 | 15.1% |
3-0 | 4 | 12.1% |
1-2 | 3 | 9% |
0-0 | 3 | 9% |
2-1 | 2 | 6% |
2-2 | 2 | 6% |
0-2 | 2 | 6% |
3-2 | 1 | 3% |
4-0 | 1 | 3% |
2-0 | 1 | 3% |
3-1 | 1 | 3% |
0-1 | 1 | 3% |
5-1 | 1 | 3% |
2-3 | 1 | 3% |
<tbody>
</tbody>