Formula to display previous result?

[bluegold]

I need a formula to calculate a team's last game result - i.e Column L & M
Where column L is the Favourite team's last result and column M is the non-favourite team's last result. I have manually entered the answers to show the format I want results shown as. The previous game's scores are located in column's Q & R (For & Against). I'm guessing helper columns will be required. Any idea's as I'm stumped!

<table style="background-color: rgb(255, 255, 255); padding-left: 2pt; padding-right: 2pt; font-family: Arial,Arial; font-size: 10pt;" border="1" cellpadding="0" cellspacing="0"> <colgroup> <col style="width: 30px; font-weight: bold;"> <col style="width: 14px;"> <col style="width: 73px;"> <col style="width: 73px;"> <col style="width: 48px;"> <col style="width: 38px;"> <col style="width: 45px;"> <col style="width: 31px;"> <col style="width: 44px;"> <col style="width: 46px;"> <col style="width: 39px;"> <col style="width: 39px;"> <col style="width: 32px;"> <col style="width: 32px;"> <col style="width: 45px;"> <col style="width: 38px;"> <col style="width: 33px;"> <col style="width: 28px;"> <col style="width: 28px;"> <col style="width: 45px;"> <col style="width: 45px;"> <col style="width: 67px;"> <col style="width: 86px;"> <col style="width: 94px;"></colgroup> <tbody> <tr style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt; font-weight: bold;"> <td>
</td> <td>A</td> <td>B</td> <td>C</td> <td>D</td> <td>E</td> <td>F</td> <td>G</td> <td>H</td> <td>I</td> <td>J</td> <td>K</td> <td>L</td> <td>M</td> <td>N</td> <td>O</td> <td>P</td> <td>Q</td> <td>R</td> <td>S</td> <td>T</td> <td>U</td> <td>V</td> <td>W</td></tr> <tr style="height: 15px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">1</td> <td style="text-align: left; font-size: 9pt; font-weight: bold;">=</td> <td style="text-align: left; font-size: 9pt; font-weight: bold;">FAV</td> <td style="text-align: left; font-size: 9pt; font-weight: bold;">N-FAV</td> <td style="text-align: left; font-size: 9pt; font-weight: bold;">DATE</td> <td style="text-align: left; font-size: 9pt; font-weight: bold;">WIN</td> <td style="text-align: left; font-size: 9pt; font-weight: bold;">LOSS</td> <td style="text-align: left; font-size: 9pt; font-weight: bold;">RND</td> <td style="text-align: left; font-size: 9pt; font-weight: bold;">TABLE</td> <td style="text-align: left; font-size: 9pt; font-weight: bold;">%CH</td> <td style="text-align: left; font-size: 9pt; font-weight: bold;">W/L</td> <td style="text-align: left; font-size: 9pt; font-weight: bold;">W/L 2</td> <td style="text-align: left; font-size: 9pt; font-weight: bold;">Last</td> <td style="text-align: left; font-size: 9pt; font-weight: bold;">Last</td> <td style="text-align: left; color: rgb(128, 0, 0); font-size: 9pt; font-weight: bold;">L$</td> <td style="text-align: left; color: rgb(0, 128, 0); font-size: 9pt; font-weight: bold;">W$</td> <td style="text-align: left; font-size: 9pt; font-weight: bold;">RES</td> <td style="text-align: left; font-size: 9pt; font-weight: bold;">F</td> <td style="text-align: left; font-size: 9pt; font-weight: bold;">A</td> <td style="text-align: left; font-size: 9pt; font-weight: bold;">W2</td> <td style="text-align: left; font-size: 9pt; font-weight: bold;">L2</td> <td style="text-align: left; font-size: 9pt; font-weight: bold;">N-FAV RES</td> <td style="text-align: left; font-size: 9pt; font-weight: bold;">CURRENT W/L</td> <td style="text-align: left; font-size: 9pt; font-weight: bold;">CURRENT W/L2</td></tr> <tr style="height: 15px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">2</td> <td style="text-align: center; font-size: 9pt;">h</td> <td style="text-align: left; font-size: 9pt;">gcoast</td> <td style="text-align: left; font-size: 9pt;">nqld</td> <td style="text-align: left; font-size: 9pt;">14/3/08</td> <td style="text-align: left; font-size: 9pt;">$1.62</td> <td style="text-align: left; font-size: 9pt;">$2.30</td> <td style="text-align: left; font-size: 9pt;">1</td> <td style="text-align: left; font-size: 9pt;">down</td> <td style="font-size: 9pt;">
</td> <td style="text-align: left; font-size: 9pt;">d00</td> <td style="text-align: left; font-size: 9pt;">d00</td> <td style="text-align: left; font-size: 9pt;">d00</td> <td style="text-align: left; font-size: 9pt;">d00</td> <td style="color: rgb(128, 0, 0); font-size: 9pt;">
</td> <td style="text-align: left; color: rgb(0, 128, 0); font-size: 9pt;">$1.62</td> <td style="text-align: left;">won</td> <td style="text-align: left; font-size: 9pt;">36</td> <td style="text-align: left; font-size: 9pt;">18</td> <td style="font-size: 9pt; font-weight: bold;">
</td> <td style="font-size: 9pt; font-weight: bold;">
</td> <td style="text-align: left; font-size: 9pt;">loss</td> <td style="text-align: left; font-family: Arial Unicode MS; font-size: 9pt;">w01</td> <td style="text-align: left; font-family: Arial Unicode MS; font-size: 9pt;">l01</td></tr> <tr style="height: 15px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">3</td> <td style="text-align: center; font-size: 9pt;">a</td> <td style="text-align: left; font-size: 9pt;">sydney</td> <td style="text-align: left; font-size: 9pt;">souths</td> <td style="text-align: left; font-size: 9pt;">14/3/08</td> <td style="text-align: left; font-size: 9pt;">$1.85</td> <td style="text-align: left; font-size: 9pt;">$1.95</td> <td style="text-align: left; font-size: 9pt;">1</td> <td style="text-align: left; font-size: 9pt;">down</td> <td style="font-size: 9pt;">
</td> <td style="text-align: left; font-size: 9pt;">d00</td> <td style="text-align: left; font-size: 9pt;">d00</td> <td style="text-align: left; font-size: 9pt;">d00</td> <td style="text-align: left; font-size: 9pt;">d00</td> <td style="color: rgb(128, 0, 0); font-size: 9pt;">
</td> <td style="text-align: left; color: rgb(0, 128, 0); font-size: 9pt;">$1.85</td> <td style="text-align: left;">won</td> <td style="text-align: left; font-size: 9pt;">34</td> <td style="text-align: left; font-size: 9pt;">20</td> <td style="font-size: 9pt; font-weight: bold;">
</td> <td style="font-size: 9pt; font-weight: bold;">
</td> <td style="text-align: left; font-size: 9pt;">loss</td> <td style="text-align: left; font-family: Arial Unicode MS; font-size: 9pt;">w01</td> <td style="text-align: left; font-family: Arial Unicode MS; font-size: 9pt;">l01</td></tr> <tr style="height: 15px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">4</td> <td style="text-align: center; font-size: 9pt;">h</td> <td style="text-align: left; font-size: 9pt;">manly</td> <td style="text-align: left; font-size: 9pt;">cronulla</td> <td style="text-align: left; font-size: 9pt;">15/3/08</td> <td style="text-align: left; font-size: 9pt;">$1.45</td> <td style="text-align: left; font-size: 9pt;">$2.75</td> <td style="text-align: left; font-size: 9pt;">1</td> <td style="text-align: left; font-size: 9pt;">up</td> <td style="font-size: 9pt;">
</td> <td style="text-align: left; font-size: 9pt;">d00</td> <td style="text-align: left; font-size: 9pt;">d00</td> <td style="text-align: left; font-size: 9pt;">d00</td> <td style="text-align: left; font-size: 9pt;">d00</td> <td style="text-align: left; color: rgb(128, 0, 0); font-size: 9pt;">$2.75</td> <td style="color: rgb(0, 128, 0); font-size: 9pt;">
</td> <td style="text-align: left;">loss</td> <td style="text-align: left; font-size: 9pt;">10</td> <td style="text-align: left; font-size: 9pt;">16</td> <td style="font-size: 9pt; font-weight: bold;">
</td> <td style="font-size: 9pt; font-weight: bold;">
</td> <td style="text-align: left; font-size: 9pt;">won</td> <td style="text-align: left; font-family: Arial Unicode MS; font-size: 9pt;">l01</td> <td style="text-align: left; font-family: Arial Unicode MS; font-size: 9pt;">w01</td></tr> <tr style="height: 15px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">5</td> <td style="text-align: center; font-size: 9pt;">h</td> <td style="text-align: left; font-size: 9pt;">newcastle</td> <td style="text-align: left; font-size: 9pt;">canberra</td> <td style="text-align: left; font-size: 9pt;">15/3/08</td> <td style="text-align: left; font-size: 9pt;">$1.55</td> <td style="text-align: left; font-size: 9pt;">$2.45</td> <td style="text-align: left; font-size: 9pt;">1</td> <td style="text-align: left; font-size: 9pt;">down</td> <td style="font-size: 9pt;">
</td> <td style="text-align: left; font-size: 9pt;">d00</td> <td style="text-align: left; font-size: 9pt;">d00</td> <td style="text-align: left; font-size: 9pt;">d00</td> <td style="text-align: left; font-size: 9pt;">d00</td> <td style="color: rgb(128, 0, 0); font-size: 9pt;">
</td> <td style="text-align: left; color: rgb(0, 128, 0); font-size: 9pt;">$1.55</td> <td style="text-align: left;">won</td> <td style="text-align: left; font-size: 9pt;">30</td> <td style="text-align: left; font-size: 9pt;">14</td> <td style="font-size: 9pt; font-weight: bold;">
</td> <td style="font-size: 9pt; font-weight: bold;">
</td> <td style="text-align: left; font-size: 9pt;">loss</td> <td style="text-align: left; font-family: Arial Unicode MS; font-size: 9pt;">w01</td> <td style="text-align: left; font-family: Arial Unicode MS; font-size: 9pt;">l01</td></tr> <tr style="height: 15px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">6</td> <td style="text-align: center; font-size: 9pt;">h</td> <td style="text-align: left; font-size: 9pt;">parramatta</td> <td style="text-align: left; font-size: 9pt;">canterbury</td> <td style="text-align: left; font-size: 9pt;">15/3/08</td> <td style="text-align: left; font-size: 9pt;">$1.48</td> <td style="text-align: left; font-size: 9pt;">$2.65</td> <td style="text-align: left; font-size: 9pt;">1</td> <td style="text-align: left; font-size: 9pt;">up</td> <td style="font-size: 9pt;">
</td> <td style="text-align: left; font-size: 9pt;">d00</td> <td style="text-align: left; font-size: 9pt;">d00</td> <td style="text-align: left; font-size: 9pt;">d00</td> <td style="text-align: left; font-size: 9pt;">d00</td> <td style="color: rgb(128, 0, 0); font-size: 9pt;">
</td> <td style="text-align: left; color: rgb(0, 128, 0); font-size: 9pt;">$1.48</td> <td style="text-align: left;">won</td> <td style="text-align: left; font-size: 9pt;">28</td> <td style="text-align: left; font-size: 9pt;">20</td> <td style="font-size: 9pt; font-weight: bold;">
</td> <td style="font-size: 9pt; font-weight: bold;">
</td> <td style="text-align: left; font-size: 9pt;">loss</td> <td style="text-align: left; font-family: Arial Unicode MS; font-size: 9pt;">w01</td> <td style="text-align: left; font-family: Arial Unicode MS; font-size: 9pt;">l01</td></tr> <tr style="height: 15px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">7</td> <td style="text-align: center; font-size: 9pt;">h</td> <td style="text-align: left; font-size: 9pt;">brisbane</td> <td style="text-align: left; font-size: 9pt;">penrith</td> <td style="text-align: left; font-size: 9pt;">16/3/08</td> <td style="text-align: left; font-size: 9pt;">$1.43</td> <td style="text-align: left; font-size: 9pt;">$2.85</td> <td style="text-align: left; font-size: 9pt;">1</td> <td style="text-align: left; font-size: 9pt;">up</td> <td style="font-size: 9pt;">
</td> <td style="text-align: left; font-size: 9pt;">d00</td> <td style="text-align: left; font-size: 9pt;">d00</td> <td style="text-align: left; font-size: 9pt;">d00</td> <td style="text-align: left; font-size: 9pt;">d00</td> <td style="color: rgb(128, 0, 0); font-size: 9pt;">
</td> <td style="text-align: left; color: rgb(0, 128, 0); font-size: 9pt;">$1.43</td> <td style="text-align: left;">won</td> <td style="text-align: left; font-size: 9pt;">48</td> <td style="text-align: left; font-size: 9pt;">12</td> <td style="font-size: 9pt; font-weight: bold;">
</td> <td style="font-size: 9pt; font-weight: bold;">
</td> <td style="text-align: left; font-size: 9pt;">loss</td> <td style="text-align: left; font-family: Arial Unicode MS; font-size: 9pt;">w01</td> <td style="text-align: left; font-family: Arial Unicode MS; font-size: 9pt;">l01</td></tr> <tr style="height: 15px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">8</td> <td style="text-align: center; font-size: 9pt;">a</td> <td style="text-align: left; font-size: 9pt;">sgeorge</td> <td style="text-align: left; font-size: 9pt;">wests</td> <td style="text-align: left; font-size: 9pt;">16/3/08</td> <td style="text-align: left; font-size: 9pt;">$1.75</td> <td style="text-align: left; font-size: 9pt;">$2.08</td> <td style="text-align: left; font-size: 9pt;">1</td> <td style="text-align: left; font-size: 9pt;">down</td> <td style="font-size: 9pt;">
</td> <td style="text-align: left; font-size: 9pt;">d00</td> <td style="text-align: left; font-size: 9pt;">d00</td> <td style="text-align: left; font-size: 9pt;">d00</td> <td style="text-align: left; font-size: 9pt;">d00</td> <td style="text-align: left; color: rgb(128, 0, 0); font-size: 9pt;">$1.00</td> <td style="text-align: left; color: rgb(0, 128, 0); font-size: 9pt;">$1.00</td> <td style="text-align: left;">draw</td> <td style="text-align: left; font-size: 9pt;">16</td> <td style="text-align: left; font-size: 9pt;">16</td> <td style="font-size: 9pt; font-weight: bold;">
</td> <td style="font-size: 9pt; font-weight: bold;">
</td> <td style="text-align: left; font-size: 9pt;">won</td> <td style="text-align: left; font-family: Arial Unicode MS; font-size: 9pt;">l01</td> <td style="text-align: left; font-family: Arial Unicode MS; font-size: 9pt;">w01</td></tr> <tr style="height: 15px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">9</td> <td style="text-align: center; font-size: 9pt;">h</td> <td style="text-align: left; font-size: 9pt;">melbourne</td> <td style="text-align: left; font-size: 9pt;">nzealand</td> <td style="text-align: left; font-size: 9pt;">17/3/08</td> <td style="text-align: left; font-size: 9pt;">$1.28</td> <td style="text-align: left; font-size: 9pt;">$3.70</td> <td style="text-align: left; font-size: 9pt;">1</td> <td style="text-align: left; font-size: 9pt;">up</td> <td style="font-size: 9pt;">
</td> <td style="text-align: left; font-size: 9pt;">d00</td> <td style="text-align: left; font-size: 9pt;">d00</td> <td style="text-align: left; font-size: 9pt;">d00</td> <td style="text-align: left; font-size: 9pt;">d00</td> <td style="color: rgb(128, 0, 0); font-size: 9pt;">
</td> <td style="text-align: left; color: rgb(0, 128, 0); font-size: 9pt;">$1.28</td> <td style="text-align: left;">won</td> <td style="text-align: left; font-size: 9pt;">32</td> <td style="text-align: left; font-size: 9pt;">18</td> <td style="font-size: 9pt; font-weight: bold;">
</td> <td style="font-size: 9pt; font-weight: bold;">
</td> <td style="text-align: left; font-size: 9pt;">loss</td> <td style="text-align: left; font-family: Arial Unicode MS; font-size: 9pt;">w01</td> <td style="text-align: left; font-family: Arial Unicode MS; font-size: 9pt;">l01</td></tr> <tr style="height: 15px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">10</td> <td style="text-align: center; font-size: 9pt;">a</td> <td style="text-align: left; font-size: 9pt;">canterbury</td> <td style="text-align: left; font-size: 9pt;">souths</td> <td style="text-align: left; font-size: 9pt;">21/3/08</td> <td style="text-align: left; font-size: 9pt;">$1.82</td> <td style="text-align: left; font-size: 9pt;">$2.00</td> <td style="text-align: left; font-size: 9pt;">2</td> <td style="text-align: left; font-size: 9pt;">up</td> <td style="font-size: 9pt;">
</td> <td style="text-align: left; font-size: 9pt;">l01</td> <td style="text-align: left; font-size: 9pt;">l01</td> <td style="text-align: left; font-size: 9pt;">l08</td> <td style="text-align: left; font-size: 9pt;">l14</td> <td style="color: rgb(128, 0, 0); font-size: 9pt;">
</td> <td style="text-align: left; color: rgb(0, 128, 0); font-size: 9pt;">$1.82</td> <td style="text-align: left;">won</td> <td style="text-align: left; font-size: 9pt;">25</td> <td style="text-align: left; font-size: 9pt;">12</td> <td style="font-size: 9pt; font-weight: bold;">
</td> <td style="font-size: 9pt; font-weight: bold;">
</td> <td style="text-align: left; font-size: 9pt;">loss</td> <td style="text-align: left; font-family: Arial Unicode MS; font-size: 9pt;">w01</td> <td style="text-align: left; font-family: Arial Unicode MS; font-size: 9pt;">l02</td></tr> <tr style="height: 15px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">11</td> <td style="text-align: center; font-size: 9pt;">h</td> <td style="text-align: left; font-size: 9pt;">sydney</td> <td style="text-align: left; font-size: 9pt;">brisbane</td> <td style="text-align: left; font-size: 9pt;">21/3/08</td> <td style="text-align: left; font-size: 9pt;">$1.68</td> <td style="text-align: left; font-size: 9pt;">$2.20</td> <td style="text-align: left; font-size: 9pt;">2</td> <td style="text-align: left; font-size: 9pt;">down</td> <td style="font-size: 9pt;">
</td> <td style="text-align: left; font-size: 9pt;">w01</td> <td style="text-align: left; font-size: 9pt;">w01</td> <td style="text-align: left; font-size: 9pt;">w14</td> <td style="text-align: left; font-size: 9pt;">w36</td> <td style="text-align: left; color: rgb(128, 0, 0); font-size: 9pt;">$2.20</td> <td style="color: rgb(0, 128, 0); font-size: 9pt;">
</td> <td style="text-align: left;">loss</td> <td style="text-align: left; font-size: 9pt;">14</td> <td style="text-align: left; font-size: 9pt;">20</td> <td style="font-size: 9pt; font-weight: bold;">
</td> <td style="font-size: 9pt; font-weight: bold;">
</td> <td style="text-align: left; font-size: 9pt;">won</td> <td style="text-align: left; font-family: Arial Unicode MS; font-size: 9pt;">l01</td> <td style="text-align: left; font-family: Arial Unicode MS; font-size: 9pt;">w02</td></tr> <tr style="height: 15px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">12</td> <td style="text-align: center; font-size: 9pt;">a</td> <td style="text-align: left; font-size: 9pt;">manly</td> <td style="text-align: left; font-size: 9pt;">newcastle</td> <td style="text-align: left; font-size: 9pt;">22/3/08</td> <td style="text-align: left; font-size: 9pt;">$1.60</td> <td style="text-align: left; font-size: 9pt;">$2.35</td> <td style="text-align: left; font-size: 9pt;">2</td> <td style="text-align: left; font-size: 9pt;">down</td> <td style="font-size: 9pt;">
</td> <td style="text-align: left; font-size: 9pt;">l01</td> <td style="text-align: left; font-size: 9pt;">w01</td> <td style="text-align: left; font-size: 9pt;">l06</td> <td style="text-align: left; font-size: 9pt;">w16</td> <td style="text-align: left; color: rgb(128, 0, 0); font-size: 9pt;">$2.35</td> <td style="color: rgb(0, 128, 0); font-size: 9pt;">
</td> <td style="text-align: left;">loss</td> <td style="text-align: left; font-size: 9pt;">12</td> <td style="text-align: left; font-size: 9pt;">13</td> <td style="font-size: 9pt; font-weight: bold;">
</td> <td style="font-size: 9pt; font-weight: bold;">
</td> <td style="text-align: left; font-size: 9pt;">won</td> <td style="text-align: left; font-family: Arial Unicode MS; font-size: 9pt;">l02</td> <td style="text-align: left; font-family: Arial Unicode MS; font-size: 9pt;">w02</td></tr> <tr style="height: 15px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">13</td> <td style="text-align: center; font-size: 9pt;">h</td> <td style="text-align: left; font-size: 9pt;">nqld</td> <td style="text-align: left; font-size: 9pt;">wests</td> <td style="text-align: left; font-size: 9pt;">22/3/08</td> <td style="text-align: left; font-size: 9pt;">$1.33</td> <td style="text-align: left; font-size: 9pt;">$3.35</td> <td style="text-align: left; font-size: 9pt;">2</td> <td style="text-align: left; font-size: 9pt;">down</td> <td style="font-size: 9pt;">
</td> <td style="text-align: left; font-size: 9pt;">l01</td> <td style="text-align: left; font-size: 9pt;">w01</td> <td style="text-align: left; font-size: 9pt;">l18</td> <td style="text-align: left; font-size: 9pt;">d16</td> <td style="text-align: left; color: rgb(128, 0, 0); font-size: 9pt;">$3.35</td> <td style="color: rgb(0, 128, 0); font-size: 9pt;">
</td> <td style="text-align: left;">loss</td> <td style="text-align: left; font-size: 9pt;">10</td> <td style="text-align: left; font-size: 9pt;">30</td> <td style="font-size: 9pt; font-weight: bold;">
</td> <td style="font-size: 9pt; font-weight: bold;">
</td> <td style="text-align: left; font-size: 9pt;">won</td> <td style="text-align: left; font-family: Arial Unicode MS; font-size: 9pt;">l02</td> <td style="text-align: left; font-family: Arial Unicode MS; font-size: 9pt;">w02</td></tr> <tr style="height: 15px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">14</td> <td style="text-align: center; font-size: 9pt;">h</td> <td style="text-align: left; font-size: 9pt;">penrith</td> <td style="text-align: left; font-size: 9pt;">canberra</td> <td style="text-align: left; font-size: 9pt;">22/3/08</td> <td style="text-align: left; font-size: 9pt;">$1.58</td> <td style="text-align: left; font-size: 9pt;">$2.40</td> <td style="text-align: left; font-size: 9pt;">2</td> <td style="text-align: left; font-size: 9pt;">down</td> <td style="font-size: 9pt;">
</td> <td style="text-align: left; font-size: 9pt;">l01</td> <td style="text-align: left; font-size: 9pt;">l01</td> <td style="text-align: left; font-size: 9pt;">l36</td> <td style="text-align: left; font-size: 9pt;">l16</td> <td style="text-align: left; color: rgb(128, 0, 0); font-size: 9pt;">$2.40</td> <td style="color: rgb(0, 128, 0); font-size: 9pt;">
</td> <td style="text-align: left;">loss</td> <td style="text-align: left; font-size: 9pt;">16</td> <td style="text-align: left; font-size: 9pt;">20</td> <td style="font-size: 9pt; font-weight: bold;">
</td> <td style="font-size: 9pt; font-weight: bold;">
</td> <td style="text-align: left; font-size: 9pt;">won</td> <td style="text-align: left; font-family: Arial Unicode MS; font-size: 9pt;">l02</td> <td style="text-align: left; font-family: Arial Unicode MS; font-size: 9pt;">w01</td></tr> <tr style="height: 15px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">15</td> <td style="text-align: center; font-size: 9pt;">h</td> <td style="text-align: left; font-size: 9pt;">melbourne</td> <td style="text-align: left; font-size: 9pt;">cronulla</td> <td style="text-align: left; font-size: 9pt;">23/3/08</td> <td style="text-align: left; font-size: 9pt;">$1.36</td> <td style="text-align: left; font-size: 9pt;">$3.20</td> <td style="text-align: left; font-size: 9pt;">2</td> <td style="text-align: left; font-size: 9pt;">up</td> <td style="font-size: 9pt;">
</td> <td style="text-align: left; font-size: 9pt;">w01</td> <td style="text-align: left; font-size: 9pt;">w01</td> <td style="text-align: left; font-size: 9pt;">w14</td> <td style="text-align: left; font-size: 9pt;">w06</td> <td style="text-align: left; color: rgb(128, 0, 0); font-size: 9pt;">$3.20</td> <td style="color: rgb(0, 128, 0); font-size: 9pt;">
</td> <td style="text-align: left;">loss</td> <td style="text-align: left; font-size: 9pt;">16</td> <td style="text-align: left; font-size: 9pt;">17</td> <td style="font-size: 9pt; font-weight: bold;">
</td> <td style="font-size: 9pt; font-weight: bold;">
</td> <td style="text-align: left; font-size: 9pt;">won</td> <td style="text-align: left; font-family: Arial Unicode MS; font-size: 9pt;">l01</td> <td style="text-align: left; font-family: Arial Unicode MS; font-size: 9pt;">w02</td></tr> <tr style="height: 15px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">16</td> <td style="text-align: center; font-size: 9pt;">a</td> <td style="text-align: left; font-size: 9pt;">parramatta</td> <td style="text-align: left; font-size: 9pt;">nzealand</td> <td style="text-align: left; font-size: 9pt;">23/3/08</td> <td style="text-align: left; font-size: 9pt;">$1.82</td> <td style="text-align: left; font-size: 9pt;">$2.00</td> <td style="text-align: left; font-size: 9pt;">2</td> <td style="text-align: left; font-size: 9pt;">up</td> <td style="font-size: 9pt;">
</td> <td style="text-align: left; font-size: 9pt;">w01</td> <td style="text-align: left; font-size: 9pt;">l01</td> <td style="text-align: left; font-size: 9pt;">w08</td> <td style="text-align: left; font-size: 9pt;">l14</td> <td style="text-align: left; color: rgb(128, 0, 0); font-size: 9pt;">$2.00</td> <td style="color: rgb(0, 128, 0); font-size: 9pt;">
</td> <td style="text-align: left;">loss</td> <td style="text-align: left; font-size: 9pt;">16</td> <td style="text-align: left; font-size: 9pt;">30</td> <td style="font-size: 9pt; font-weight: bold;">
</td> <td style="font-size: 9pt; font-weight: bold;">
</td> <td style="text-align: left; font-size: 9pt;">won</td> <td style="text-align: left; font-family: Arial Unicode MS; font-size: 9pt;">l01</td> <td style="text-align: left; font-family: Arial Unicode MS; font-size: 9pt;">w01</td></tr> <tr style="height: 15px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">17</td> <td style="text-align: center; font-size: 9pt;">h</td> <td style="text-align: left; font-size: 9pt;">sgeorge</td> <td style="text-align: left; font-size: 9pt;">gcoast</td> <td style="text-align: left; font-size: 9pt;">24/3/08</td> <td style="text-align: left; font-size: 9pt;">$1.65</td> <td style="text-align: left; font-size: 9pt;">$2.25</td> <td style="text-align: left; font-size: 9pt;">2</td> <td style="text-align: left; font-size: 9pt;">down</td> <td style="font-size: 9pt;">
</td> <td style="text-align: left; font-size: 9pt;">l01</td> <td style="text-align: left; font-size: 9pt;">w01</td> <td style="text-align: left; font-size: 9pt;">d16</td> <td style="text-align: left; font-size: 9pt;">w18</td> <td style="color: rgb(128, 0, 0); font-size: 9pt;">
</td> <td style="text-align: left; color: rgb(0, 128, 0); font-size: 9pt;">$1.65</td> <td style="text-align: left;">won</td> <td style="text-align: left; font-size: 9pt;">30</td> <td style="text-align: left; font-size: 9pt;">12</td> <td style="font-size: 9pt; font-weight: bold;">
</td> <td style="font-size: 9pt; font-weight: bold;">
</td> <td style="text-align: left; font-size: 9pt;">loss</td> <td style="text-align: left; font-family: Arial Unicode MS; font-size: 9pt;">w01</td> <td style="text-align: left; font-family: Arial Unicode MS; font-size: 9pt;">l01</td></tr></tbody></table>

 

