Spreadsheet: 795666d1662828119-formula-to-extract-nique-numbers-and-instances-of-given-criteria-for-each-flight-number-instances-of-other-criteria-
Sheet: Sheet1

Flight Ref | Service Date | Invoice Date | Invoice | Order Number | Leg ID | Description | Amount | NM | VP | Service Fee | Ground Transportation | Passenger Fees (Tax) | Fuel surcharge | Internet | [NAME] | High Density Airport Fee | Landing & Handling |  |  | Flight |  | Ground Transportation | Passenger Fees (Tax) | Fuel surcharge | Internet | [NAME] | High Density Airport Fee | Landing & Handling
26 | 29-Apr-2022 | 18-Jul-2022 | [PHONE] | 1046372 | 2799209 | Ground Transportation in LARNACA, CYPRUS | 450 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 | 0 | 0 | 0 | 0 | 0
26 | 29-Apr-2022 | 18-Jul-2022 | [PHONE] | 1046372 | 2799209 | Service Fee | 45 |  |  |  |  |  |  |  |  |  |  |  |  | 27 |  | 0 | 0 | 0 | 1 | 0 | 0 | 0
27 | 01-May-2022 | 01-Jul-2022 | [PHONE] | 1046372 | 2874228 | On Board internet Usage From LCLK to FSIA | 2797.15 |  |  |  |  |  |  |  |  |  |  |  |  | 32 |  | 0 | 1 | 0 | 0 | 0 | 0 | 0
32 | 14-May-2022 | 01-Jul-2022 | [PHONE] | 1082871 | 2906992 | Airport Passenger Fees & Taxes at LCLK, LARNACA (Dep) | 27 |  |  |  |  |  |  |  |  |  |  |  |  | 33 |  | 0 | 0 | 0 | 1 | 0 | 0 | 0
33 | 23-May-2022 | 01-Jul-2022 | [PHONE] | 1088243 | 2922552 | On Board internet Usage From EGKB to LSGG | 1016.69 |  |  |  |  |  |  |  |  |  |  |  |  | 35 |  | 0 | 1 | 0 | 0 | 0 | 0 | 0
35 | 25-May-2022 | 01-Jul-2022 | [PHONE] | 1088243 | 2929721 | Airport Passenger Fees & Taxes at LSGG, GENEVA (Dep) | 28.89 |  |  |  |  |  |  |  |  |  |  |  |  | 38 |  | 0 | 1 | 0 | 0 | 0 | 0 | 0
38 | 30-May-2022 | 01-Jul-2022 | [PHONE] | 1094250 | 2940257 | Belgium Passenger Tax | 10.76 |  |  |  |  |  |  |  |  |  |  |  |  | 39 |  | 0 | 1 | 0 | 0 | 1 | 0 | 0
39 | 07-Jun-2022 | 01-Jul-2022 | [PHONE] | 1096989 | 2948307 | EU Carbon Emission charge - Flight from LOWW to EPWA | 361.02 |  |  |  |  |  |  |  |  |  |  |  |  | 40 |  | 0 | 0 | 0 | 0 | 1 | 0 | 0
39 | 07-Jun-2022 | 01-Jul-2022 | [PHONE] | 1096989 | 2948307 | Austrian Passenger Tax | 25.65 |  |  |  |  |  |  |  |  |  |  |  |  | 41 |  | 0 | 0 | 0 | 0 | 1 | 0 | 0
40 | 07-Jun-2022 | 01-Jul-2022 | [PHONE] | 1096989 | 2948306 | EU Carbon Emission charge - Flight from EGKB to LOWW | 813.99 |  |  |  |  |  |  |  |  |  |  |  |  | 42 |  | 0 | 0 | 0 | 0 | 1 | 0 | 0
41 | 09-Jun-2022 | 01-Jul-2022 | [PHONE] | 1096989 | 2948308 | Voluntary Carbon Emission Offset - Flight from EPWA to EGKB | 35.7 |  |  |  |  |  |  |  |  |  |  |  |  | 43 |  | 0 | 0 | 0 | 0 | 1 | 0 | 0
42 | 09-Jun-2022 | 01-Jul-2022 | [PHONE] | 1096989 | 2967602 | Voluntary Carbon Emission Offset - Flight from EGKB to EGLW | 2.27 |  |  |  |  |  |  |  |  |  |  |  |  | 44 |  | 1 | 0 | 0 | 0 | 1 | 0 | 0
43 | 13-Jun-2022 | 01-Jul-2022 | [PHONE] | 1096989 | 2975760 | Voluntary Carbon Emission Offset - Flight from EGLW to EGKB | 6.23 |  |  |  |  |  |  |  |  |  |  |  |  | 45 |  | 0 | 0 | 0 | 0 | 1 | 0 | 0
44 | 13-Jun-2022 | 01-Jul-2022 | [PHONE] | 1096989 | 2948310 | EU Carbon Emission charge - Flight from EGKB to EYVI | 897.95 |  |  |  |  |  |  |  |  |  |  |  |  | 46 |  | 0 | 0 | 0 | 0 | 1 | 0 | 0
44 | 13-Jun-2022 | 19-Jul-2022 | [PHONE] | 1096989 | 2948310 | Service Fee | 90 |  |  |  |  |  |  |  |  |  |  |  |  | 47 |  | 1 | 0 | 0 | 0 | 1 | 0 | 0
44 | 13-Jun-2022 | 19-Jul-2022 | [PHONE] | 1096989 | 2948310 | Ground Transportation in VILNIUS, LITHUANIA | 900 |  |  |  |  |  |  |  |  |  |  |  |  | 48 |  | 0 | 0 | 0 | 0 | 1 | 0 | 0
45 | 15-Jun-2022 | 01-Jul-2022 | [PHONE] | 1096989 | 2948309 | Voluntary Carbon Emission Offset - Flight from EYVI to EGKB | 41.65 |  |  |  |  |  |  |  |  |  |  |  |  | 49 |  | 0 | 4 | 0 | 0 | 1 | 0 | 0
46 | 15-Jun-2022 | 01-Jul-2022 | [PHONE] | 1096989 | 2975768 | Voluntary Carbon Emission Offset - Flight from EGKB to EGLW | 5.95 |  |  |  |  |  |  |  |  |  |  |  |  | 50 |  | 0 | 0 | 0 | 0 | 1 | 0 | 0
47 | 20-Jun-2022 | 19-Jul-2022 | [PHONE] | 1101314 | 2961718 | Ground Transportation in NICE/COTE D'AZUR, FRANCE | 292.5 |  |  |  |  |  |  |  |  |  |  |  |  | 51 |  | 1 | 0 | 0 | 0 | 1 | 0 | 0
47 | 20-Jun-2022 | 19-Jul-2022 | [PHONE] | 1101314 | 2961718 | Service Fee | 29.25 |  |  |  |  |  |  |  |  |  |  |  |  | 52 |  | 0 | 1 | 1 | 1 | 0 | 0 | 2
47 | 20-Jun-2022 | 01-Jul-2022 | [PHONE] | 1101314 | 2961718 | Voluntary Carbon Emission Offset - Flight from EGKB to LFMN | 28.05 |  |  |  |  |  |  |  |  |  |  |  |  | 53 |  | 0 | 0 | 1 | 1 | 0 | 0 | 2
48 | 20-Jun-2022 | 01-Jul-2022 | [PHONE] | 1101314 | 2975704 | Voluntary Carbon Emission Offset - Flight from EGLW to EGKB | 3.12 |  |  |  |  |  |  |  |  |  |  |  |  | 54 |  | 1 | 1 | 1 | 1 | 0 | 0 | 1
49 | 22-Jun-2022 | 01-Jul-2022 | [PHONE] | 1101314 | 2961719 | American Passenger Tax for CUF | 6.11 |  |  |  |  |  |  |  |  |  |  |  |  | 55 |  | 1 | 0 | 1 | 1 | 0 | 0 | 0
49 | 22-Jun-2022 | 01-Jul-2022 | [PHONE] | 1101314 | 2961719 | American Passenger Tax for IUF | 7 |  |  |  |  |  |  |  |  |  |  |  |  | 56 |  | 0 | 0 | 1 | 1 | 0 | 0 | 1
49 | 22-Jun-2022 | 01-Jul-2022 | [PHONE] | 1101314 | 2961719 | American Passenger Tax for USDA | 228.96 |  |  |  |  |  |  |  |  |  |  |  |  | 57 |  | 2 | 1 | 1 | 0 | 0 | 0 | 2
49 | 22-Jun-2022 | 01-Jul-2022 | [PHONE] | 1101314 | 2961719 | French Passenger Tax | 24.78 |  |  |  |  |  |  |  |  |  |  |  |  | 58 |  | 0 | 1 | 1 | 0 | 0 | 0 | 0
49 | 22-Jun-2022 | 01-Jul-2022 | [PHONE] | 1101314 | 2961719 | Voluntary Carbon Emission Offset - Flight from LFMN to KPSM | 137.42 |  |  |  |  |  |  |  |  |  |  |  |  | 59 |  | 0 | 0 | 1 | 0 | 0 | 1 | 0
50 | 23-Jun-2022 | 01-Jul-2022 | [PHONE] | 1101314 | 2969287 | Voluntary Carbon Emission Offset - Flight from KPSM to KOXC | 18.42 |  |  |  |  |  |  |  |  |  |  |  |  | 60 |  | 0 | 0 | 1 | 1 | 0 | 0 | 2
51 | 26-Jun-2022 | 04-Jul-2022 | [PHONE] | 1101314 | 2961720 | Ground Transportation in OXFORD, UNITED STATES | 390 |  |  |  |  |  |  |  |  |  |  |  |  | 61 |  | 0 | 0 | 1 | 1 | 0 | 0 | 2
51 | 26-Jun-2022 | 01-Jul-2022 | [PHONE] | 1101314 | 2961720 | Voluntary Carbon Emission Offset - Flight from KOXC to KSJC | 98.88 |  |  |  |  |  |  |  |  |  |  |  |  | 62 |  | 0 | 0 | 1 | 1 | 0 | 0 | 2
51 | 26-Jun-2022 | 04-Jul-2022 | [PHONE] | 1101314 | 2961720 | Service Fee | 39 |  |  |  |  |  |  |  |  |  |  |  |  | -
52 | 03-Jul-2022 | 03-Jul-2022 | [PHONE] | 1101314 | 2961722 | Landing and [NAME] at EGSS, Stansted (Dep) | 1320
52 | 03-Jul-2022 | 03-Jul-2022 | [PHONE] | 1101314 | 2961722 | Landing and [NAME] at OMDW, [NAME] (Arr) | 1260
52 | 03-Jul-2022 | 03-Jul-2022 | [PHONE] | 1101314 | 2961722 | UK Passenger Tax | 650.89
52 | 03-Jul-2022 | 03-Jul-2022 | [PHONE] | 1101314 | 2961722 | [NAME] for 6.9 Flight Hours | 20968.13
52 | 03-Jul-2022 | 03-Jul-2022 | [PHONE] | 1101314 | 2961722 | On Board internet Usage From EGSS to OMDW | 2474.01
53 | 04-Jul-2022 | 24-Jul-2022 | [PHONE] | 1089273 | 3020451 | [NAME] for 7.4 Flight Hours | 22487.56
53 | 04-Jul-2022 | 24-Jul-2022 | [PHONE] | 1089273 | 3020451 | On Board internet Usage From OMDB to EGBB | 745.31
53 | 04-Jul-2022 | 24-Jul-2022 | [PHONE] | 1089273 | 3020451 | Landing and Handling at EGBB, Birmingham (Arr) | 1680
53 | 04-Jul-2022 | 24-Jul-2022 | [PHONE] | 1089273 | 3020451 | Landing and [NAME] at OMDB, Dubai (Dep) | 1560
54 | 05-Jul-2022 | 24-Jul-2022 | [PHONE] | 1089273 | 3020452 | Landing and Handling at EGBB, Birmingham (Dep) | 1680
54 | 05-Jul-2022 | 24-Jul-2022 | [PHONE] | 1089273 | 3020452 | [NAME] for 7.4 Flight Hours | 22487.56
54 | 05-Jul-2022 | 24-Jul-2022 | [PHONE] | 1089273 | 3020452 | On Board internet Usage From EGBB to CYYZ | 5253.77
54 | 05-Jul-2022 | 24-Jul-2022 | [PHONE] | 1089273 | 3020452 | UK Passenger Tax | 1942.47
54 | 05-Jul-2022 | 19-Jul-2022 | [PHONE] | 1089273 | 3020452 | Service Fee | 67.87
54 | 05-Jul-2022 | 19-Jul-2022 | [PHONE] | 1089273 | 3020452 | Ground Transportation in TORONTO, CANADA | 678.75
55 | 08-Jul-2022 | 15-Jul-2022 | [PHONE] | 1089273 | 3020453 | Service Fee | 39
55 | 08-Jul-2022 | 24-Jul-2022 | [PHONE] | 1089273 | 3020453 | [NAME] for 1.2 Flight Hours | 2652.09
55 | 08-Jul-2022 | 15-Jul-2022 | [PHONE] | 1089273 | 3020453 | Ground Transportation in OTTAWA, CANADA | 390
55 | 08-Jul-2022 | 24-Jul-2022 | [PHONE] | 1089273 | 3020453 | On Board internet Usage From CYYZ to CYOW | 605.88
56 | 09-Jul-2022 | 24-Jul-2022 | [PHONE] | 1089273 | 3020454 | [NAME] for 6.5 Flight Hours | 19752.59
56 | 09-Jul-2022 | 24-Jul-2022 | [PHONE] | 1089273 | 3020454 | On Board internet Usage From CYOW to EGKB | 1451.61
56 | 10-Jul-2022 | 24-Jul-2022 | [PHONE] | 1089273 | 2925627 | Landing and [NAME] at EGKB, [NAME] (Arr) | 1680
57 | 10-Jul-2022 | 24-Jul-2022 | [PHONE] | 1089273 | 2925627 | [NAME] for 3.0 Flight Hours | 6630.24
57 | 10-Jul-2022 | 24-Jul-2022 | [PHONE] | 1089273 | 2925627 | UK Passenger Tax | 560.1
57 | 10-Jul-2022 | 15-Jul-2022 | [PHONE] | 1089273 | 2925627 | Service Fee | 71.25
57 | 10-Jul-2022 | 15-Jul-2022 | [PHONE] | 1089273 | 2925627 | Ground Transportation in NICE/COTE D'AZUR, FRANCE | 712.5
57 | 10-Jul-2022 | 15-Jul-2022 | [PHONE] | 1089273 | 2925627 | Ground Transportation in NICE/COTE D'AZUR, FRANCE | 862.5
57 | 10-Jul-2022 | 15-Jul-2022 | [PHONE] | 1089273 | 2925627 | Service Fee | 86.25
57 | 24-Jul-2022 | 24-Jul-2022 | [PHONE] | 1089273 | 2925628 | Landing and [NAME] at EGSS, Stansted (Dep) | 1320
57 | 24-Jul-2022 | 24-Jul-2022 | [PHONE] | 1089273 | 2925628 | Landing and Handling at LFMN, Nice (Arr) | 900
58 | 11-Jul-2022 | 11-Jul-2022 | [PHONE] | 1113574 | 2998235 | UK Passenger Tax | 15.61
58 | 11-Jul-2022 | 11-Jul-2022 | [PHONE] | 1113574 | 2998235 | [NAME] for 3.6 Flight Hours | 7956.29
59 | 22-Jul-2022 | 22-Jul-2022 | [PHONE] | 1134056 | 3058235 | [NAME] for 3.0 Flight Hours | 6630.24
59 | 22-Jul-2022 | 22-Jul-2022 | [PHONE] | 1134056 | 3058235 | High Density Airport Fee Nice/Cote [NAME] | 450
60 | 24-Jul-2022 | 24-Jul-2022 | [PHONE] | 1089273 | 2925628 | Landing and [NAME] at EGKK, [NAME] (Arr) | 2580
60 | 24-Jul-2022 | 24-Jul-2022 | [PHONE] | 1089273 | 2925628 | Landing and Handling at LFMN, Nice (Dep) | 900
60 | 24-Jul-2022 | 24-Jul-2022 | [PHONE] | 1089273 | 2925628 | [NAME] for 5.0 Flight Hours | 11050.4
60 | 24-Jul-2022 | 24-Jul-2022 | [PHONE] | 1089273 | 2925628 | On Board internet Usage From LFMN to EGKK | 187.2
61 | 25-Jul-2022 | 27-Jul-2022 | [PHONE] | 1138909 | 3072983 | [NAME] for 5.0 Flight Hours | 15194.3
61 | 25-Jul-2022 | 27-Jul-2022 | [PHONE] | 1138909 | 3072983 | Landing and Handling at EYVI, [NAME] (Arr) | 1320
61 | 25-Jul-2022 | 27-Jul-2022 | [PHONE] | 1138909 | 3072983 | Landing and Handling at LFMN, Nice/Cote D'Azur (Dep) | 900
61 | 25-Jul-2022 | 27-Jul-2022 | [PHONE] | 1138909 | 3072983 | On Board internet Usage From LFMN to EYVI | 1514.7
62 | 27-Jul-2022 | 27-Jul-2022 | [PHONE] | 1138909 | 3072984 | [NAME] for 5.0 Flight Hours | 15194.3
62 | 27-Jul-2022 | 27-Jul-2022 | [PHONE] | 1138909 | 3072984 | On Board internet Usage From EYVI to EGKB | 953.29
62 | 27-Jul-2022 | 27-Jul-2022 | [PHONE] | 1138909 | 3072984 | Landing and [NAME] at  [NAME], [NAME] (Arr) | 1680
62 | 27-Jul-2022 | 27-Jul-2022 | [PHONE] | 1138909 | 3072984 | Landing and Handling at EYVI, [NAME] (Dep) | 1320
- | 09-May-2022 | 01-Jul-2022 | [PHONE] | 1046372 | 2874229 | On Board internet Usage From FSIA to LCLK | -2650.86
- | 09-May-2022 | 01-Jul-2022 | [PHONE] | 1046372 | 2874229 | On Board internet Usage From FSIA to LCLK | 2650.86
 |  |  |  |  |  |  |  |  |  |  | Check