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
)
[TABLE="width: 500"]
<tbody>[TR]
[TD]Home Team Scores[/TD]
[TD]No. of times occured[/TD]
[TD]%
[/TD]
[TD][/TD]
[TD]Away Team Scores[/TD]
[TD]No of times occured[/TD]
[TD]%
[/TD]
[/TR]
[TR]
[TD]1-1[/TD]
[TD]3[/TD]
[TD]17.6%[/TD]
[TD][/TD]
[TD]3-0[/TD]
[TD]4[/TD]
[TD]25%[/TD]
[/TR]
[TR]
[TD]1-0[/TD]
[TD]3[/TD]
[TD]17.6%[/TD]
[TD][/TD]
[TD]1-1[/TD]
[TD]2[/TD]
[TD]12.5%[/TD]
[/TR]
[TR]
[TD]1-2[/TD]
[TD]2[/TD]
[TD]17.6%[/TD]
[TD][/TD]
[TD]1-0[/TD]
[TD]2[/TD]
[TD]12.5%[/TD]
[/TR]
[TR]
[TD]2-1[/TD]
[TD]2[/TD]
[TD]11.8%[/TD]
[TD][/TD]
[TD]5-1[/TD]
[TD]1[/TD]
[TD]6.3%[/TD]
[/TR]
[TR]
[TD]0-0[/TD]
[TD]2[/TD]
[TD]11.8%[/TD]
[TD][/TD]
[TD]2-3[/TD]
[TD]1[/TD]
[TD]6.3%[/TD]
[/TR]
[TR]
[TD]3-2[/TD]
[TD]1[/TD]
[TD]11.8%[/TD]
[TD][/TD]
[TD]2-2[/TD]
[TD]1[/TD]
[TD]6.3%[/TD]
[/TR]
[TR]
[TD]2-2[/TD]
[TD]1[/TD]
[TD]5.9%[/TD]
[TD][/TD]
[TD]1-2[/TD]
[TD]1[/TD]
[TD]6.3%[/TD]
[/TR]
[TR]
[TD]0-2[/TD]
[TD]1[/TD]
[TD]5.9%[/TD]
[TD][/TD]
[TD]0-2[/TD]
[TD]1[/TD]
[TD]6.3%[/TD]
[/TR]
[TR]
[TD]4-0[/TD]
[TD]1[/TD]
[TD]5.9%[/TD]
[TD][/TD]
[TD]3-1[/TD]
[TD]1[/TD]
[TD]6.3%[/TD]
[/TR]
[TR]
[TD]2-0[/TD]
[TD]1[/TD]
[TD]5.9%[/TD]
[TD][/TD]
[TD]0-1[/TD]
[TD]1[/TD]
[TD]6.3%[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]0-0[/TD]
[TD]1[/TD]
[TD]6.3%[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
The above chart is the data I would type into sheet 1. While the combined version on sheet 2 is shown below.
[TABLE="width: 500"]
<tbody>[TR]
[TD]Most Likely Score[/TD]
[TD]Combined No. Of Times Occurred[/TD]
[TD]% Chance[/TD]
[/TR]
[TR]
[TD]1-1[/TD]
[TD]5[/TD]
[TD]15.1%[/TD]
[/TR]
[TR]
[TD]1-0[/TD]
[TD]5[/TD]
[TD]15.1%[/TD]
[/TR]
[TR]
[TD]3-0[/TD]
[TD]4[/TD]
[TD]12.1%[/TD]
[/TR]
[TR]
[TD]1-2[/TD]
[TD]3[/TD]
[TD]9%[/TD]
[/TR]
[TR]
[TD]0-0[/TD]
[TD]3[/TD]
[TD]9%[/TD]
[/TR]
[TR]
[TD]2-1[/TD]
[TD]2[/TD]
[TD]6%[/TD]
[/TR]
[TR]
[TD]2-2[/TD]
[TD]2[/TD]
[TD]6%[/TD]
[/TR]
[TR]
[TD]0-2[/TD]
[TD]2[/TD]
[TD]6%[/TD]
[/TR]
[TR]
[TD]3-2[/TD]
[TD]1[/TD]
[TD]3%[/TD]
[/TR]
[TR]
[TD]4-0[/TD]
[TD]1[/TD]
[TD]3%[/TD]
[/TR]
[TR]
[TD]2-0[/TD]
[TD]1[/TD]
[TD]3%[/TD]
[/TR]
[TR]
[TD]3-1[/TD]
[TD]1[/TD]
[TD]3%[/TD]
[/TR]
[TR]
[TD]0-1[/TD]
[TD]1[/TD]
[TD]3%[/TD]
[/TR]
[TR]
[TD]5-1[/TD]
[TD]1[/TD]
[TD]3%[/TD]
[/TR]
[TR]
[TD]2-3[/TD]
[TD]1[/TD]
[TD]3%[/TD]
[/TR]
</tbody>[/TABLE]
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
)[TABLE="width: 500"]
<tbody>[TR]
[TD]Home Team Scores[/TD]
[TD]No. of times occured[/TD]
[TD]%
[/TD]
[TD][/TD]
[TD]Away Team Scores[/TD]
[TD]No of times occured[/TD]
[TD]%
[/TD]
[/TR]
[TR]
[TD]1-1[/TD]
[TD]3[/TD]
[TD]17.6%[/TD]
[TD][/TD]
[TD]3-0[/TD]
[TD]4[/TD]
[TD]25%[/TD]
[/TR]
[TR]
[TD]1-0[/TD]
[TD]3[/TD]
[TD]17.6%[/TD]
[TD][/TD]
[TD]1-1[/TD]
[TD]2[/TD]
[TD]12.5%[/TD]
[/TR]
[TR]
[TD]1-2[/TD]
[TD]2[/TD]
[TD]17.6%[/TD]
[TD][/TD]
[TD]1-0[/TD]
[TD]2[/TD]
[TD]12.5%[/TD]
[/TR]
[TR]
[TD]2-1[/TD]
[TD]2[/TD]
[TD]11.8%[/TD]
[TD][/TD]
[TD]5-1[/TD]
[TD]1[/TD]
[TD]6.3%[/TD]
[/TR]
[TR]
[TD]0-0[/TD]
[TD]2[/TD]
[TD]11.8%[/TD]
[TD][/TD]
[TD]2-3[/TD]
[TD]1[/TD]
[TD]6.3%[/TD]
[/TR]
[TR]
[TD]3-2[/TD]
[TD]1[/TD]
[TD]11.8%[/TD]
[TD][/TD]
[TD]2-2[/TD]
[TD]1[/TD]
[TD]6.3%[/TD]
[/TR]
[TR]
[TD]2-2[/TD]
[TD]1[/TD]
[TD]5.9%[/TD]
[TD][/TD]
[TD]1-2[/TD]
[TD]1[/TD]
[TD]6.3%[/TD]
[/TR]
[TR]
[TD]0-2[/TD]
[TD]1[/TD]
[TD]5.9%[/TD]
[TD][/TD]
[TD]0-2[/TD]
[TD]1[/TD]
[TD]6.3%[/TD]
[/TR]
[TR]
[TD]4-0[/TD]
[TD]1[/TD]
[TD]5.9%[/TD]
[TD][/TD]
[TD]3-1[/TD]
[TD]1[/TD]
[TD]6.3%[/TD]
[/TR]
[TR]
[TD]2-0[/TD]
[TD]1[/TD]
[TD]5.9%[/TD]
[TD][/TD]
[TD]0-1[/TD]
[TD]1[/TD]
[TD]6.3%[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]0-0[/TD]
[TD]1[/TD]
[TD]6.3%[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
The above chart is the data I would type into sheet 1. While the combined version on sheet 2 is shown below.
[TABLE="width: 500"]
<tbody>[TR]
[TD]Most Likely Score[/TD]
[TD]Combined No. Of Times Occurred[/TD]
[TD]% Chance[/TD]
[/TR]
[TR]
[TD]1-1[/TD]
[TD]5[/TD]
[TD]15.1%[/TD]
[/TR]
[TR]
[TD]1-0[/TD]
[TD]5[/TD]
[TD]15.1%[/TD]
[/TR]
[TR]
[TD]3-0[/TD]
[TD]4[/TD]
[TD]12.1%[/TD]
[/TR]
[TR]
[TD]1-2[/TD]
[TD]3[/TD]
[TD]9%[/TD]
[/TR]
[TR]
[TD]0-0[/TD]
[TD]3[/TD]
[TD]9%[/TD]
[/TR]
[TR]
[TD]2-1[/TD]
[TD]2[/TD]
[TD]6%[/TD]
[/TR]
[TR]
[TD]2-2[/TD]
[TD]2[/TD]
[TD]6%[/TD]
[/TR]
[TR]
[TD]0-2[/TD]
[TD]2[/TD]
[TD]6%[/TD]
[/TR]
[TR]
[TD]3-2[/TD]
[TD]1[/TD]
[TD]3%[/TD]
[/TR]
[TR]
[TD]4-0[/TD]
[TD]1[/TD]
[TD]3%[/TD]
[/TR]
[TR]
[TD]2-0[/TD]
[TD]1[/TD]
[TD]3%[/TD]
[/TR]
[TR]
[TD]3-1[/TD]
[TD]1[/TD]
[TD]3%[/TD]
[/TR]
[TR]
[TD]0-1[/TD]
[TD]1[/TD]
[TD]3%[/TD]
[/TR]
[TR]
[TD]5-1[/TD]
[TD]1[/TD]
[TD]3%[/TD]
[/TR]
[TR]
[TD]2-3[/TD]
[TD]1[/TD]
[TD]3%[/TD]
[/TR]
</tbody>[/TABLE]
