Hi mate. Im coming again
Please help me to make it simple
<tbody>
</tbody>
Its all about G5 & G6
On G5 & G6 i want the team who win the score at D3/D4 & D8/D9.
If the score is same like D3 & D4 then i want it include the penalty (which will only appear when the score is same only)
The cell for "Penalty" and 2 cell below only appear when the total score is same otherwise its hidden
Please help me to solve these mystery
tQ in advance
Please help me to make it simple
A | B | C | D | E | F | G | |
1 | |||||||
2 | P1 | 1st Result | 2nd Result | Total Score | Penalty | ||
3 | Team A | 2 | 3 | 5 | 5 | ||
4 | Team B | 2 | 3 | 5 | 4 | ||
5 | Team A | ||||||
6 | Team C | ||||||
7 | P2 | ||||||
8 | Team C | 1 | 4 | 5 | |||
9 | Team D | 2 | 2 | 4 |
<tbody>
</tbody>
Its all about G5 & G6
On G5 & G6 i want the team who win the score at D3/D4 & D8/D9.
If the score is same like D3 & D4 then i want it include the penalty (which will only appear when the score is same only)
The cell for "Penalty" and 2 cell below only appear when the total score is same otherwise its hidden
Please help me to solve these mystery
tQ in advance