simply want to say if Home Team is A, and Home Score is greater than Away Score, use AHW (A Home Win)
Only bothered about teams A & B so 8 possible combinations.
Hope someone can help me..
Thanks
<TBODY>
</TBODY><COLGROUP><COL><COL><COL span=3><COL></COLGROUP>
Only bothered about teams A & B so 8 possible combinations.
Hope someone can help me..
Thanks
A</SPAN> | B</SPAN> | C</SPAN> | D</SPAN> | E</SPAN> | |
1</SPAN> | Home Team</SPAN></SPAN> | HomeScore</SPAN> | Away Score</SPAN> | Away Team</SPAN></SPAN> | Result</SPAN> |
2</SPAN> | A</SPAN></SPAN> | 1</SPAN> | 2</SPAN> | C</SPAN></SPAN> | AHL</SPAN> |
3</SPAN> | A</SPAN></SPAN> | 3</SPAN> | 0</SPAN> | D</SPAN></SPAN> | AHW</SPAN> |
4</SPAN> | B</SPAN></SPAN> | 4</SPAN> | 1</SPAN> | E</SPAN></SPAN> | BHW</SPAN> |
5</SPAN> | B</SPAN></SPAN> | 2</SPAN> | 3</SPAN> | F</SPAN></SPAN> | BHL</SPAN> |
6</SPAN> | G</SPAN></SPAN> | 3</SPAN> | 2</SPAN> | A</SPAN></SPAN> | AAL</SPAN> |
7</SPAN> | H</SPAN></SPAN> | 1</SPAN> | 2</SPAN> | A</SPAN></SPAN> | AAW</SPAN> |
8</SPAN> | D</SPAN> | 5</SPAN> | 1</SPAN> | B</SPAN> | BAL</SPAN> |
9</SPAN> | C</SPAN> | 1</SPAN> | 3</SPAN> | B</SPAN> | BAW</SPAN> |
<TBODY>
</TBODY><COLGROUP><COL><COL><COL span=3><COL></COLGROUP>