Spreadsheet: 887338d1737572223-how-to-find-a-result-according-two-conditions-and-one-parameter-copie-de-dsm-draft-agup-ph2
Sheet: Fichier Suivi TAS 

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ITD | ITD | ITD | ITD | ITD | ITD | ITD | ITD | ITD | ITD | ITD | ITD | ITD | ITD | ITD | ITD | ITD | ITD | ITD
 |  |  |  |  |  |  |  |  | x
 |  |  |  |  |  |  |  |  | Test |  |  |  |  |  |  |  |  |  |  |  |  | Item |  |  |  |  |  |  |  |  | ITD | 2022-06-01 00:00:00 | 2022-07-01 00:00:00 | 2022-08-01 00:00:00 | 2022-09-01 00:00:00 | 2022-10-01 00:00:00 | 2022-11-01 00:00:00 | 2022-12-01 00:00:00 | 2023-01-01 00:00:00 | 2023-02-01 00:00:00 | 2023-03-01 00:00:00 | 2023-04-01 00:00:00 | 2023-05-01 00:00:00 | 2023-06-01 00:00:00 | 2023-07-01 00:00:00 | 2023-08-01 00:00:00 | 2023-09-01 00:00:00 | 2023-10-01 00:00:00 | 2023-11-01 00:00:00 | 2023-12-01 00:00:00
 |  |  |  |  |  |  |  |  | 4100004353 |  |  |  |  |  |  |  |  |  |  |  |  | 00001 |  |  |  |  |  |  |  |  | 382328
 |  |  |  |  |  |  |  |  | 4100004353 |  |  |  |  |  |  |  |  |  |  |  |  | 00002 |  |  |  |  |  |  |  |  | 8877.19
 |  |  |  |  |  |  |  |  | 4100004388 |  |  |  |  |  |  |  |  |  |  |  |  | 00001 |  |  |  |  |  |  |  |  | 359013.5
 |  |  |  |  |  |  |  |  | 4100004388 |  |  |  |  |  |  |  |  |  |  |  |  | 00002 |  |  |  |  |  |  |  |  | 7255.81
 |  |  |  |  |  |  |  |  | 4100003513 |  |  |  |  |  |  |  |  |  |  |  |  | 00001 |  |  |  |  |  |  |  |  | 50660 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7140 | 6800 | 7820 | 6460
 |  |  |  |  |  |  |  |  | 4100003513 |  |  |  |  |  |  |  |  |  |  |  |  | 00002 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 4100004072 |  |  |  |  |  |  |  |  |  |  |  |  | 00001 |  |  |  |  |  |  |  |  | 70320 |  |  |  |  |  |  |  | 5860 | 5860 | 5860 | 5860 | 5860 | 5860 | 5860 | 5860 | 5860 | 5860 | 5860 | 5860
 |  |  |  |  |  |  |  |  | 4100004072 |  |  |  |  |  |  |  |  |  |  |  |  | 00002 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 4100003401 |  |  |  |  |  |  |  |  |  |  |  |  | 00003 |  |  |  |  |  |  |  |  | 70320
 |  |  |  |  |  |  |  |  | 4100003401 |  |  |  |  |  |  |  |  |  |  |  |  | 00004 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 4100004715 |  |  |  |  |  |  |  |  |  |  |  |  | 00005 |  |  |  |  |  |  |  |  | 39040
 |  |  |  |  |  |  |  |  | 4100004715 |  |  |  |  |  |  |  |  |  |  |  |  | 00006 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 4100004715 |  |  |  |  |  |  |  |  |  |  |  |  | 00007 |  |  |  |  |  |  |  |  | 39040
 |  |  |  |  |  |  |  |  | 4100004715 |  |  |  |  |  |  |  |  |  |  |  |  | 00008 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 4100004095 |  |  |  |  |  |  |  |  |  |  |  |  | 00001 |  |  |  |  |  |  |  |  | 80576.09 |  |  |  |  | 6909.53 | 6580.5 | 5264.4 | 6415.99 | 6580.5 | 7567.58 | 1316.1 | 1645.13 | 2632.2 | 2632.2 | 3290.25 | 2303.18
 |  |  |  |  |  |  |  |  | 4100004095 |  |  |  |  |  |  |  |  |  |  |  |  | 00002 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 4100004095 |  |  |  |  |  |  |  |  |  |  |  |  | 00003 |  |  |  |  |  |  |  |  | 112425.69
 |  |  |  |  |  |  |  |  | 4100004095 |  |  |  |  |  |  |  |  |  |  |  |  | 00004 |  |  |  |  |  |  |  |  | 1793.27
 |  |  |  |  |  |  |  |  | 4100005382 |  |  |  |  |  |  |  |  |  |  |  |  | 00001 |  |  |  |  |  |  |  |  | 52278.9375
 |  |  |  |  |  |  |  |  | 4100005382 |  |  |  |  |  |  |  |  |  |  |  |  | 00002 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 4100004104 |  |  |  |  |  |  |  |  |  |  |  |  | 00001 |  |  |  |  |  |  |  |  | 92027.43 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9630.81 | 22440.81 | 23355.81 | 22440.81 | 21525.81
 |  |  |  |  |  |  |  |  | 4100004104 |  |  |  |  |  |  |  |  |  |  |  |  | 00002 |  |  |  |  |  |  |  |  | 3756.86
 |  |  |  |  |  |  |  |  | 4100004104 |  |  |  |  |  |  |  |  |  |  |  |  | 00003 |  |  |  |  |  |  |  |  | 85971.87
 |  |  |  |  |  |  |  |  | 4100004104 |  |  |  |  |  |  |  |  |  |  |  |  | 00004 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 4100004104 |  |  |  |  |  |  |  |  |  |  |  |  | 00005 |  |  |  |  |  |  |  |  | 67027.17
 |  |  |  |  |  |  |  |  | 4100004104 |  |  |  |  |  |  |  |  |  |  |  |  | 00006 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 4100003817 |  |  |  |  |  |  |  |  |  |  |  |  | 00001 |  |  |  |  |  |  |  |  | 169632.5 |  |  |  |  |  |  |  | 12720 | 14707.5 | 15105 | 15105 | 13515 | 17490 | 11130 | 7950 | 15105 | 17490 | 16595 | 12720
 |  |  |  |  |  |  |  |  | 4100003817 |  |  |  |  |  |  |  |  |  |  |  |  | 00002 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 4100003817 |  |  |  |  |  |  |  |  |  |  |  |  | 00003 |  |  |  |  |  |  |  |  | 173470
 |  |  |  |  |  |  |  |  | 4100003817 |  |  |  |  |  |  |  |  |  |  |  |  | 00004 |  |  |  |  |  |  |  |  | 660.05
 |  |  |  |  |  |  |  |  | 4100004324 |  |  |  |  |  |  |  |  |  |  |  |  | 00001 |  |  |  |  |  |  |  |  | 189853.1
 |  |  |  |  |  |  |  |  | 4100004324 |  |  |  |  |  |  |  |  |  |  |  |  | 00002 |  |  |  |  |  |  |  |  | 2129.61
 |  |  |  |  |  |  |  |  | 4100004324 |  |  |  |  |  |  |  |  |  |  |  |  | 00003 |  |  |  |  |  |  |  |  | 10455.9
 |  |  |  |  |  |  |  |  | 4100004324 |  |  |  |  |  |  |  |  |  |  |  |  | 00004 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 4100004355 |  |  |  |  |  |  |  |  |  |  |  |  | 00001 |  |  |  |  |  |  |  |  | 80129.28
 |  |  |  |  |  |  |  |  | 4100004355 |  |  |  |  |  |  |  |  |  |  |  |  | 00002 |  |  |  |  |  |  |  |  | 2968.33
 |  |  |  |  |  |  |  |  | 4100005216 |  |  |  |  |  |  |  |  |  |  |  |  | 00001 |  |  |  |  |  |  |  |  | 100481.52
 |  |  |  |  |  |  |  |  | 4100005216 |  |  |  |  |  |  |  |  |  |  |  |  | 00002 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 4100004313 |  |  |  |  |  |  |  |  |  |  |  |  | 00001 |  |  |  |  |  |  |  |  | 246317.6225
 |  |  |  |  |  |  |  |  | 4100004313 |  |  |  |  |  |  |  |  |  |  |  |  | 00002 |  |  |  |  |  |  |  |  | 2907.82
 |  |  |  |  |  |  |  |  | 4100004328 |  |  |  |  |  |  |  |  |  |  |  |  | 00001 |  |  |  |  |  |  |  |  | 249500
 |  |  |  |  |  |  |  |  | 4100004328 |  |  |  |  |  |  |  |  |  |  |  |  | 00002 |  |  |  |  |  |  |  |  | 7669.76
 |  |  |  |  |  |  |  |  | 4100004359 |  |  |  |  |  |  |  |  |  |  |  |  | 00001 |  |  |  |  |  |  |  |  | 177161.25
 |  |  |  |  |  |  |  |  | 4100004359 |  |  |  |  |  |  |  |  |  |  |  |  | 00002 |  |  |  |  |  |  |  |  | 2102.49
 |  |  |  |  |  |  |  |  | 4100004359 |  |  |  |  |  |  |  |  |  |  |  |  | 00003 |  |  |  |  |  |  |  |  | 36065
 |  |  |  |  |  |  |  |  | 4100004359 |  |  |  |  |  |  |  |  |  |  |  |  | 00004 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 4100004319 |  |  |  |  |  |  |  |  |  |  |  |  | 00001 |  |  |  |  |  |  |  |  | 222615
 |  |  |  |  |  |  |  |  | 4100004319 |  |  |  |  |  |  |  |  |  |  |  |  | 00002 |  |  |  |  |  |  |  |  | 685.94
 |  |  |  |  |  |  |  |  | 4100004319 |  |  |  |  |  |  |  |  |  |  |  |  | 00003 |  |  |  |  |  |  |  |  | 11700
 |  |  |  |  |  |  |  |  | 4100004319 |  |  |  |  |  |  |  |  |  |  |  |  | 00004 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 4100004263 |  |  |  |  |  |  |  |  |  |  |  |  | 00001 |  |  |  |  |  |  |  |  | 228741.087890625
 |  |  |  |  |  |  |  |  | 4100004263 |  |  |  |  |  |  |  |  |  |  |  |  | 00002 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 4100004358 |  |  |  |  |  |  |  |  |  |  |  |  | 00001 |  |  |  |  |  |  |  |  | 233200
 |  |  |  |  |  |  |  |  | 4100004358 |  |  |  |  |  |  |  |  |  |  |  |  | 00002 |  |  |  |  |  |  |  |  | 4342.17
 |  |  |  |  |  |  |  |  | 4100004358 |  |  |  |  |  |  |  |  |  |  |  |  | 00003 |  |  |  |  |  |  |  |  | 41200
 |  |  |  |  |  |  |  |  | 4100004358 |  |  |  |  |  |  |  |  |  |  |  |  | 00004 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 4100004318 |  |  |  |  |  |  |  |  |  |  |  |  | 00001 |  |  |  |  |  |  |  |  | 186064.825
 |  |  |  |  |  |  |  |  | 4100004318 |  |  |  |  |  |  |  |  |  |  |  |  | 00002 |  |  |  |  |  |  |  |  | 2463.84
 |  |  |  |  |  |  |  |  | 4100004318 |  |  |  |  |  |  |  |  |  |  |  |  | 00003 |  |  |  |  |  |  |  |  | 11286.275
 |  |  |  |  |  |  |  |  | 4100004318 |  |  |  |  |  |  |  |  |  |  |  |  | 00004 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 4100004712 |  |  |  |  |  |  |  |  |  |  |  |  | 00001 |  |  |  |  |  |  |  |  | 221753.62875
 |  |  |  |  |  |  |  |  | 4100004712 |  |  |  |  |  |  |  |  |  |  |  |  | 00002 |  |  |  |  |  |  |  |  | 7523.139999999999
 |  |  |  |  |  |  |  |  | 4100005097 |  |  |  |  |  |  |  |  |  |  |  |  | 00001 |  |  |  |  |  |  |  |  | 124836
 |  |  |  |  |  |  |  |  | 4100005097 |  |  |  |  |  |  |  |  |  |  |  |  | 00002 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 4100004770 |  |  |  |  |  |  |  |  |  |  |  |  | 00001 |  |  |  |  |  |  |  |  | 105104.1475
 |  |  |  |  |  |  |  |  | 4100004770 |  |  |  |  |  |  |  |  |  |  |  |  | 00002 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 4100004772 |  |  |  |  |  |  |  |  |  |  |  |  | 00001 |  |  |  |  |  |  |  |  | 36631.86
 |  |  |  |  |  |  |  |  | 4100004772 |  |  |  |  |  |  |  |  |  |  |  |  | 00002 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 4100004772 |  |  |  |  |  |  |  |  |  |  |  |  | 00003 |  |  |  |  |  |  |  |  | 83328
 |  |  |  |  |  |  |  |  | 4100004772 |  |  |  |  |  |  |  |  |  |  |  |  | 00004 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 4100004830 |  |  |  |  |  |  |  |  |  |  |  |  | 00001 |  |  |  |  |  |  |  |  | 95030
 |  |  |  |  |  |  |  |  | 4100004830 |  |  |  |  |  |  |  |  |  |  |  |  | 00002 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 4100004827 |  |  |  |  |  |  |  |  |  |  |  |  | 00001 |  |  |  |  |  |  |  |  | 133279.58
 |  |  |  |  |  |  |  |  | 4100004827 |  |  |  |  |  |  |  |  |  |  |  |  | 00002 |  |  |  |  |  |  |  |  | 11598.09
 |  |  |  |  |  |  |  |  | 4100004827 |  |  |  |  |  |  |  |  |  |  |  |  | 00003 |  |  |  |  |  |  |  |  | 43905.86
 |  |  |  |  |  |  |  |  | 4100004827 |  |  |  |  |  |  |  |  |  |  |  |  | 00004 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 4100005597 |  |  |  |  |  |  |  |  |  |  |  |  | 00001 |  |  |  |  |  |  |  |  | 38000
 |  |  |  |  |  |  |  |  | 4100005597 |  |  |  |  |  |  |  |  |  |  |  |  | 00002 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 4100004909 |  |  |  |  |  |  |  |  |  |  |  |  | 00001 |  |  |  |  |  |  |  |  | 150171.13
 |  |  |  |  |  |  |  |  | 4100004909 |  |  |  |  |  |  |  |  |  |  |  |  | 00002 |  |  |  |  |  |  |  |  | 3411.07
 |  |  |  |  |  |  |  |  | 4100004828 |  |  |  |  |  |  |  |  |  |  |  |  | 00001 |  |  |  |  |  |  |  |  | 147628.51
 |  |  |  |  |  |  |  |  | 4100004828 |  |  |  |  |  |  |  |  |  |  |  |  | 00002 |  |  |  |  |  |  |  |  | 3849.74
 |  |  |  |  |  |  |  |  | 4100005069 |  |  |  |  |  |  |  |  |  |  |  |  | 00001 |  |  |  |  |  |  |  |  | 108822.07
 |  |  |  |  |  |  |  |  | 4100005069 |  |  |  |  |  |  |  |  |  |  |  |  | 00002 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 4100005070 |  |  |  |  |  |  |  |  |  |  |  |  | 00001 |  |  |  |  |  |  |  |  | 104190.07
 |  |  |  |  |  |  |  |  | 4100005070 |  |  |  |  |  |  |  |  |  |  |  |  | 00002 |  |  |  |  |  |  |  |  | 6120.9
 |  |  |  |  |  |  |  |  | 4100005167 |  |  |  |  |  |  |  |  |  |  |  |  | 00001 |  |  |  |  |  |  |  |  | 137939.14
 |  |  |  |  |  |  |  |  | 4100005167 |  |  |  |  |  |  |  |  |  |  |  |  | 00002 |  |  |  |  |  |  |  |  | 18671.99
 |  |  |  |  |  |  |  |  | 4100005264 |  |  |  |  |  |  |  |  |  |  |  |  | 00001 |  |  |  |  |  |  |  |  | 74493.3
 |  |  |  |  |  |  |  |  | 4100005264 |  |  |  |  |  |  |  |  |  |  |  |  | 00002 |  |  |  |  |  |  |  |  | 13507.68
 |  |  |  |  |  |  |  |  | 4100005406 |  |  |  |  |  |  |  |  |  |  |  |  | 00001 |  |  |  |  |  |  |  |  | 21060
 |  |  |  |  |  |  |  |  | 4100005406 |  |  |  |  |  |  |  |  |  |  |  |  | 00002 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 4100005548 |  |  |  |  |  |  |  |  |  |  |  |  | 00001 |  |  |  |  |  |  |  |  | 18000
 |  |  |  |  |  |  |  |  | 4100005548 |  |  |  |  |  |  |  |  |  |  |  |  | 00002 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | EUR |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | EUR
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | USD |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | USD
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GBP |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GBP
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | USD |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | USD
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TYD |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TYD