Spreadsheet: 869561d1716177066-formula-to-populate-location-data-based-on-exported-data-and-a-seperate-data-table-formula-test
Sheet: Top 100 by Location

Flight # | Origin | Destination | 1000Pax | PAX | Line Code1 | Line | DOT
 | Victoria | Tasmania | 56.46929824561403 | 206
8023 | Victoria | Tasmania | 20.200593304139 | 143
8028 | Tasmania | Victoria | 30.15797032072762 | 252
8029 | Victoria | Tasmania | 14.18037436188316 | 200
8036 | Tasmania | Victoria | 31.40035452013168 | 248
8038 | Tasmania | Victoria | 27.68662838392125 | 270
8042 | Tasmania | Victoria | 43.76012965964344 | 162
8072 | Tasmania | Victoria | 16.66377365040792 | 192
8076 | Tasmania | Victoria | 18.62358164775531 | 151
8080 | Tasmania | Victoria | 14.21236016871447 | 155
8101 | Victoria | New South Wales | 123.2423490488007 | 149
8107 | Victoria | New South Wales | 39.26701570680628 | 195
8108 | New South Wales | Victoria | 14.81909160892995 | 154
8113 | Victoria | New South Wales | 28.21939586645469 | 142
8122 | New South Wales | Victoria | 11.12771964789902 | 134
8123 | Victoria | New South Wales | 64.83672503549457 | 274
8125 | Victoria | New South Wales | 23.6707938820102 | 195
8126 | New South Wales | Victoria | 13.78481549554644 | 195
8128 | New South Wales | Victoria | 35.4334438654666 | 374
8129 | Victoria | New South Wales | 81.46143437077131 | 301
8131 | Victoria | New South Wales | 8.115471566865688 | 140
8134 | New South Wales | Victoria | 18.51851851851852 | 154
8135 | Victoria | New South Wales | 15.9028480555154 | 220
8136 | New South Wales | Victoria | 48.69702553303501 | 185
8138 | New South Wales | Victoria | 26.5497214649757 | 224
8142 | New South Wales | Victoria | 41.99265527702379 | 263
8144 | New South Wales | Victoria | 23.17235722341843 | 226
8157 | Victoria | New South Wales | 39.64757709251101 | 162
8172 | New South Wales | Victoria | 25.21306818181818 | 355
8180 | New South Wales | Victoria | 17.78385772913817 | 143
8181 | Victoria | New South Wales | 18.53520401596087 | 144
8183 | Victoria | New South Wales | 31.5279958137101 | 241
8184 | New South Wales | Victoria | 16.25453916652257 | 188
8185 | Victoria | New South Wales | 20.18962632459565 | 181
8186 | New South Wales | Victoria | 39.67780429594272 | 266
8188 | New South Wales | Victoria | 28.02646944336318 | 216
8227 | Victoria | New South Wales | 46.85494223363286 | 146
8229 | Victoria | New South Wales | 33.88069008522137 | 163
8231 | Victoria | New South Wales | 22.18636546994756 | 165
8233 | Victoria | New South Wales | 23.70125396169216 | 172
8235 | Victoria | New South Wales | 22.39133616273964 | 153
8238 | New South Wales | Victoria | 87.25490196078431 | 178
8244 | New South Wales | Victoria | 103.7514654161782 | 177
8306 | Northern Territory | Victoria | 38.89137237371479 | 174
8314 | Northern Territory | Victoria | 37.32057416267943 | 156
8321 | Victoria | Northern Territory | 41.32410212029425 | 191
8326 | Northern Territory | Victoria | 114.4219308700834 | 192
8328 | Northern Territory | Victoria | 105.4091539528433 | 152
8329 | Victoria | Northern Territory | 29.86776105791154 | 131
8364 | Northern Territory | Victoria | 63.75838926174497 | 171
8366 | Northern Territory | Victoria | 45.71070757670633 | 146
8368 | Northern Territory | Victoria | 60.68719321731371 | 136
8401 | Victoria | Western Australia | 51.78481649069884 | 206
8402 | Western Australia | Victoria | 65.54121151936444 | 132
8404 | Western Australia | Victoria | 39.40783986655546 | 189
8406 | Western Australia | Victoria | 46.31979695431472 | 219
8407 | Victoria | Western Australia | 52.90490100616683 | 163
8408 | Western Australia | Victoria | 35.60188827694729 | 181
8409 | Victoria | Western Australia | 62.09037599172129 | 180
8410 | Western Australia | Victoria | 143.9613526570048 | 149
8411 | Victoria | Western Australia | 54.68949654996166 | 214
8412 | Western Australia | Victoria | 71.68458781362007 | 480
8414 | Western Australia | Victoria | 32.33629749393695 | 200
8415 | Victoria | Western Australia | 55.06972346962893 | 233
8416 | Western Australia | Victoria | 42.58467609339034 | 259
8417 | Victoria | Western Australia | 42.33236151603499 | 363
8418 | Western Australia | Victoria | 52.15904232578025 | 244
8419 | Victoria | Western Australia | 42.10868153279931 | 389
8420 | Western Australia | Victoria | 98.17858729453577 | 442
8421 | Victoria | Western Australia | 29.1864764923402 | 221
8422 | Western Australia | Victoria | 137.7810007251632 | 570
8426 | Western Australia | Victoria | 98.14375987361768 | 497
8441 | Victoria | Western Australia | 31.63126976954361 | 140
8442 | Western Australia | Victoria | 110.4368932038835 | 455
8443 | Victoria | Western Australia | 47.48808214154749 | 259
8444 | Western Australia | Victoria | 75.13460597161038 | 307
8449 | Victoria | Western Australia | 40.44665012406948 | 163
8454 | Western Australia | Victoria | 184.5764854614412 | 146
8461 | Victoria | Western Australia | 31.50112504018 | 196
8464 | Western Australia | Victoria | 20.85070892410342 | 175
8465 | Victoria | Western Australia | 18.94068277191789 | 167
8468 | Western Australia | Victoria | 77.91754018169112 | 223
8469 | Victoria | Western Australia | 50.25041736227045 | 301
8702 | Queensland | Victoria | 32.7299323459499 | 179
8707 | Victoria | Queensland | 71.484375 | 183
8716 | Queensland | Victoria | 34.02132002721706 | 150
8744 | Queensland | Victoria | 13.84959046909903 | 186
8751 | Victoria | Queensland | 35.50784475639967 | 172
8760 | [NAME] | Victoria | 23.38033196501874 | 131
8768 | Queensland | Victoria | 30.02894356005789 | 166
8770 | Queensland | Victoria | 36.07610575735112 | 146
8786 | Queensland | Victoria | 23.36122733612273 | 134
8792 | Queensland | Victoria | 27.05253224284366 | 172
8793 | Victoria | Queensland | 22.18623481781376 | 137
8799 | Victoria | Queensland | 12.35222794786299 | 163
8800 | Queensland | Victoria | 49.33051444679352 | 140
8803 | Victoria | Queensland | 11.68191414496833 | 166
8805 | Victoria | Queensland | 10.10561507484234 | 133
8807 | Victoria | Queensland | 43.51552085317083 | 457
8811 | Victoria | Queensland | 17.80151312861593 | 160