[energman58]

OK here is teh formula for L17

=IF(SUMPRODUCT(MAX(($B$2:B16=B17)*ROW($B$2:B16)))>SUMPRODUCT(MAX(($C$2:C16=B17)*ROW($C$2:C16))),IF(INDEX($Q$1:Q17,SUMPRODUCT(MAX(($B$2:B16=B17)*ROW($B$2:B16))),1)>INDEX($Q$1:R17,SUMPRODUCT(MAX(($B$2:B16=B17)*ROW($B$2:B16))),2),"w"&INDEX($Q$1:Q17,SUMPRODUCT(MAX(($B$2:B16=B17)

*ROW($B$2:B16))),1)-INDEX($Q$1:R17,SUMPRODUCT(MAX(($B$2:B16=B17)*ROW($B$2:B16))),2),IF(INDEX($Q$1:Q17,SUMPRODUCT(MAX(($B$2:B16=B17)*ROW($B$2:B16))),1)<INDEX($Q$1:R17,SUMPRODUCT(MAX(($B$2:B16=B17)*ROW($B$2:B16))),2),"l"&(INDEX($Q$1:R17,SUMPRODUCT(MAX(($B$2:B16=B17)*ROW($B$2:B16))))-(INDEX($Q$1:R17,SUMPRODUCT(MAX(($B$2:B16=B17)

*ROW($B$2:B16))),1))),"d"&(INDEX($Q$1:R17,SUMPRODUCT(MAX(($B$2:B16=B17)*ROW($B$2:B16))),1)))),IF(INDEX($Q$1:R17,SUMPRODUCT(MAX(($C$2:C16=B17)*ROW($C$2:C16))),2)>INDEX($Q$1:R17,SUMPRODUCT(MAX(($C$2:C16=B17)*ROW($C$2:C16))),1),"w"&INDEX($Q$1:R17,SUMPRODUCT(MAX(($C$2:C16=B17)

*ROW($C$2:C16))),2)-INDEX($Q$1:R17,SUMPRODUCT(MAX(($C$2:C16=B17)*ROW($C$2:C16))),1),IF(INDEX($Q$1:R17,SUMPRODUCT(MAX(($C$2:C16=B17)*ROW($C$2:C16))),2)<INDEX($Q$1:R17,SUMPRODUCT(MAX(($C$2:C16=B17)*ROW($C$2:C16))),1),"l"&(INDEX($Q$1:R17,SUMPRODUCT(MAX(($C$2:C16=B17)*ROW($C$2:C16))),1)-(INDEX($Q$1:R17,SUMPRODUCT(MAX(($C$2:C16=B17)

*ROW($C$2:C16))),2))),"d"&(INDEX($Q$1:Q17,SUMPRODUCT(MAX(($C$2:C16=B17)*ROW($C$2:C16))),1)))))

