Spreadsheet: 726851d1617538893-extracting-non-adjacent-data-from-table-using-a1-syntax-in-the-formula-test-ponies
Sheet: Data

Course | State | Track Location | Track Type | Direction | Image
Albany | WA | Country | Turf | Anti-Clockwise
Albury | NSW | Country |  | Clockwise | Yes
Ararat | VIC | Country |  | Anti-Clockwise
Armidale | NSW | Country |  | Clockwise
Ascot | WA | Metro | Turf | Anti-Clockwise
Balaklava Racing Club | SA | Prov |  | Anti-Clockwise
Ballarat | VIC | Country |  | Anti-Clockwise
Ballina | NSW | Country |  | Clockwise
Bairnsdale | VIC | Country |  | Anti-Clockwise
Bathurst | NSW | Country |  | Clockwise
Beaudessert | QLD | Country |  | Clockwise
Belmont | WA | Metro |  | Anti-Clockwise
Belmont | WA | Metro |  | Anti-Clockwise
Benalla | VIC | Country |  | Anti-Clockwise
Bendigo | VIC | Country |  | Anti-Clockwise
Bordertown | SA | Country | Turf | Anti-Clockwise
Broome | WA | Prov |  | Anti-Clockwise
Bunbury | WA | Prov |  | Anti-Clockwise
[NAME] | QLD | Country | Turf | Clockwise | No
Camperdown | VIC | Country |  | Anti-Clockwise
Canberra | ACT | Prov |  | Clockwise
Canterbury | NSW | Metro | Turf | Clockwise
Casteron | VIC | Country |  | Anti-Clockwise
Caulfield | VIC | Metro |  | Anti-Clockwise
Ceduna | SA | Country |  | Anti-Clockwise
Cessnock | NSW | Country |  | Clockwise
Clare | SA | Country | Turf | Anti-Clockwise
[NAME] | NSW | Country | Turf | Clockwise
Colac | VIC | Country |  | Anti-Clockwise
Coleraine | VIC | Country |  | Anti-Clockwise
Cranbourne | VIC | Country | Turf | Anti-Clockwise
[NAME] | VIC | Country |  | Anti-Clockwise
[NAME] | NT | Metro |  | Anti-Clockwise | No
Devonport Synthetic | TAS | Country | Synthetic | Anti-Clockwise | No
[NAME] | VIC | Country |  | Anti-Clockwise
Doomben | QLD | Metro |  | Clockwise
Dubbo | NSW | Country |  | Clockwise
[NAME] | VIC | Country |  | Anti-Clockwise
Eagle Farm | QLD | Metro |  | Clockwise
Echuca | VIC | Country |  | Anti-Clockwise
Edenhope | VIC | Country |  | Anti-Clockwise
Emerald | QLD | Country | Turf | Clockwise | No
Esperance Bay | WA | Prov | Turf | Anti-Clockwise
Flemington | VIC | Metro | Turf | Anti-Clockwise
Gatton | QLD | Country | Turf | Clockwise
Gawler | SA | Prov |  | Anti-Clockwise
Geelong | VIC | Country |  | Anti-Clockwise
[NAME] | WA | Country | Turf | Anti-Clockwise
Gladstone | QLD | Country |  | Clockwise | No
Glen Ines | NSW | Country | Turf | Clockwise | No
Gold Coast | QLD | Prov | Turf | Clockwise
Gosford | NSW | Prov |  | Clockwise
[NAME] | NSW | Country |  | Clockwise | Yes
Griffith | NSW | Country |  | Clockwise | No
Gundagai | NSW | Country |  | Clockwise
Gympie | VIC | Country |  | Anti-Clockwise
[NAME] | VIC | Country |  | Anti-Clockwise
[NAME] | VIC | Country |  | Anti-Clockwise
Hanging Rock | VIC | Country |  | Anti-Clockwise
Hawksbury | NSW | Prov |  | Clockwise
Healsville | VIC | Country | Turf | Anti-Clockwise
[NAME] | TAS | Metro |  | Anti-Clockwise | No
[NAME] | VIC | Country |  | Anti-Clockwise
Illawarra | NSW | Metro |  | Clockwise
Innisfail | QLD | Country | Turf | Clockwise
Inverell | NSW | Country |  | Clockwise | No
Ipswich | QLD | Prov | Turf | Clockwise
Kangaroo Island | SA | Country |  | Anti-Clockwise
[NAME] | NSW | Prov | Turf | Clockwise | No
Kilcoy | QLD | Prov |  | Clockwise
Kilmore | VIC | Country |  | Anti-Clockwise
Kyneton | VIC | Country |  | Anti-Clockwise
[NAME] | TAS | Metro | Turf | Anti-Clockwise | No
Lismore | NSW | Country |  | Clockwise
Mackay | QLD | Prov | Turf | Clockwise
Mansfield | VIC | Country | Turf | Anti-Clockwise
Mildura | VIC | Country |  | Anti-Clockwise
[NAME] | SA | Country |  | Anti-Clockwise
Moe | VIC | Country |  | Anti-Clockwise | Yes
Moonee Valley | VIC | Metro |  | Anti-Clockwise | Yes
Mornington | VIC | Country | Turf | Anti-Clockwise | Yes
[NAME] | SA | Metro |  | Anti-Clockwise
Morphettville | SA | Metro |  | Anti-Clockwise | Yes
Mortlake | VIC | Country |  | Anti-Clockwise
Moruya | NSW | Country | Turf | Clockwise | No
Mount Gamiber | SA | Prov |  | Anti-Clockwise
[NAME] | VIC | Prov |  | Anti-Clockwise
[NAME] | SA | Prov | Turf | Anti-Clockwise
[NAME] | VIC | Country |  | Anti-Clockwise
Muswellbrook | NSW | Country | Turf | Clockwise
Naracoorte | SA | Country |  | Anti-Clockwise
Narromine | NSW | Country |  | Clockwise
Newcastle | NSW | Prov | Turf | Clockwise
Northam | WA | Prov |  | Anti-Clockwise | No
Nowra | NSW | Country | Turf | Clockwise
Orange | NSW | Country | Turf | Clockwise
Pakenham | VIC | Country |  | Anti-Clockwise
Penola | SA | Country |  | Anti-Clockwise
Penshurst | VIC | Country |  | Anti-Clockwise
Pinjarra Park | WA | Country | Turf | Anti-Clockwise
Port Augusta | SA | Country |  | Anti-Clockwise
[NAME] | SA | Prov | Turf | Anti-Clockwise
Port Macquarie | NSW | Prov |  | Clockwise
Randwick | NSW | Metro | Turf | Clockwise
Rockhampton | QLD | Country | Turf | Clockwise | Yes
Rosehill | NSW | Metro | Turf | Clockwise
Sale | VIC | Country |  | Anti-Clockwise
[NAME] | VIC | Metro |  | Anti-Clockwise
[NAME] | VIC | Metro |  | Anti-Clockwise
Sapphire Coast | NSW | Country | Turf | Clockwise | No
Scone | NSW | Country | Turf | Clockwise | Yes
Seymore | VIC | Country |  | Anti-Clockwise
Spendthrift Australia Park | VIC | Country | Turf | Anti-Clockwise
St. Arnaud | VIC | Country |  | Anti-Clockwise
Stawell | VIC | Country | Turf | Anti-Clockwise
Stony Creek | VIC | Country |  | Anti-Clockwise
Strathalbyn | SA | Prov |  | Anti-Clockwise | No
Sunshine Coast | QLD | Country | Turf | Clockwise
[NAME] | VIC | Country | Turf | Anti-Clockwise
Tamworth | NSW | Country | Turf | Clockwise
Taree | NSW | Country | Turf | Clockwise | Yes
Taroom | QLD | Country | Turf | Clockwise | No
Tatura | VIC | Country |  | Anti-Clockwise
Terang | VIC | Country |  | Anti-Clockwise
Toowoomba | QLD | Prov | Turf | Clockwise
Townsville | QLD | Prov | Turf | Clockwise
Traralgon | VIC | Country |  | Anti-Clockwise
[NAME] | NSW | Country | Turf | Clockwise
Walcha | NSW | Country |  | Clockwise
Wangaratta | VIC | Country | Turf | Anti-Clockwise
Warracknabeal | VIC | Country |  | Anti-Clockwise
Warrnambool | VIC | Country | Turf | Anti-Clockwise
Warwick Farm | NSW | Metro | Turf | Clockwise
Wellington | NSW | Country | Turf | Clockwise
Werribee | VIC | Country |  | Anti-Clockwise
Wodonga | VIC | Country |  | Anti-Clockwise
Woolamai | VIC | Country |  | Anti-Clockwise
Wyong | NSW | Prov |  | Clockwise | Yes
Yarra Valley | VIC | Country |  | Anti-Clockwise
Yeppoon | QLD | Country