Spreadsheet: 801409d1666189370-formulate-unorganised-data-into-organised-one-portal-data1_v3
Sheet: Formulate here

 |  |  | Team Names |  | Team Score |  | Team Odds |  | Winner Odds
Date | Time | Playoff - Y/N | Team 1 | Team 2 | Team 1 | Team 2 | Team 1 | Team 2
 |  |  |  | [NAME] |  | 92 |  |  |  | When score is less than 100, the formula doesn't work. But if both teams score is more than 100, then formula works.
 |  |  |  | Adelaide Strikers |  | 167
 |  |  |  | [NAME] |  | 166
 |  |  |  | [NAME] |  | 167
 |  |  |  | Melbourne Renegades |  | 169
 |  |  |  | [NAME] |  | 178
 |  |  |  | Melbourne Renegades |  | 176
 |  |  |  | [NAME] |  | 156
 |  |  |  | [NAME] |  | 161
 |  |  |  | [NAME] |  | 149
 |  |  |  | [NAME] |  | 137
 |  |  |  | [NAME] |  | 132
 |  |  |  | [NAME] |  | 127
 |  |  |  | [NAME] |  | 123
 |  |  |  | [NAME] |  | 177
 |  |  |  | Adelaide Strikers |  | 161 |  |  |  | same issue as above
 |  |  |  | [NAME] |  | 150
 |  |  |  | [NAME] |  | 149
 |  |  |  | Adelaide Strikers |  | 139
 |  |  |  | [NAME] |  | 140
 |  |  |  | [NAME] |  | 152
 |  |  |  | [NAME] |  | 145
 |  |  |  | [NAME] |  | 209
 |  |  |  | [NAME] |  | 137
 |  |  |  | [NAME] |  | 128
 |  |  |  | [NAME] |  | 126
 |  |  |  | [NAME] |  | 133
 |  |  |  | [NAME] |  | 129
 |  |  |  | Adelaide Strikers |  | 144
 |  |  |  | [NAME] |  | 180
 |  |  |  | Melbourne Renegades
 |  |  |  | [NAME] |  | 150
 |  |  |  | [NAME] |  | 187
 |  |  |  | [NAME] |  | 206
 |  |  |  | [NAME] |  | 105
 |  |  |  | [NAME] |  | 166
 |  |  |  | [NAME] |  | 207
 |  |  |  | Adelaide Strikers |  | 175
 |  |  |  | Melbourne Renegades |  | 151
 |  |  |  | [NAME] |  | 168
 |  |  |  | [NAME] |  | 156
 |  |  |  | [NAME] |  | 208
 |  |  |  | [NAME] |  | 161
 |  |  |  | [NAME] |  | 150
 |  |  |  | [NAME] |  | 158
 |  |  |  | [NAME] |  | 167
 |  |  |  | Adelaide Strikers |  | 130
 |  |  |  | [NAME] |  | 180
 |  |  |  | [NAME] |  | 139
 |  |  |  | [NAME] |  | 175
 |  |  |  | [NAME] |  | 116
 |  |  |  | [NAME] |  | 188
 |  |  |  | Adelaide Strikers |  | 159
 |  |  |  | [NAME] |  | 182
 |  |  |  | [NAME] |  | 173
 |  |  |  | [NAME] |  | 232
 |  |  |  | [NAME] |  | 179
 |  |  |  | [NAME] |  | 115
 |  |  |  | [NAME] |  | 158
 |  |  |  | [NAME] |  | 115
 |  |  |  | [NAME] |  | 181
 |  |  |  | Melbourne Renegades |  | 150
 |  |  |  | [NAME] |  | 163
 |  |  |  | Adelaide Strikers |  | 68
 |  |  |  | Melbourne Renegades |  | 149
 |  |  |  | [NAME] |  | 132
 |  |  |  | [NAME] |  | 139
 |  |  |  | [NAME] |  | 149
 |  |  |  | [NAME] |  | 148
 |  |  |  | [NAME] |  | 168
 |  |  |  | [NAME] |  | 178
 |  |  |  | [NAME] |  | 110
 |  |  |  | [NAME] |  | 167
 |  |  |  | [NAME] |  | 97
 |  |  |  | Adelaide Strikers |  | 171
 |  |  |  | [NAME] |  | 174
 |  |  |  | [NAME] |  | 173
 |  |  |  | [NAME] |  | 151
 |  |  |  | Melbourne Renegades |  | 89
 |  |  |  | [NAME] |  | 165
 |  |  |  | [NAME] |  | 143
 |  |  |  | [NAME] |  | 117
 |  |  |  | [NAME] |  | 147
 |  |  |  | [NAME] |  | 149
 |  |  |  | [NAME] |  | 144
 |  |  |  | [NAME] |  | 169
 |  |  |  | Adelaide Strikers |  | 165
 |  |  |  | [NAME] |  | 148
 |  |  |  | [NAME] |  | 193
 |  |  |  | Melbourne Renegades |  | 80
 |  |  |  | Adelaide Strikers |  | 150
 |  |  |  | [NAME] |  | 152