{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Feuil1"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Feuil1","index":0,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["Date","Montant",null,"Rechercher le minimum d'une valeur comprise entre deux dates"]
["2018-08-08",15]
["2018-08-08",25,null,"Date de début","2018-08-11"]
["2018-08-08",35,null,"Date de fin","2018-08-14"]
["2018-08-09",45]
["2018-08-10",55,null,"Minimum avec min.si.ens",{"$f":"_xlfn.MINIFS(B2:B14,A2:A14,\">=\"&E3,A2:A14,\"<=\"&E4)","v":65},{"$f":"_xlfn.FORMULATEXT(E6)","v":"=MIN.SI.ENS(B2:B14;A2:A14;\">=\"&E3;A2:A14;\"<=\"&E4)"}]
["2018-08-11",89,null,"Avec la fonction agregat (dernier arg. à 1)",{"$f":"_xlfn.AGGREGATE(15,6,(TabData[Montant])/(TabData[Date]<=ParamDateFin)/(TabData[Date]>=ParamDateDebut),1)","v":65},{"$f":"_xlfn.FORMULATEXT(E7)","v":"=AGREGAT(15;6;(TabData[Montant])/(TabData[Date]<=ParamDateFin)/(TabData[Date]>=ParamDateDebut);1)"}]
["2018-08-12",75,null,"Avec la fonction agregat (dernier arg. à 2)",{"$f":"_xlfn.AGGREGATE(15,6,(TabData[Montant])/(TabData[Date]<=ParamDateFin)/(TabData[Date]>=ParamDateDebut),2)","v":75},{"$f":"_xlfn.FORMULATEXT(E8)","v":"=AGREGAT(15;6;(TabData[Montant])/(TabData[Date]<=ParamDateFin)/(TabData[Date]>=ParamDateDebut);2)"}]
["2018-08-13",65]
["2018-08-14",78]
["2018-08-15",45]
["2018-08-16",55]
["2018-08-17",45]
["2018-08-18",135]