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

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