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>