and M18

=IF(SUMPRODUCT(MAX(($B$2:C16=C17)*ROW($B$2:C16)))>SUMPRODUCT(MAX(($B$2:C16=C17)*ROW($B$2:C16))),IF(INDEX($Q$1:R17,SUMPRODUCT(MAX(($B$2:C16=C17)*ROW($B$2:C16))),1)>INDEX($Q$1:R17,SUMPRODUCT(MAX(($B$2:C16=C17)*ROW($B$2:C16))),2),"w"&INDEX($Q$1:R17,SUMPRODUCT(MAX(($B$2:C16=C17)

*ROW($B$2:C16))),1)-INDEX($Q$1:R17,SUMPRODUCT(MAX(($B$2:C16=C17)*ROW($B$2:C16))),2),IF(INDEX($Q$1:R17,SUMPRODUCT(MAX(($B$2:C16=C17)*ROW($B$2:C16))),1)<INDEX($Q$1:R17,SUMPRODUCT(MAX(($B$2:C16=C17)*ROW($B$2:C16))),2),"l"&(INDEX($Q$1:R17,SUMPRODUCT(MAX(($B$2:C16=C17)*ROW($B$2:C16))))-(INDEX($Q$1:R17,SUMPRODUCT(MAX(($B$2:C16=C17)

*ROW($B$2:C16))),1))),"d"&(INDEX($Q$1:R17,SUMPRODUCT(MAX(($B$2:C16=C17)*ROW($B$2:C16))),1)))),IF(INDEX($Q$1:R17,SUMPRODUCT(MAX(($B$2:C16=C17)*ROW($B$2:C16))),2)>INDEX($Q$1:R17,SUMPRODUCT(MAX(($B$2:C16=C17)*ROW($B$2:C16))),1),"w"&INDEX($Q$1:R17,SUMPRODUCT(MAX(($B$2:C16=C17)

*ROW($B$2:C16))),2)-INDEX($Q$1:R17,SUMPRODUCT(MAX(($B$2:C16=C17)*ROW($B$2:C16))),1),IF(INDEX($Q$1:R17,SUMPRODUCT(MAX(($B$2:C16=C17)*ROW($B$2:C16))),2)<INDEX($Q$1:R17,SUMPRODUCT(MAX(($B$2:C16=C17)*ROW($B$2:C16))),1),"l"&(INDEX($Q$1:R17,SUMPRODUCT(MAX(($B$2:C16=C17)*ROW($B$2:C16))),1)-(INDEX($Q$1:R17,SUMPRODUCT(MAX(($B$2:C16=C17)

*ROW($B$2:C16))),2))),"d"&(INDEX($Q$1:R17,SUMPRODUCT(MAX(($B$2:C16=C17)*ROW($B$2:C16))),1)))))

