Return Top cell in group of cells

[rossn13]

Hi there experts!

I have a list of football fixtures, example below (Had to remove team names due to some stupid rule preventing fixtures from being posted in forums).

What I want is for the date at the top of each group to appear in the cells to the right of each fixture.
The data is auto updated from an external source. They are also subject to change. So the size of groups, and position of fixtures will change. I need everything to adjust automatically.

Any ideas how I would go about this?

Cheers in advance



Table:

<table border="0" cellpadding="0" cellspacing="0" width="237"><colgroup><col style="mso-width-source:userset;mso-width-alt:8667;width:178pt" width="237"> </colgroup><tbody><tr style="height:15.0pt" height="20"> <td class="xl65" style="height:15.0pt;width:178pt" height="20" width="237">Saturday, 13 August 2011</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl65" style="height:15.0pt" height="20">HOME v AWAY, 15:00</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl65" style="height:15.0pt" height="20">HOME v AWAY, 15:00</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl65" style="height:15.0pt" height="20">HOME v AWAY, 15:00</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl65" style="height:15.0pt" height="20">HOME v AWAY, 15:00</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl65" style="height:15.0pt" height="20">HOME v AWAY, 15:00</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl65" style="height:15.0pt" height="20">HOME v AWAY, 15:00</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl65" style="height:15.0pt" height="20">HOME v AWAY, 17:30</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl65" style="height:15.0pt" height="20">
</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl65" style="height:15.0pt" height="20">Sunday, 14 August 2011</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl65" style="height:15.0pt" height="20">HOME v AWAY, 13:30</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl65" style="height:15.0pt" height="20">HOME v AWAY, 16:00</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl65" style="height:15.0pt" height="20">
</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl65" style="height:15.0pt" height="20">Monday, 15 August 2011</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl65" style="height:15.0pt" height="20">HOME v AWAY, 20:00</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl65" style="height:15.0pt" height="20">
</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl65" style="height:15.0pt" height="20">Saturday, 20 August 2011</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl65" style="height:15.0pt" height="20">HOME v AWAY, 12:00</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl65" style="height:15.0pt" height="20">HOME v AWAY, 12:45</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl65" style="height:15.0pt" height="20">HOME v AWAY, 15:00</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl65" style="height:15.0pt" height="20">HOME v AWAY, 15:00</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl65" style="height:15.0pt" height="20">HOME v AWAY, 15:00</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl65" style="height:15.0pt" height="20">HOME v AWAY, 15:00</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl65" style="height:15.0pt" height="20">HOME v AWAY, 15:00</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl65" style="height:15.0pt" height="20">HOME v AWAY, 17:30</td> </tr> </tbody></table>

 

[rossn13]

Managed to work something out if anybody's interested. I'm sure it's not the most efficient method

=IF(OR(RIGHT(A11,1)="0",RIGHT(A11,1)="5"),IF(OR(RIGHT(A10,1)="0",RIGHT(A10,1)="5"),IF(OR(RIGHT(A9,1)="0",RIGHT(A9,1)="5"),IF(OR(RIGHT(A8,1)="0",RIGHT(A8,1)="5"),IF(OR(RIGHT(A7,1)="0",RIGHT(A7,1)="5"),IF(OR(RIGHT(A6,1)="0",RIGHT(A6,1)="5"),IF(OR(RIGHT(A5,1)="0",RIGHT(A5,1)="5"),IF(OR(RIGHT(A4,1)="0",RIGHT(A4,1)="5"),IF(OR(RIGHT(A3,1)="0",RIGHT(A3,1)="5"),IF(OR(RIGHT(A2,1)="0",RIGHT(A2,1)="5"),A1,A2),A3),A4),A5),A6),A7),A8),A9),A10),"")