Spreadsheet: 95317d1294930609-excel-2007-selecting-lowest-value-and-returning-column-title-sheet
Sheet: Sheet1

Zip Code | ATL to: | Min |  | 100k |  |  | 500k | 100k |  |  | 500k | 100k |  |  | 500k
30349 | ATL | 30 |  | - | - | - | - | - | - | - | - | - | - | - | -
78719 | AUS | 36.00 |  | 0.5489454 | 24.90 | 24.66 | 0.54365436 | 0.63128721 | 95.45 | 69.34 | 0.458600892 | 0.63955446 | 29.01 | 25.6 | 0.5643776
6096 | BDL | 35.50 |  | 0.59921028 | 27.18 | 25.93 | 0.57165278 | 0.6685229039999999 | 101.08 | 73.43 | 0.485651334 | 0.84502318 | 38.33 | 35.56 | 0.7839557600000001
37214 | BNA | 26.00 |  | 0.24052186 | 10.91 | 9.90 | 0.2182554 | 0.35879865 | 54.25 | 36.73 | 0.242924874 | 0.42284228 | 19.18 | 17.29 | 0.38117534
2111 | BOS | 35.50 |  | 0.4839097000000001 | 21.95 | 20.48 | 0.45150208 | 0.680758434 | 102.93 | 74.79 | 0.494646102 | 0.8068836 | 36.6 | 34.06 | 0.7508867600000001
78521 | BRO | 55.00 |  | 0.6922444000000001 | 31.40 | 30.77 | 0.6783554199999999 | 0.446299224 | 67.48 | 74.28 | 0.491273064 | - | - | - | -
21240 | BWI | 33.50 |  | 0.4861143000000001 | 22.05 | 19.36 | 0.42681056 | 0.5687206619999999 | 85.99 | 60.78 | 0.401986764 | 0.7063538400000001 | 32.04 | 29.22 | 0.64418412
44135 | CLE | 33.50 |  | 0.4746503800000001 | 21.53 | 19.52 | 0.43033792 | 0.669382698 | 101.21 | 62.59 | 0.4139577420000001 | 0.7839557600000001 | 35.56 | 32.74 | 0.7217860400000001
28208 | CLT | 33.50 |  | 0.4232832 | 19.20 | 16.28 | 0.35890888 | 0.34490967 | 52.15 | 35.33 | 0.233665554 | 0.43915632 | 19.92 | 17.39 | 0.38337994
43219 | CMH | 33.50 |  | 0.4839097000000001 | 21.95 | 19.91 | 0.43893586 | 0.617332092 | 93.34 | 57.72 | 0.381748536 | 0.64947516 | 29.46 | 26.59 | 0.5862031400000001
78406 | CRP | 55.00 |  | 0.62125628 | 28.18 | 27.62 | 0.60891052 | 0.653840268 | 98.86 | 71.8 | 0.47487084 | 0.8390707600000001 | 38.06 | 35.44 | 0.78131024
41042 | CVG | 39.50 |  | 0.55798426 | 25.31 | 22.32 | 0.4920667200000001 | 0.4400822520000001 | 66.54 | 47.03 | 0.311047014 | 0.66975748 | 30.38 | 27.77 | 0.61221742
92231 | CXL | 51.00 |  | 1.34348324 | 60.94 | 51.05 | 1.1254483 | 0.9505353360000001 | 143.72 | 99.14 | 0.6556921320000001 | - | - | - | -
45377 | DAY | 33.50 |  | 0.5026488 | 22.80 | 20.68 | 0.45591128 | 0.606882288 | 91.76 | 56.74 | 0.375267012 | 0.7786647200000001 | 35.32 | 31.9 | 0.7032674000000001
76051 | DFW | 36.00 |  | 0.25815866 | 11.71 | 11.54 | 0.25441084 | 0.62004375 | 93.75 | 68.11 | 0.450465918 | 0.61816984 | 28.04 | 25.58 | 0.56393668
48242 | DTW | 33.50 |  | 0.43937678 | 19.93 | 18.10 | 0.3990326000000001 | 0.679832502 | 102.79 | 63.55 | 0.4203069899999999 | 0.7744759800000001 | 35.13 | 32.11 | 0.7078970600000001
79925 | ELP | 41.00 |  | 0.93519132 | 42.42 | 38.56 | 0.85009376 | 0.743787948 | 112.46 | 81.69 | 0.540281322 | 0.7301635200000001 | 33.12 | 30.64 | 0.67548944
47725 | EVV | 39.50 |  | 0.60758776 | 27.56 | 24.99 | 0.5509295399999999 | 0.5653476239999999 | 85.48 | 52.87 | 0.349671606 | - | - | - | -
7114 | EWR | 33.50 |  | 0.53483596 | 24.26 | 21.10 | 0.4651706 | 0.6623720700000001 | 100.15 | 74.7 | 0.49405086 | 0.63690894 | 28.89 | 26.14 | 0.5762824400000001
46809 | FWA | 36.00 |  | 0.60758776 | 27.56 | 24.99 | 0.5509295399999999 | 0.638165562 | 96.49 | 59.69 | 0.394777722 | - | - | - | -
99224 | GEG | 75.00 |  | 0.7603665400000001 | 34.49 | 33.40 | 0.7363364 | 0.9505353360000001 | 143.72 | 99.14 | 0.6556921320000001 | - | - | - | -
49512 | GRR | 36.00 |  | 0.60758776 | 27.56 | 24.99 | 0.5509295399999999 | 0.699475488 | 105.76 | 65.41 | 0.432608658 | - | - | - | -
27409 | GSO | 33.50 |  | 0.42284228 | 19.18 | 16.26 | 0.3584679600000001 | 0.395108412 | 59.74 | 40.46 | 0.267594348 | 0.6040603999999999 | 27.4 | 25.01 | 0.55137046
29651 | GSP | 39.50 |  | 0.42284228 | 19.18 | 16.26 | 0.3584679600000001 | 0.2895521640000001 | 43.78 | 29.66 | 0.196165308 | 0.5908328 | 26.8 | 24.61 | 0.54255206
78550 | HRL | 55.00 |  | 0.7129676400000001 | 32.34 | 31.69 | 0.6986377400000001 | 0.676194912 | 102.24 | 74.28 | 0.491273064 | - | - | - | -
22202 | IAD | 33.50 |  | 0.50463294 | 22.89 | 20.11 | 0.44334506 | 0.5187864719999999 | 78.44 | 55.44 | 0.366669072 | 0.68695336 | 31.16 | 28.53 | 0.62897238
77032 | IAH | 36.00 |  | 0.32936724 | 14.94 | 14.56 | 0.32098976 | 0.597490692 | 90.34 | 65.63 | 0.4340636940000001 | 0.3494291 | 15.85 | 15.85 | 0.3494291
46241 | IND | 33.50 |  | 0.49581454 | 22.49 | 20.39 | 0.44951794 | 0.606882288 | 91.76 | 56.74 | 0.375267012 | 0.67196208 | 30.48 | 26.89 | 0.5928169400000001
11430 | [NAME] | 33.50 |  | 0.52381296 | 23.76 | 20.91 | 0.46098186 | 0.7418699459999999 | 112.17 | 83.66 | 0.553310508 | 0.66887564 | 30.34 | 28.59 | 0.63029514
89111 | LAS | 36.00 |  | 0.81989074 | 37.19 | 34.66 | 0.76411436 | 0.8547675120000001 | 129.24 | 89.16 | 0.589686408 | 0.8187884400000001 | 37.14 | 34.33 | 0.7568391800000001
90045 | LAX | 36.00 |  | 0.40983514 | 18.59 | 18.59 | 0.40983514 | 0.9062890140000001 | 137.03 | 94.51 | 0.6250702380000001 | 0.68144186 | 30.91 | 28.96 | 0.63845216
40510 | LEX | 36.00 |  | 0.60758776 | 27.56 | 24.99 | 0.5509295399999999 | 0.406285734 | 61.43 | 41.61 | 0.275200218 | - | - | - | -
78040 | LRD | 36.00 |  | 0.58664406 | 26.61 | 25.19 | 0.55533874 | 0.665083728 | 100.56 | 73.05 | 0.48313809 | - | - | - | -
48623 | MBS | 36.00 |  | 0.60758776 | 27.56 | 24.99 | 0.5509295399999999 | 0.7084702560000001 | 107.12 | 72.56 | 0.479897328 | - | - | - | -
64153 | MCI | 36.00 |  | 0.53880424 | 24.44 | 22.17 | 0.4887598200000001 | 0.6088002899999999 | 92.05 | 66.87 | 0.4422648060000001 | 0.75022538 | 34.03 | 31.34 | 0.6909216400000001
17057 | MDT | 33.50 |  | 0.31900562 | 14.47 | 14.32 | 0.31569872 | 0.6152156759999999 | 93.02 | 65.74 | 0.434791212 | 0.6975354400000001 | 31.64 | 29.13 | 0.64219998
38116 | MEM | 31.00 |  | 0.24867888 | 11.28 | 10.22 | 0.22531012 | 0.4176614699999999 | 63.15 | 44.63 | 0.295173894 | 0.42967654 | 19.49 | 17.58 | 0.38756868
78503 | MFE | 55.00 |  | 0.65212068 | 29.58 | 27.81 | 0.61309926 | 0.676194912 | 102.24 | 74.28 | 0.491273064 | 0.74471388 | 33.78 | 32.54 | 0.71737684
33122 | MIA | 34.50 |  | 0.27954328 | 12.68 | 10.84 | 0.23897864 | 0.649607436 | 98.22 | 69.4 | 0.4589977200000001 | 0.4651706 | 21.1 | 18.97 | 0.41821262
53207 | MKE | 33.50 |  | 0.57892796 | 26.26 | 22.34 | 0.49250764 | 0.7084702560000001 | 107.12 | 72.56 | 0.479897328 | 0.80004934 | 36.29 | 33.07 | 0.7290612200000001
55450 | MSP | 33.50 |  | 0.5884077400000001 | 26.69 | 23.33 | 0.51433318 | 0.653840268 | 98.86 | 71.8 | 0.47487084 | 0.7943173800000001 | 36.03 | 32.11 | 0.7078970600000001
85621 | OLS | 56.00 |  | 0.9777401000000001 | 44.35 | 40.13 | 0.8847059800000001 | 0.818722302 | 123.79 | 85.37 | 0.564620106 | - | - | - | -
60666 | ORD | 33.50 |  | 0.3185647 | 14.45 | 12.59 | 0.27755914 | 0.679832502 | 102.79 | 63.55 | 0.4203069899999999 | 0.52381296 | 23.76 | 24.24 | 0.5343950399999999
23518 | ORF | 33.50 |  | 0.41071698 | 18.63 | 18.18 | 0.40079628 | 0.49636569 | 75.05 | 53.03 | 0.350729814 | 0.8112928 | 36.8 | 33.34 | 0.7350136400000001
97218 | PDX | 46.00 |  | 0.59678522 | 27.07 | 24.55 | 0.5412293 | 1.001064768 | 151.36 | 104.41 | 0.690546858 | 0.8619986000000001 | 39.1 | 36.1 | 0.7958606
19153 | PHL | 33.50 |  | 0.4909644200000001 | 22.27 | 19.34 | 0.42636964 | 0.604633596 | 91.42 | 64.62 | 0.4273837560000001 | 0.71186534 | 32.29 | 29.37 | 0.64749102
85034 | PHX | 36.00 |  | 0.62081536 | 28.16 | 25.55 | 0.5632753 | 0.804105804 | 121.58 | 83.9 | 0.55489782 | 0.7462571000000001 | 33.85 | 31.2 | 0.6878352
15126 | PIT | 0 |  | - | - | - | - | 0.604633596 | 91.42 | 64.62 | 0.4273837560000001 | 0.8194498200000001 | 37.17 | 34.05 | 0.7506663
27560 | RDU | 39.50 |  | 0.42063768 | 19.08 | 16.43 | 0.36221578 | 0.4400822520000001 | 66.54 | 47.03 | 0.311047014 | 0.5593070200000001 | 25.37 | 22.87 | 0.5041920200000001
23250 | RIC | 33.50 |  | 0.29078674 | 13.19 | 13.07 | 0.28814122 | 0.473812632 | 71.64 | 50.62 | 0.334790556 | 0.71737684 | 32.54 | 29.59 | 0.65234114
92101 | SAN | 36.00 |  | 0.7517686000000001 | 34.10 | 34.10 | 0.7517686000000001 | 0.9062890140000001 | 137.03 | 94.51 | 0.6250702380000001 | 0.93541178 | 42.43 | 39.19 | 0.86398274
78216 | SAT | 36.00 |  | 0.55203184 | 25.04 | 23.77 | 0.52403342 | 0.6425306700000001 | 97.15 | 70.58 | 0.466802004 | 0.69136256 | 31.36 | 28.99 | 0.63911354
46628 | SBN | 36.00 |  | 0.60758776 | 27.56 | 24.99 | 0.5509295399999999 | 0.6588667560000001 | 99.62 | 61.62 | 0.4075423559999999 | - | - | - | -
40209 | SDF | 33.50 |  | 0.4746503800000001 | 21.53 | 19.52 | 0.43033792 | 0.428772654 | 64.83 | 45.81 | 0.302978178 | 0.5996512 | 27.2 | 24.92 | 0.5493863200000001
98158 | SEA | 36.00 |  | 0.62434272 | 28.32 | 25.67 | 0.5659208200000001 | 1.02315486 | 154.7 | 106.7 | 0.70569246 | 0.85891216 | 38.96 | 36.04 | 0.79453784
94128 | SFO | 36.00 |  | 0.52094698 | 23.63 | 21.43 | 0.47244578 | 0.9789746760000001 | 148.02 | 102.1 | 0.6752689799999999 | 0.8344411 | 37.85 | 35.06 | 0.7729327600000001
63134 | STL | 31.00 |  | 0.52778124 | 23.94 | 21.71 | 0.4786186600000001 | 0.627781896 | 94.92 | 58.7 | 0.38823006 | 0.7134085600000001 | 32.36 | 29.71 | 0.65498666
43558 | TOL | 33.50 |  | 0.60758776 | 27.56 | 24.99 | 0.5509295399999999 | 0.6588667560000001 | 99.62 | 61.62 | 0.4075423559999999 | 1.00154978 | 45.43 | 40.38 | 0.8902174800000001
85756 | TUS | 41.00 |  | 1.1320621 | 51.35 | 49.22 | 1.08510412 | 0.804105804 | 121.58 | 83.9 | 0.55489782 | 0.98744034 | 44.79 | 41.84 | 0.9224046400000001
49686 | TVC | 36.00 |  | 0.5727550800000001 | 25.98 | 23.57 | 0.51962422 | 0.726393654 | 109.83 | 74.4 | 0.4920667200000001 | - | - | - | -
 | MTY | 0 |  | - | - | - | - | - | - | - | - | - | - | - | -
 | Base rates only; does not include fuel or accessorial charges.