I think it works properly now

 

[DonkeyOte]

[removed - misinterpreted requirements - will post revision shortly]

 

[DonkeyOte]

Apologies for earlier confusion - I misinterpreted the requirements.

I'm still unclear as to why you are pulling the points scored for a draw rather than the net (as per win / loss) and so I've persisted with the net in the below.

Note formula for L2 can be applied to L2:M17

Excel Workbook
	A	B	C	D	L	M	Q	R
1	=	FAV	N-FAV	DATE	Last	Last	F	A
2	h	gcoast	nqld	14/03/2008	d00	d00	36	18
3	a	sydney	souths	14/03/2008	d00	d00	34	20
4	h	manly	cronulla	15/03/2008	d00	d00	10	16
5	h	newcastle	canberra	15/03/2008	d00	d00	30	14
6	h	parramatta	canterbury	15/03/2008	d00	d00	28	20
7	h	brisbane	penrith	16/03/2008	d00	d00	48	12
8	a	sgeorge	wests	16/03/2008	d00	d00	16	16
9	h	melbourne	nzealand	17/03/2008	d00	d00	32	18
10	a	canterbury	souths	21/03/2008	l08	l14	25	12
11	h	sydney	brisbane	21/03/2008	w14	w36	14	20
12	a	manly	newcastle	22/03/2008	l06	w16	12	13
13	h	nqld	wests	22/03/2008	l18	d00	10	30
14	h	penrith	canberra	22/03/2008	l36	l16	16	20
15	h	melbourne	cronulla	23/03/2008	w14	w06	16	17
16	a	parramatta	nzealand	23/03/2008	w08	l14	16	30
17	h	sgeorge	gcoast	24/03/2008	d00	w18	30	12
18	h	gcoast	souths	31/03/2011	l18	l13
Sheet5

