Hi All,
Someone please help, I am trying to create a spreadsheet with my clubs sports fixtures for the coming season.
The fixtures have been sent for the full league in the format below. I am trying to work a formula so that it will automatically extract the fixture for a set team and place it with the date on an additional tab.
<tbody>
</tbody>
Someone please help, I am trying to create a spreadsheet with my clubs sports fixtures for the coming season.
The fixtures have been sent for the full league in the format below. I am trying to work a formula so that it will automatically extract the fixture for a set team and place it with the date on an additional tab.
19-Sep-15 | ||||
Old Loughts 1 | : | CoP 1 | ||
Wapping 1 | : | Chelmsford 1 | ||
St Albans 1 | : | Cambridge Uni 1 | ||
Ipswich 1 | : | Cambridge City 2 | ||
Havering 1 | : | Blueharts 1 | ||
Dereham 1 | : | Bedford 1 | ||
26-Sep-15 | ||||
CoP 1 | : | Dereham 1 | ||
Chelmsford 1 | : | Old Loughts 1 | ||
Cambridge Uni 1 | : | Wapping 1 | ||
Cambridge City 2 | : | St Albans 1 | ||
Blueharts 1 | : | Ipswich 1 | ||
Bedford 1 | : | Havering 1 |
<tbody>
</tbody>