quakerzoom
New Member
- Joined
- Jun 13, 2014
- Messages
- 1
Hi guys!
I have two columns with values. The first column contains personal bets in a standard 1x2 system for betting. The second column contains results of the games. The third column contains points awarded for correct betting.
Betting Game Result Points awarded
1x 1 2
X 2 0
1x2 x 1
2 1 0
1 1 3
X 2 0
12 2 2
<tbody>
</tbody>
What i want to do is to check column 1 against column 2, and award points in column 3.
If there's a valuematch in column 1 when it only contains one value (1, x or 2), it should give 3 points in column 3, otherwise 0.
If there's a valuematch in column 1 when it contains two values (1x, x2 or 12) if should give 2 points in column 3, otherwise 0.
If there's a value called 1X2 in column 1, it should give 1 point in column 3.
I have 40 result sheets to correct with 48 games in each. So in total 1920 checks.
I have two columns with values. The first column contains personal bets in a standard 1x2 system for betting. The second column contains results of the games. The third column contains points awarded for correct betting.
Betting Game Result Points awarded
1x 1 2
X 2 0
1x2 x 1
2 1 0
1 1 3
X 2 0
12 2 2
1x | 1 | 2 |
x | 2 | 0 |
1x2 | x | 1 |
2 | 1 | 0 |
1 | 1 | 3 |
x | 2 | 0 |
12 | 2 | 2 |
<tbody>
</tbody>
What i want to do is to check column 1 against column 2, and award points in column 3.
If there's a valuematch in column 1 when it only contains one value (1, x or 2), it should give 3 points in column 3, otherwise 0.
If there's a valuematch in column 1 when it contains two values (1x, x2 or 12) if should give 2 points in column 3, otherwise 0.
If there's a value called 1X2 in column 1, it should give 1 point in column 3.
I have 40 result sheets to correct with 48 games in each. So in total 1920 checks.