The above also assumes a Custom Format applied to L2:M17 of: "w"00;"l"00;"d"00

 

[bluegold]

energman58, I keep getting syntax error when copy & paste formula, cursor flashes between two of the parenthesis?

 

[bluegold]

Is it possible to make a draw "d00" and "nd00" (no data) if it can't find previous results, just so I can differentiate between the two?

 

[DonkeyOte]

How would it look for column M with the non-favorite team's, what do I modify?

You don't need to modify anything - simply copy & paste

 

[bluegold]

Sorry, I edited as I realized I missed the part about copying over to M17.
As I edited in my previous post is it possible to differentiate between a draw and not having previous data to post result?

 

[DonkeyOte]

I'd be inclined to add a pre-emptive COUNTIF

L2:
=IF(COUNTIF($B$1:$C1,B2)=0,"",(ROUND(MOD(MAX(IF($B$1:$C1=B2,ROW($B$1:$B1)+$Q$1:$R1/1000)),1)*1000,0)-ROUND(MOD(MAX(IF($B$1:$C1=B2,IF($Q$1:$Q1<>$R$1:$R1,ROW($B$1:$B1)+IF($B$1:$B1=B2,$R$1:$R1,$Q$1:$Q1)/1000))),1)*1000,0))/MAX(IF($B$1:$C1=B2,IF($Q$1:$Q1=$R$1:$R1,24,1),1)))
confirmed with CTRL + SHIFT + ENTER

You can modify the Null String output to whatever you want but bear in mind the other values are numeric and you're already using all 3 numeric elements in your custom number format.

(the pre-emptive COUNTIF also prevents the Array from calculating unnecessarily)

 

[bluegold]

Yeah as you can see the draw's don't display correctly, can this be modified with number format?

<table style="background-color: rgb(255, 255, 255); padding-left: 2pt; padding-right: 2pt; font-family: Arial,Arial; font-size: 10pt;" border="1" cellpadding="0" cellspacing="0"> <colgroup> <col style="width: 30px; font-weight: bold;"> <col style="width: 14px;"> <col style="width: 73px;"> <col style="width: 73px;"> <col style="width: 48px;"> <col style="width: 38px;"> <col style="width: 45px;"> <col style="width: 31px;"> <col style="width: 44px;"> <col style="width: 46px;"> <col style="width: 39px;"> <col style="width: 39px;"> <col style="width: 32px;"> <col style="width: 32px;"> <col style="width: 45px;"> <col style="width: 38px;"> <col style="width: 33px;"> <col style="width: 28px;"> <col style="width: 28px;"> <col style="width: 45px;"> <col style="width: 45px;"> <col style="width: 67px;"> <col style="width: 86px;"> <col style="width: 94px;"></colgroup> <tbody> <tr style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt; font-weight: bold;"> <td>
</td> <td>A</td> <td>B</td> <td>C</td> <td>D</td> <td>E</td> <td>F</td> <td>G</td> <td>H</td> <td>I</td> <td>J</td> <td>K</td> <td>L</td> <td>M</td> <td>N</td> <td>O</td> <td>P</td> <td>Q</td> <td>R</td> <td>S</td> <td>T</td> <td>U</td> <td>V</td> <td>W</td></tr> <tr style="height: 15px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">1</td> <td style="text-align: left; font-size: 9pt; font-weight: bold;">=</td> <td style="text-align: left; font-size: 9pt; font-weight: bold;">FAV</td> <td style="text-align: left; font-size: 9pt; font-weight: bold;">N-FAV</td> <td style="text-align: left; font-size: 9pt; font-weight: bold;">DATE</td> <td style="text-align: left; font-size: 9pt; font-weight: bold;">WIN</td> <td style="text-align: left; font-size: 9pt; font-weight: bold;">LOSS</td> <td style="text-align: left; font-size: 9pt; font-weight: bold;">RND</td> <td style="text-align: left; font-size: 9pt; font-weight: bold;">TABLE</td> <td style="text-align: left; font-size: 9pt; font-weight: bold;">%CH</td> <td style="text-align: left; font-size: 9pt; font-weight: bold;">W/L</td> <td style="text-align: left; font-size: 9pt; font-weight: bold;">W/L 2</td> <td style="text-align: left; font-size: 9pt; font-weight: bold;">Last</td> <td style="text-align: left; font-size: 9pt; font-weight: bold;">Last</td> <td style="text-align: left; color: rgb(128, 0, 0); font-size: 9pt; font-weight: bold;">L$</td> <td style="text-align: left; color: rgb(0, 128, 0); font-size: 9pt; font-weight: bold;">W$</td> <td style="text-align: left; font-size: 9pt; font-weight: bold;">RES</td> <td style="text-align: left; font-size: 9pt; font-weight: bold;">F</td> <td style="text-align: left; font-size: 9pt; font-weight: bold;">A</td> <td style="text-align: left; font-size: 9pt; font-weight: bold;">W2</td> <td style="text-align: left; font-size: 9pt; font-weight: bold;">L2</td> <td style="text-align: left; font-size: 9pt; font-weight: bold;">N-FAV RES</td> <td style="text-align: left; font-size: 9pt; font-weight: bold;">CURRENT W/L</td> <td style="text-align: left; font-size: 9pt; font-weight: bold;">CURRENT W/L2</td></tr> <tr style="height: 15px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">2</td> <td style="text-align: center; font-size: 9pt;">h</td> <td style="text-align: left; font-size: 9pt;">gcoast</td> <td style="text-align: left; font-size: 9pt;">nqld</td> <td style="text-align: left; font-size: 9pt;">14/3/08</td> <td style="text-align: left; font-size: 9pt;">$1.62</td> <td style="text-align: left; font-size: 9pt;">$2.30</td> <td style="text-align: left; font-size: 9pt;">1</td> <td style="text-align: left; font-size: 9pt;">down</td> <td style="font-size: 9pt;">
</td> <td style="text-align: left; font-size: 9pt;">nd00</td> <td style="text-align: left; font-size: 9pt;">nd00</td> <td style="font-size: 9pt;">
</td> <td style="font-size: 9pt;">
</td> <td style="color: rgb(128, 0, 0); font-size: 9pt;">
</td> <td style="text-align: left; color: rgb(0, 128, 0); font-size: 9pt;">$1.62</td> <td style="text-align: left;">won</td> <td style="text-align: left; font-size: 9pt;">36</td> <td style="text-align: left; font-size: 9pt;">18</td> <td style="font-size: 9pt; font-weight: bold;">
</td> <td style="font-size: 9pt; font-weight: bold;">
</td> <td style="text-align: left; font-size: 9pt;">loss</td> <td style="text-align: left; font-family: Arial Unicode MS; font-size: 9pt;">w01</td> <td style="text-align: left; font-family: Arial Unicode MS; font-size: 9pt;">l01</td></tr> <tr style="height: 15px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">3</td> <td style="text-align: center; font-size: 9pt;">a</td> <td style="text-align: left; font-size: 9pt;">sydney</td> <td style="text-align: left; font-size: 9pt;">souths</td> <td style="text-align: left; font-size: 9pt;">14/3/08</td> <td style="text-align: left; font-size: 9pt;">$1.85</td> <td style="text-align: left; font-size: 9pt;">$1.95</td> <td style="text-align: left; font-size: 9pt;">1</td> <td style="text-align: left; font-size: 9pt;">down</td> <td style="font-size: 9pt;">
</td> <td style="text-align: left; font-size: 9pt;">d00</td> <td style="text-align: left; font-size: 9pt;">d00</td> <td style="font-size: 9pt;">
</td> <td style="font-size: 9pt;">
</td> <td style="color: rgb(128, 0, 0); font-size: 9pt;">
</td> <td style="text-align: left; color: rgb(0, 128, 0); font-size: 9pt;">$1.85</td> <td style="text-align: left;">won</td> <td style="text-align: left; font-size: 9pt;">34</td> <td style="text-align: left; font-size: 9pt;">20</td> <td style="font-size: 9pt; font-weight: bold;">
</td> <td style="font-size: 9pt; font-weight: bold;">
</td> <td style="text-align: left; font-size: 9pt;">loss</td> <td style="text-align: left; font-family: Arial Unicode MS; font-size: 9pt;">w01</td> <td style="text-align: left; font-family: Arial Unicode MS; font-size: 9pt;">l01</td></tr> <tr style="height: 15px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">4</td> <td style="text-align: center; font-size: 9pt;">h</td> <td style="text-align: left; font-size: 9pt;">manly</td> <td style="text-align: left; font-size: 9pt;">cronulla</td> <td style="text-align: left; font-size: 9pt;">15/3/08</td> <td style="text-align: left; font-size: 9pt;">$1.45</td> <td style="text-align: left; font-size: 9pt;">$2.75</td> <td style="text-align: left; font-size: 9pt;">1</td> <td style="text-align: left; font-size: 9pt;">up</td> <td style="font-size: 9pt;">
</td> <td style="text-align: left; font-size: 9pt;">d00</td> <td style="text-align: left; font-size: 9pt;">d00</td> <td style="font-size: 9pt;">
</td> <td style="font-size: 9pt;">
</td> <td style="text-align: left; color: rgb(128, 0, 0); font-size: 9pt;">$2.75</td> <td style="color: rgb(0, 128, 0); font-size: 9pt;">
</td> <td style="text-align: left;">loss</td> <td style="text-align: left; font-size: 9pt;">10</td> <td style="text-align: left; font-size: 9pt;">16</td> <td style="font-size: 9pt; font-weight: bold;">
</td> <td style="font-size: 9pt; font-weight: bold;">
</td> <td style="text-align: left; font-size: 9pt;">won</td> <td style="text-align: left; font-family: Arial Unicode MS; font-size: 9pt;">l01</td> <td style="text-align: left; font-family: Arial Unicode MS; font-size: 9pt;">w01</td></tr> <tr style="height: 15px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">5</td> <td style="text-align: center; font-size: 9pt;">h</td> <td style="text-align: left; font-size: 9pt;">newcastle</td> <td style="text-align: left; font-size: 9pt;">canberra</td> <td style="text-align: left; font-size: 9pt;">15/3/08</td> <td style="text-align: left; font-size: 9pt;">$1.55</td> <td style="text-align: left; font-size: 9pt;">$2.45</td> <td style="text-align: left; font-size: 9pt;">1</td> <td style="text-align: left; font-size: 9pt;">down</td> <td style="font-size: 9pt;">
</td> <td style="text-align: left; font-size: 9pt;">d00</td> <td style="text-align: left; font-size: 9pt;">d00</td> <td style="font-size: 9pt;">
</td> <td style="font-size: 9pt;">
</td> <td style="color: rgb(128, 0, 0); font-size: 9pt;">
</td> <td style="text-align: left; color: rgb(0, 128, 0); font-size: 9pt;">$1.55</td> <td style="text-align: left;">won</td> <td style="text-align: left; font-size: 9pt;">30</td> <td style="text-align: left; font-size: 9pt;">14</td> <td style="font-size: 9pt; font-weight: bold;">
</td> <td style="font-size: 9pt; font-weight: bold;">
</td> <td style="text-align: left; font-size: 9pt;">loss</td> <td style="text-align: left; font-family: Arial Unicode MS; font-size: 9pt;">w01</td> <td style="text-align: left; font-family: Arial Unicode MS; font-size: 9pt;">l01</td></tr> <tr style="height: 15px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">6</td> <td style="text-align: center; font-size: 9pt;">h</td> <td style="text-align: left; font-size: 9pt;">parramatta</td> <td style="text-align: left; font-size: 9pt;">canterbury</td> <td style="text-align: left; font-size: 9pt;">15/3/08</td> <td style="text-align: left; font-size: 9pt;">$1.48</td> <td style="text-align: left; font-size: 9pt;">$2.65</td> <td style="text-align: left; font-size: 9pt;">1</td> <td style="text-align: left; font-size: 9pt;">up</td> <td style="font-size: 9pt;">
</td> <td style="text-align: left; font-size: 9pt;">d00</td> <td style="text-align: left; font-size: 9pt;">d00</td> <td style="font-size: 9pt;">
</td> <td style="font-size: 9pt;">
</td> <td style="color: rgb(128, 0, 0); font-size: 9pt;">
</td> <td style="text-align: left; color: rgb(0, 128, 0); font-size: 9pt;">$1.48</td> <td style="text-align: left;">won</td> <td style="text-align: left; font-size: 9pt;">28</td> <td style="text-align: left; font-size: 9pt;">20</td> <td style="font-size: 9pt; font-weight: bold;">
</td> <td style="font-size: 9pt; font-weight: bold;">
</td> <td style="text-align: left; font-size: 9pt;">loss</td> <td style="text-align: left; font-family: Arial Unicode MS; font-size: 9pt;">w01</td> <td style="text-align: left; font-family: Arial Unicode MS; font-size: 9pt;">l01</td></tr> <tr style="height: 15px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">7</td> <td style="text-align: center; font-size: 9pt;">h</td> <td style="text-align: left; font-size: 9pt;">brisbane</td> <td style="text-align: left; font-size: 9pt;">penrith</td> <td style="text-align: left; font-size: 9pt;">16/3/08</td> <td style="text-align: left; font-size: 9pt;">$1.43</td> <td style="text-align: left; font-size: 9pt;">$2.85</td> <td style="text-align: left; font-size: 9pt;">1</td> <td style="text-align: left; font-size: 9pt;">up</td> <td style="font-size: 9pt;">
</td> <td style="text-align: left; font-size: 9pt;">d00</td> <td style="text-align: left; font-size: 9pt;">d00</td> <td style="font-size: 9pt;">
</td> <td style="font-size: 9pt;">
</td> <td style="color: rgb(128, 0, 0); font-size: 9pt;">
</td> <td style="text-align: left; color: rgb(0, 128, 0); font-size: 9pt;">$1.43</td> <td style="text-align: left;">won</td> <td style="text-align: left; font-size: 9pt;">48</td> <td style="text-align: left; font-size: 9pt;">12</td> <td style="font-size: 9pt; font-weight: bold;">
</td> <td style="font-size: 9pt; font-weight: bold;">
</td> <td style="text-align: left; font-size: 9pt;">loss</td> <td style="text-align: left; font-family: Arial Unicode MS; font-size: 9pt;">w01</td> <td style="text-align: left; font-family: Arial Unicode MS; font-size: 9pt;">l01</td></tr> <tr style="height: 15px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">8</td> <td style="text-align: center; font-size: 9pt;">a</td> <td style="text-align: left; font-size: 9pt;">sgeorge</td> <td style="text-align: left; font-size: 9pt;">wests</td> <td style="text-align: left; font-size: 9pt;">16/3/08</td> <td style="text-align: left; font-size: 9pt;">$1.75</td> <td style="text-align: left; font-size: 9pt;">$2.08</td> <td style="text-align: left; font-size: 9pt;">1</td> <td style="text-align: left; font-size: 9pt;">down</td> <td style="font-size: 9pt;">
</td> <td style="text-align: left; font-size: 9pt;">d00</td> <td style="text-align: left; font-size: 9pt;">d00</td> <td style="font-size: 9pt;">
</td> <td style="font-size: 9pt;">
</td> <td style="text-align: left; color: rgb(128, 0, 0); font-size: 9pt;">$1.00</td> <td style="text-align: left; color: rgb(0, 128, 0); font-size: 9pt;">$1.00</td> <td style="text-align: left;">draw</td> <td style="text-align: left; font-size: 9pt;">16</td> <td style="text-align: left; font-size: 9pt;">16</td> <td style="font-size: 9pt; font-weight: bold;">
</td> <td style="font-size: 9pt; font-weight: bold;">
</td> <td style="text-align: left; font-size: 9pt;">draw</td> <td style="text-align: left; font-family: Arial Unicode MS; font-size: 9pt;">d01</td> <td style="text-align: left; font-family: Arial Unicode MS; font-size: 9pt;">d01</td></tr> <tr style="height: 15px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">9</td> <td style="text-align: center; font-size: 9pt;">h</td> <td style="text-align: left; font-size: 9pt;">melbourne</td> <td style="text-align: left; font-size: 9pt;">nzealand</td> <td style="text-align: left; font-size: 9pt;">17/3/08</td> <td style="text-align: left; font-size: 9pt;">$1.28</td> <td style="text-align: left; font-size: 9pt;">$3.70</td> <td style="text-align: left; font-size: 9pt;">1</td> <td style="text-align: left; font-size: 9pt;">up</td> <td style="font-size: 9pt;">
</td> <td style="text-align: left; font-size: 9pt;">d00</td> <td style="text-align: left; font-size: 9pt;">d00</td> <td style="font-size: 9pt;">
</td> <td style="font-size: 9pt;">
</td> <td style="color: rgb(128, 0, 0); font-size: 9pt;">
</td> <td style="text-align: left; color: rgb(0, 128, 0); font-size: 9pt;">$1.28</td> <td style="text-align: left;">won</td> <td style="text-align: left; font-size: 9pt;">32</td> <td style="text-align: left; font-size: 9pt;">18</td> <td style="font-size: 9pt; font-weight: bold;">
</td> <td style="font-size: 9pt; font-weight: bold;">
</td> <td style="text-align: left; font-size: 9pt;">loss</td> <td style="text-align: left; font-family: Arial Unicode MS; font-size: 9pt;">w01</td> <td style="text-align: left; font-family: Arial Unicode MS; font-size: 9pt;">l01</td></tr> <tr style="height: 15px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">10</td> <td style="text-align: center; font-size: 9pt;">a</td> <td style="text-align: left; font-size: 9pt;">canterbury</td> <td style="text-align: left; font-size: 9pt;">souths</td> <td style="text-align: left; font-size: 9pt;">21/3/08</td> <td style="text-align: left; font-size: 9pt;">$1.82</td> <td style="text-align: left; font-size: 9pt;">$2.00</td> <td style="text-align: left; font-size: 9pt;">2</td> <td style="text-align: left; font-size: 9pt;">up</td> <td style="font-size: 9pt;">
</td> <td style="text-align: left; font-size: 9pt;">l01</td> <td style="text-align: left; font-size: 9pt;">l01</td> <td style="text-align: left; font-size: 9pt;">l08</td> <td style="text-align: left; font-size: 9pt;">l14</td> <td style="color: rgb(128, 0, 0); font-size: 9pt;">
</td> <td style="text-align: left; color: rgb(0, 128, 0); font-size: 9pt;">$1.82</td> <td style="text-align: left;">won</td> <td style="text-align: left; font-size: 9pt;">25</td> <td style="text-align: left; font-size: 9pt;">12</td> <td style="font-size: 9pt; font-weight: bold;">
</td> <td style="font-size: 9pt; font-weight: bold;">
</td> <td style="text-align: left; font-size: 9pt;">loss</td> <td style="text-align: left; font-family: Arial Unicode MS; font-size: 9pt;">w01</td> <td style="text-align: left; font-family: Arial Unicode MS; font-size: 9pt;">l02</td></tr> <tr style="height: 15px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">11</td> <td style="text-align: center; font-size: 9pt;">h</td> <td style="text-align: left; font-size: 9pt;">sydney</td> <td style="text-align: left; font-size: 9pt;">brisbane</td> <td style="text-align: left; font-size: 9pt;">21/3/08</td> <td style="text-align: left; font-size: 9pt;">$1.68</td> <td style="text-align: left; font-size: 9pt;">$2.20</td> <td style="text-align: left; font-size: 9pt;">2</td> <td style="text-align: left; font-size: 9pt;">down</td> <td style="font-size: 9pt;">
</td> <td style="text-align: left; font-size: 9pt;">w01</td> <td style="text-align: left; font-size: 9pt;">w01</td> <td style="text-align: left; font-size: 9pt;">w14</td> <td style="text-align: left; font-size: 9pt;">w36</td> <td style="text-align: left; color: rgb(128, 0, 0); font-size: 9pt;">$2.20</td> <td style="color: rgb(0, 128, 0); font-size: 9pt;">
</td> <td style="text-align: left;">loss</td> <td style="text-align: left; font-size: 9pt;">14</td> <td style="text-align: left; font-size: 9pt;">20</td> <td style="font-size: 9pt; font-weight: bold;">
</td> <td style="font-size: 9pt; font-weight: bold;">
</td> <td style="text-align: left; font-size: 9pt;">won</td> <td style="text-align: left; font-family: Arial Unicode MS; font-size: 9pt;">l01</td> <td style="text-align: left; font-family: Arial Unicode MS; font-size: 9pt;">w02</td></tr> <tr style="height: 15px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">12</td> <td style="text-align: center; font-size: 9pt;">a</td> <td style="text-align: left; font-size: 9pt;">manly</td> <td style="text-align: left; font-size: 9pt;">newcastle</td> <td style="text-align: left; font-size: 9pt;">22/3/08</td> <td style="text-align: left; font-size: 9pt;">$1.60</td> <td style="text-align: left; font-size: 9pt;">$2.35</td> <td style="text-align: left; font-size: 9pt;">2</td> <td style="text-align: left; font-size: 9pt;">down</td> <td style="font-size: 9pt;">
</td> <td style="text-align: left; font-size: 9pt;">l01</td> <td style="text-align: left; font-size: 9pt;">w01</td> <td style="text-align: left; font-size: 9pt;">l06</td> <td style="text-align: left; font-size: 9pt;">w16</td> <td style="text-align: left; color: rgb(128, 0, 0); font-size: 9pt;">$2.35</td> <td style="color: rgb(0, 128, 0); font-size: 9pt;">
</td> <td style="text-align: left;">loss</td> <td style="text-align: left; font-size: 9pt;">12</td> <td style="text-align: left; font-size: 9pt;">13</td> <td style="font-size: 9pt; font-weight: bold;">
</td> <td style="font-size: 9pt; font-weight: bold;">
</td> <td style="text-align: left; font-size: 9pt;">won</td> <td style="text-align: left; font-family: Arial Unicode MS; font-size: 9pt;">l02</td> <td style="text-align: left; font-family: Arial Unicode MS; font-size: 9pt;">w02</td></tr> <tr style="height: 15px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">13</td> <td style="text-align: center; font-size: 9pt;">h</td> <td style="text-align: left; font-size: 9pt;">nqld</td> <td style="text-align: left; font-size: 9pt;">wests</td> <td style="text-align: left; font-size: 9pt;">22/3/08</td> <td style="text-align: left; font-size: 9pt;">$1.33</td> <td style="text-align: left; font-size: 9pt;">$3.35</td> <td style="text-align: left; font-size: 9pt;">2</td> <td style="text-align: left; font-size: 9pt;">down</td> <td style="font-size: 9pt;">
</td> <td style="text-align: left; font-size: 9pt;">l01</td> <td style="text-align: left; font-size: 9pt;">d01</td> <td style="text-align: left; font-size: 9pt;">l18</td> <td style="text-align: left; font-size: 9pt;">w01</td> <td style="text-align: left; color: rgb(128, 0, 0); font-size: 9pt;">$3.35</td> <td style="color: rgb(0, 128, 0); font-size: 9pt;">
</td> <td style="text-align: left;">loss</td> <td style="text-align: left; font-size: 9pt;">10</td> <td style="text-align: left; font-size: 9pt;">30</td> <td style="font-size: 9pt; font-weight: bold;">
</td> <td style="font-size: 9pt; font-weight: bold;">
</td> <td style="text-align: left; font-size: 9pt;">won</td> <td style="text-align: left; font-family: Arial Unicode MS; font-size: 9pt;">l02</td> <td style="text-align: left; font-family: Arial Unicode MS; font-size: 9pt;">w01</td></tr> <tr style="height: 15px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">14</td> <td style="text-align: center; font-size: 9pt;">h</td> <td style="text-align: left; font-size: 9pt;">penrith</td> <td style="text-align: left; font-size: 9pt;">canberra</td> <td style="text-align: left; font-size: 9pt;">22/3/08</td> <td style="text-align: left; font-size: 9pt;">$1.58</td> <td style="text-align: left; font-size: 9pt;">$2.40</td> <td style="text-align: left; font-size: 9pt;">2</td> <td style="text-align: left; font-size: 9pt;">down</td> <td style="font-size: 9pt;">
</td> <td style="text-align: left; font-size: 9pt;">l01</td> <td style="text-align: left; font-size: 9pt;">l01</td> <td style="text-align: left; font-size: 9pt;">l36</td> <td style="text-align: left; font-size: 9pt;">l16</td> <td style="text-align: left; color: rgb(128, 0, 0); font-size: 9pt;">$2.40</td> <td style="color: rgb(0, 128, 0); font-size: 9pt;">
</td> <td style="text-align: left;">loss</td> <td style="text-align: left; font-size: 9pt;">16</td> <td style="text-align: left; font-size: 9pt;">20</td> <td style="font-size: 9pt; font-weight: bold;">
</td> <td style="font-size: 9pt; font-weight: bold;">
</td> <td style="text-align: left; font-size: 9pt;">won</td> <td style="text-align: left; font-family: Arial Unicode MS; font-size: 9pt;">l02</td> <td style="text-align: left; font-family: Arial Unicode MS; font-size: 9pt;">w01</td></tr> <tr style="height: 15px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">15</td> <td style="text-align: center; font-size: 9pt;">h</td> <td style="text-align: left; font-size: 9pt;">melbourne</td> <td style="text-align: left; font-size: 9pt;">cronulla</td> <td style="text-align: left; font-size: 9pt;">23/3/08</td> <td style="text-align: left; font-size: 9pt;">$1.36</td> <td style="text-align: left; font-size: 9pt;">$3.20</td> <td style="text-align: left; font-size: 9pt;">2</td> <td style="text-align: left; font-size: 9pt;">up</td> <td style="font-size: 9pt;">
</td> <td style="text-align: left; font-size: 9pt;">w01</td> <td style="text-align: left; font-size: 9pt;">w01</td> <td style="text-align: left; font-size: 9pt;">w14</td> <td style="text-align: left; font-size: 9pt;">w06</td> <td style="text-align: left; color: rgb(128, 0, 0); font-size: 9pt;">$3.20</td> <td style="color: rgb(0, 128, 0); font-size: 9pt;">
</td> <td style="text-align: left;">loss</td> <td style="text-align: left; font-size: 9pt;">16</td> <td style="text-align: left; font-size: 9pt;">17</td> <td style="font-size: 9pt; font-weight: bold;">
</td> <td style="font-size: 9pt; font-weight: bold;">
</td> <td style="text-align: left; font-size: 9pt;">won</td> <td style="text-align: left; font-family: Arial Unicode MS; font-size: 9pt;">l01</td> <td style="text-align: left; font-family: Arial Unicode MS; font-size: 9pt;">w02</td></tr> <tr style="height: 15px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">16</td> <td style="text-align: center; font-size: 9pt;">a</td> <td style="text-align: left; font-size: 9pt;">parramatta</td> <td style="text-align: left; font-size: 9pt;">nzealand</td> <td style="text-align: left; font-size: 9pt;">23/3/08</td> <td style="text-align: left; font-size: 9pt;">$1.82</td> <td style="text-align: left; font-size: 9pt;">$2.00</td> <td style="text-align: left; font-size: 9pt;">2</td> <td style="text-align: left; font-size: 9pt;">up</td> <td style="font-size: 9pt;">
</td> <td style="text-align: left; font-size: 9pt;">w01</td> <td style="text-align: left; font-size: 9pt;">l01</td> <td style="text-align: left; font-size: 9pt;">w08</td> <td style="text-align: left; font-size: 9pt;">l14</td> <td style="text-align: left; color: rgb(128, 0, 0); font-size: 9pt;">$2.00</td> <td style="color: rgb(0, 128, 0); font-size: 9pt;">
</td> <td style="text-align: left;">loss</td> <td style="text-align: left; font-size: 9pt;">16</td> <td style="text-align: left; font-size: 9pt;">30</td> <td style="font-size: 9pt; font-weight: bold;">
</td> <td style="font-size: 9pt; font-weight: bold;">
</td> <td style="text-align: left; font-size: 9pt;">won</td> <td style="text-align: left; font-family: Arial Unicode MS; font-size: 9pt;">l01</td> <td style="text-align: left; font-family: Arial Unicode MS; font-size: 9pt;">w01</td></tr> <tr style="height: 15px;"> <td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">17</td> <td style="text-align: center; font-size: 9pt;">h</td> <td style="text-align: left; font-size: 9pt;">sgeorge</td> <td style="text-align: left; font-size: 9pt;">gcoast</td> <td style="text-align: left; font-size: 9pt;">24/3/08</td> <td style="text-align: left; font-size: 9pt;">$1.65</td> <td style="text-align: left; font-size: 9pt;">$2.25</td> <td style="text-align: left; font-size: 9pt;">2</td> <td style="text-align: left; font-size: 9pt;">down</td> <td style="font-size: 9pt;">
</td> <td style="text-align: left; font-size: 9pt;">d01</td> <td style="text-align: left; font-size: 9pt;">w01</td> <td style="text-align: left; font-size: 9pt;">w01</td> <td style="text-align: left; font-size: 9pt;">w18</td> <td style="color: rgb(128, 0, 0); font-size: 9pt;">
</td> <td style="text-align: left; color: rgb(0, 128, 0); font-size: 9pt;">$1.65</td> <td style="text-align: left;">won</td> <td style="text-align: left; font-size: 9pt;">30</td> <td style="text-align: left; font-size: 9pt;">12</td> <td style="font-size: 9pt; font-weight: bold;">
</td> <td style="font-size: 9pt; font-weight: bold;">
</td> <td style="text-align: left; font-size: 9pt;">loss</td></tr></tbody></table>

 

[DonkeyOte]

as you can see the draw's don't display correctly

you can modify the Null String output to whatever you want

If you want to show "nd00" change the Null String "" to "nd00"

can this be modified with number format?

I would advise against storing "no prior results" as a numeric value for those reasons previously outlined.