{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Liste","Achats","Ventes","Nbre jours","Poss Tot","Inter","Récap","Graphique"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"Liste","index":0,"n_rows":27,"n_cols":5,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
["Société","Date","Nombre\nacheté","Nombre\nvendu","Solde\nnombre"]
["Bidule","2017-01-10",10,null,{"$f":"C2","v":10}]
["Chose","2017-04-27",5,null,{"$f":"C3","v":5}]
["Machin","2018-09-02",26,null,26]
["Tatol","2018-12-15",4,null,4]
["Tasle","2019-03-01",13,null,13]
["Machin","2019-05-17",null,{"$f":"C4","v":26},{"$f":"C4-D7","v":0}]
["Chose","2020-09-23",14,null,{"$f":"E3+C8","v":19}]
["Bidule","2020-11-01",null,{"$f":"E2","v":10},{"$f":"E2-D9","v":0}]
["Bidule","2020-11-02",12,null,{"$f":"C10","v":12}]
["Bidule","2021-03-29",null,9,{"$f":"E10-D11","v":3}]
["Chose","2021-06-22",null,19,{"$f":"E8-D12","v":0}]
["Tatol","2022-01-17",2,null,{"$f":"E5+C13","v":6}]
["Machin","2022-05-04",8,null,{"$f":"C14","v":8}]
["Schoups","2022-07-06",4,null,{"$f":"Tableau1[[#This Row],[Nombre\nacheté]]","v":4}]
["Schoups","2022-07-06",null,4,{"$f":"E15-Tableau1[[#This Row],[Nombre\nvendu]]","v":0}]
["Klary","2022-09-26",13,null,{"$f":"Tableau1[[#This Row],[Nombre\nacheté]]","v":13}]
["Shmorgul","2022-10-03",6,null,{"$f":"Tableau1[[#This Row],[Nombre\nacheté]]","v":6}]
["Plastoc","2022-10-12",60,null,{"$f":"Tableau1[[#This Row],[Nombre\nacheté]]","v":60}]
["Plastoc","2022-10-12",null,{"$f":"E19","v":60},{"$f":"E19-Tableau1[[#This Row],[Nombre\nvendu]]","v":0}]
["Plastoc","2022-10-12",19,null,{"$f":"Tableau1[[#This Row],[Nombre\nacheté]]","v":19}]
["Plastoc","2022-10-12",null,{"$f":"E21","v":19},{"$f":"E21-Tableau1[[#This Row],[Nombre\nvendu]]","v":0}]
["Plastoc","2022-10-12",22,null,{"$f":"Tableau1[[#This Row],[Nombre\nacheté]]","v":22}]
["Plastoc","2022-10-13",null,{"$f":"E23","v":22},{"$f":"E23-Tableau1[[#This Row],[Nombre\nvendu]]","v":0}]
["Plastoc","2022-10-13",15,null,{"$f":"Tableau1[[#This Row],[Nombre\nacheté]]","v":15}]
["Plastoc","2022-10-16",null,12,{"$f":"E25-Tableau1[[#This Row],[Nombre\nvendu]]","v":3}]
["Schoups","2022-10-20",5,null,{"$f":"Tableau1[[#This Row],[Nombre\nacheté]]","v":5}]

{"sheet":"Achats","index":1,"n_rows":10,"n_cols":8,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Achats","1","2","3","4","5"]
[{"$f":"INDEX(Tableau1[Société],MATCH(0,COUNTIF($A$1:A1,Tableau1[Société]),0))","v":"Bidule"},{"$f":"SMALL((Tableau1[Société]=$A2)*(Tableau1[Date]),COUNTA(Tableau1[Société])-COUNTIF(Tableau1[Société],$A2)+1)","v":"2017-01-10"},{"$f":"IFERROR(SMALL((Tableau1[Société]=$A2)*(Tableau1[Date])*(Tableau1[Date]>Ventes!B2),COUNTA(Tableau1[Société])-COUNTIFS(Tableau1[Société],$A2,Tableau1[Date],\">\"&Ventes!B2)+1),\"\")","v":"2020-11-02"},{"$f":"IFERROR(SMALL((Tableau1[Société]=$A2)*(Tableau1[Date])*(Tableau1[Date]>Ventes!C2),COUNTA(Tableau1[Société])-COUNTIFS(Tableau1[Société],$A2,Tableau1[Date],\">\"&Ventes!C2)+1),\"\")","v":""},{"$f":"IFERROR(SMALL((Tableau1[Société]=$A2)*(Tableau1[Date])*(Tableau1[Date]>Ventes!D2),COUNTA(Tableau1[Société])-COUNTIFS(Tableau1[Société],$A2,Tableau1[Date],\">\"&Ventes!D2)+1),\"\")","v":""},{"$f":"IFERROR(SMALL((Tableau1[Société]=$A2)*(Tableau1[Date])*(Tableau1[Date]>Ventes!E2),COUNTA(Tableau1[Société])-COUNTIFS(Tableau1[Société],$A2,Tableau1[Date],\">\"&Ventes!E2)+1),\"\")","v":""}]
[{"$f":"INDEX(Tableau1[Société],MATCH(0,COUNTIF($A$1:A2,Tableau1[Société]),0))","v":"Chose"},{"$f":"SMALL((Tableau1[Société]=$A3)*(Tableau1[Date]),COUNTA(Tableau1[Société])-COUNTIF(Tableau1[Société],$A3)+1)","v":"2017-04-27"},{"$f":"IFERROR(SMALL((Tableau1[Société]=$A3)*(Tableau1[Date])*(Tableau1[Date]>Ventes!B3),COUNTA(Tableau1[Société])-COUNTIFS(Tableau1[Société],$A3,Tableau1[Date],\">\"&Ventes!B3)+1),\"\")","v":""},{"$f":"IFERROR(SMALL((Tableau1[Société]=$A3)*(Tableau1[Date])*(Tableau1[Date]>Ventes!C3),COUNTA(Tableau1[Société])-COUNTIFS(Tableau1[Société],$A3,Tableau1[Date],\">\"&Ventes!C3)+1),\"\")","v":""},{"$f":"IFERROR(SMALL((Tableau1[Société]=$A3)*(Tableau1[Date])*(Tableau1[Date]>Ventes!D3),COUNTA(Tableau1[Société])-COUNTIFS(Tableau1[Société],$A3,Tableau1[Date],\">\"&Ventes!D3)+1),\"\")","v":""},{"$f":"IFERROR(SMALL((Tableau1[Société]=$A3)*(Tableau1[Date])*(Tableau1[Date]>Ventes!E3),COUNTA(Tableau1[Société])-COUNTIFS(Tableau1[Société],$A3,Tableau1[Date],\">\"&Ventes!E3)+1),\"\")","v":""}]
[{"$f":"INDEX(Tableau1[Société],MATCH(0,COUNTIF($A$1:A3,Tableau1[Société]),0))","v":"Machin"},{"$f":"SMALL((Tableau1[Société]=$A4)*(Tableau1[Date]),COUNTA(Tableau1[Société])-COUNTIF(Tableau1[Société],$A4)+1)","v":"2018-09-02"},{"$f":"IFERROR(SMALL((Tableau1[Société]=$A4)*(Tableau1[Date])*(Tableau1[Date]>Ventes!B4),COUNTA(Tableau1[Société])-COUNTIFS(Tableau1[Société],$A4,Tableau1[Date],\">\"&Ventes!B4)+1),\"\")","v":"2022-05-04"},{"$f":"IFERROR(SMALL((Tableau1[Société]=$A4)*(Tableau1[Date])*(Tableau1[Date]>Ventes!C4),COUNTA(Tableau1[Société])-COUNTIFS(Tableau1[Société],$A4,Tableau1[Date],\">\"&Ventes!C4)+1),\"\")","v":""},{"$f":"IFERROR(SMALL((Tableau1[Société]=$A4)*(Tableau1[Date])*(Tableau1[Date]>Ventes!D4),COUNTA(Tableau1[Société])-COUNTIFS(Tableau1[Société],$A4,Tableau1[Date],\">\"&Ventes!D4)+1),\"\")","v":""},{"$f":"IFERROR(SMALL((Tableau1[Société]=$A4)*(Tableau1[Date])*(Tableau1[Date]>Ventes!E4),COUNTA(Tableau1[Société])-COUNTIFS(Tableau1[Société],$A4,Tableau1[Date],\">\"&Ventes!E4)+1),\"\")","v":""}]
[{"$f":"INDEX(Tableau1[Société],MATCH(0,COUNTIF($A$1:A4,Tableau1[Société]),0))","v":"Tatol"},{"$f":"SMALL((Tableau1[Société]=$A5)*(Tableau1[Date]),COUNTA(Tableau1[Société])-COUNTIF(Tableau1[Société],$A5)+1)","v":"2018-12-15"},{"$f":"IFERROR(SMALL((Tableau1[Société]=$A5)*(Tableau1[Date])*(Tableau1[Date]>Ventes!B5),COUNTA(Tableau1[Société])-COUNTIFS(Tableau1[Société],$A5,Tableau1[Date],\">\"&Ventes!B5)+1),\"\")","v":""},{"$f":"IFERROR(SMALL((Tableau1[Société]=$A5)*(Tableau1[Date])*(Tableau1[Date]>Ventes!C5),COUNTA(Tableau1[Société])-COUNTIFS(Tableau1[Société],$A5,Tableau1[Date],\">\"&Ventes!C5)+1),\"\")","v":""},{"$f":"IFERROR(SMALL((Tableau1[Société]=$A5)*(Tableau1[Date])*(Tableau1[Date]>Ventes!D5),COUNTA(Tableau1[Société])-COUNTIFS(Tableau1[Société],$A5,Tableau1[Date],\">\"&Ventes!D5)+1),\"\")","v":""},{"$f":"IFERROR(SMALL((Tableau1[Société]=$A5)*(Tableau1[Date])*(Tableau1[Date]>Ventes!E5),COUNTA(Tableau1[Société])-COUNTIFS(Tableau1[Société],$A5,Tableau1[Date],\">\"&Ventes!E5)+1),\"\")","v":""}]
[{"$f":"INDEX(Tableau1[Société],MATCH(0,COUNTIF($A$1:A5,Tableau1[Société]),0))","v":"Tasle"},{"$f":"SMALL((Tableau1[Société]=$A6)*(Tableau1[Date]),COUNTA(Tableau1[Société])-COUNTIF(Tableau1[Société],$A6)+1)","v":"2019-03-01"},{"$f":"IFERROR(SMALL((Tableau1[Société]=$A6)*(Tableau1[Date])*(Tableau1[Date]>Ventes!B6),COUNTA(Tableau1[Société])-COUNTIFS(Tableau1[Société],$A6,Tableau1[Date],\">\"&Ventes!B6)+1),\"\")","v":""},{"$f":"IFERROR(SMALL((Tableau1[Société]=$A6)*(Tableau1[Date])*(Tableau1[Date]>Ventes!C6),COUNTA(Tableau1[Société])-COUNTIFS(Tableau1[Société],$A6,Tableau1[Date],\">\"&Ventes!C6)+1),\"\")","v":""},{"$f":"IFERROR(SMALL((Tableau1[Société]=$A6)*(Tableau1[Date])*(Tableau1[Date]>Ventes!D6),COUNTA(Tableau1[Société])-COUNTIFS(Tableau1[Société],$A6,Tableau1[Date],\">\"&Ventes!D6)+1),\"\")","v":""},{"$f":"IFERROR(SMALL((Tableau1[Société]=$A6)*(Tableau1[Date])*(Tableau1[Date]>Ventes!E6),COUNTA(Tableau1[Société])-COUNTIFS(Tableau1[Société],$A6,Tableau1[Date],\">\"&Ventes!E6)+1),\"\")","v":""}]
[{"$f":"INDEX(Tableau1[Société],MATCH(0,COUNTIF($A$1:A6,Tableau1[Société]),0))","v":"Schoups"},{"$f":"SMALL((Tableau1[Société]=$A7)*(Tableau1[Date]),COUNTA(Tableau1[Société])-COUNTIF(Tableau1[Société],$A7)+1)","v":"2022-07-06"},{"$f":"IFERROR(SMALL((Tableau1[Société]=$A7)*(Tableau1[Date])*(Tableau1[Date]>Ventes!B7),COUNTA(Tableau1[Société])-COUNTIFS(Tableau1[Société],$A7,Tableau1[Date],\">\"&Ventes!B7)+1),\"\")","v":"2022-10-20"},{"$f":"IFERROR(SMALL((Tableau1[Société]=$A7)*(Tableau1[Date])*(Tableau1[Date]>Ventes!C7),COUNTA(Tableau1[Société])-COUNTIFS(Tableau1[Société],$A7,Tableau1[Date],\">\"&Ventes!C7)+1),\"\")","v":""},{"$f":"IFERROR(SMALL((Tableau1[Société]=$A7)*(Tableau1[Date])*(Tableau1[Date]>Ventes!D7),COUNTA(Tableau1[Société])-COUNTIFS(Tableau1[Société],$A7,Tableau1[Date],\">\"&Ventes!D7)+1),\"\")","v":""},{"$f":"IFERROR(SMALL((Tableau1[Société]=$A7)*(Tableau1[Date])*(Tableau1[Date]>Ventes!E7),COUNTA(Tableau1[Société])-COUNTIFS(Tableau1[Société],$A7,Tableau1[Date],\">\"&Ventes!E7)+1),\"\")","v":""}]
[{"$f":"INDEX(Tableau1[Société],MATCH(0,COUNTIF($A$1:A7,Tableau1[Société]),0))","v":"Klary"},{"$f":"SMALL((Tableau1[Société]=$A8)*(Tableau1[Date]),COUNTA(Tableau1[Société])-COUNTIF(Tableau1[Société],$A8)+1)","v":"2022-09-26"},{"$f":"IFERROR(SMALL((Tableau1[Société]=$A8)*(Tableau1[Date])*(Tableau1[Date]>Ventes!B8),COUNTA(Tableau1[Société])-COUNTIFS(Tableau1[Société],$A8,Tableau1[Date],\">\"&Ventes!B8)+1),\"\")","v":""},{"$f":"IFERROR(SMALL((Tableau1[Société]=$A8)*(Tableau1[Date])*(Tableau1[Date]>Ventes!C8),COUNTA(Tableau1[Société])-COUNTIFS(Tableau1[Société],$A8,Tableau1[Date],\">\"&Ventes!C8)+1),\"\")","v":""},{"$f":"IFERROR(SMALL((Tableau1[Société]=$A8)*(Tableau1[Date])*(Tableau1[Date]>Ventes!D8),COUNTA(Tableau1[Société])-COUNTIFS(Tableau1[Société],$A8,Tableau1[Date],\">\"&Ventes!D8)+1),\"\")","v":""},{"$f":"IFERROR(SMALL((Tableau1[Société]=$A8)*(Tableau1[Date])*(Tableau1[Date]>Ventes!E8),COUNTA(Tableau1[Société])-COUNTIFS(Tableau1[Société],$A8,Tableau1[Date],\">\"&Ventes!E8)+1),\"\")","v":""}]
[{"$f":"INDEX(Tableau1[Société],MATCH(0,COUNTIF($A$1:A8,Tableau1[Société]),0))","v":"Shmorgul"},{"$f":"SMALL((Tableau1[Société]=$A9)*(Tableau1[Date]),COUNTA(Tableau1[Société])-COUNTIF(Tableau1[Société],$A9)+1)","v":"2022-10-03"},{"$f":"IFERROR(SMALL((Tableau1[Société]=$A9)*(Tableau1[Date])*(Tableau1[Date]>Ventes!B9),COUNTA(Tableau1[Société])-COUNTIFS(Tableau1[Société],$A9,Tableau1[Date],\">\"&Ventes!B9)+1),\"\")","v":""},{"$f":"IFERROR(SMALL((Tableau1[Société]=$A9)*(Tableau1[Date])*(Tableau1[Date]>Ventes!C9),COUNTA(Tableau1[Société])-COUNTIFS(Tableau1[Société],$A9,Tableau1[Date],\">\"&Ventes!C9)+1),\"\")","v":""},{"$f":"IFERROR(SMALL((Tableau1[Société]=$A9)*(Tableau1[Date])*(Tableau1[Date]>Ventes!D9),COUNTA(Tableau1[Société])-COUNTIFS(Tableau1[Société],$A9,Tableau1[Date],\">\"&Ventes!D9)+1),\"\")","v":""},{"$f":"IFERROR(SMALL((Tableau1[Société]=$A9)*(Tableau1[Date])*(Tableau1[Date]>Ventes!E9),COUNTA(Tableau1[Société])-COUNTIFS(Tableau1[Société],$A9,Tableau1[Date],\">\"&Ventes!E9)+1),\"\")","v":""}]
[{"$f":"INDEX(Tableau1[Société],MATCH(0,COUNTIF($A$1:A9,Tableau1[Société]),0))","v":"Plastoc"},{"$f":"SMALL((Tableau1[Société]=$A10)*(Tableau1[Date]),COUNTA(Tableau1[Société])-COUNTIF(Tableau1[Société],$A10)+1)","v":"2022-10-12"},{"$f":"IFERROR(SMALL((Tableau1[Société]=$A10)*(Tableau1[Date])*(Tableau1[Date]>Ventes!B10),COUNTA(Tableau1[Société])-COUNTIFS(Tableau1[Société],$A10,Tableau1[Date],\">\"&Ventes!B10)+1),\"\")","v":"2022-10-13"},{"$f":"IFERROR(SMALL((Tableau1[Société]=$A10)*(Tableau1[Date])*(Tableau1[Date]>Ventes!C10),COUNTA(Tableau1[Société])-COUNTIFS(Tableau1[Société],$A10,Tableau1[Date],\">\"&Ventes!C10)+1),\"\")","v":"2022-10-13"},{"$f":"IFERROR(SMALL((Tableau1[Société]=$A10)*(Tableau1[Date])*(Tableau1[Date]>Ventes!D10),COUNTA(Tableau1[Société])-COUNTIFS(Tableau1[Société],$A10,Tableau1[Date],\">\"&Ventes!D10)+1),\"\")","v":"2022-10-13"},{"$f":"IFERROR(SMALL((Tableau1[Société]=$A10)*(Tableau1[Date])*(Tableau1[Date]>Ventes!E10),COUNTA(Tableau1[Société])-COUNTIFS(Tableau1[Société],$A10,Tableau1[Date],\">\"&Ventes!E10)+1),\"\")","v":"2022-10-16"},{"$f":"IFERROR(SMALL((Tableau1[Société]=$A10)*(Tableau1[Date])*(Tableau1[Date]>Ventes!F10),COUNTA(Tableau1[Société])-COUNTIFS(Tableau1[Société],$A10,Tableau1[Date],\">\"&Ventes!F10)+1),\"\")","v":""},"=> rectifier formule, C10 doit afficher 12-10-22 et 1 achat en trop, le dernier date du 13-10"]

{"sheet":"Ventes","index":2,"n_rows":10,"n_cols":9,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Ventes","1","2","3","4","5","6"]
[{"$f":"INDEX(Tableau1[Société],MATCH(0,COUNTIF($A$1:A1,Tableau1[Société]),0))","v":"Bidule"},{"$f":"IFERROR(SMALL((Tableau1[Société]=$A2)*(Tableau1[Solde\nnombre]=0)*(Tableau1[Date]),COUNTA(Tableau1[Société])-COUNTIFS(Tableau1[Société],$A2,Tableau1[Solde\nnombre],\"0\" )+B$1),TODAY())","v":"2020-11-01"},{"$f":"IF(B2=TODAY(),\"\",IF(AND(IFERROR(SMALL((Tableau1[Société]=$A2)*(Tableau1[Solde\nnombre]=0)*(Tableau1[Date]),COUNTA(Tableau1[Société])-COUNTIFS(Tableau1[Société],$A2,Tableau1[Solde\nnombre],\"0\")+C$1),\"\")=\"\",LOOKUP(2,1/(Tableau1[Société]=$A2),Tableau1[Solde\nnombre])>0),TODAY(),IFERROR(SMALL((Tableau1[Société]=$A2)*(Tableau1[Solde\nnombre]=0)*(Tableau1[Date]),COUNTA(Tableau1[Société])-COUNTIFS(Tableau1[Société],$A2,Tableau1[Solde\nnombre],\"0\")+C$1),\"\")))","v":"2022-10-25"},{"$f":"IF(C2=\"\",\"\",IF(C2=TODAY(),\"\",IF(AND(IFERROR(SMALL((Tableau1[Société]=$A2)*(Tableau1[Solde\nnombre]=0)*(Tableau1[Date]),COUNTA(Tableau1[Société])-COUNTIFS(Tableau1[Société],$A2,Tableau1[Solde\nnombre],\"0\")+C$1),\"\")=\"\",LOOKUP(2,1/(Tableau1[Société]=$A2),Tableau1[Solde\nnombre])>0),TODAY(),SMALL((Tableau1[Société]=$A2)*(Tableau1[Solde\nnombre]=0)*(Tableau1[Date]),COUNTA(Tableau1[Société])-COUNTIFS(Tableau1[Société],$A2,Tableau1[Solde\nnombre],\"0\")+C$1))))","v":""},{"$f":"IF(D2=\"\",\"\",IF(D2=TODAY(),\"\",IF(AND(IFERROR(SMALL((Tableau1[Société]=$A2)*(Tableau1[Solde\nnombre]=0)*(Tableau1[Date]),COUNTA(Tableau1[Société])-COUNTIFS(Tableau1[Société],$A2,Tableau1[Solde\nnombre],\"0\")+D$1),\"\")=\"\",LOOKUP(2,1/(Tableau1[Société]=$A2),Tableau1[Solde\nnombre])>0),TODAY(),SMALL((Tableau1[Société]=$A2)*(Tableau1[Solde\nnombre]=0)*(Tableau1[Date]),COUNTA(Tableau1[Société])-COUNTIFS(Tableau1[Société],$A2,Tableau1[Solde\nnombre],\"0\")+D$1))))","v":""},{"$f":"IF(E2=\"\",\"\",IF(E2=TODAY(),\"\",IF(AND(IFERROR(SMALL((Tableau1[Société]=$A2)*(Tableau1[Solde\nnombre]=0)*(Tableau1[Date]),COUNTA(Tableau1[Société])-COUNTIFS(Tableau1[Société],$A2,Tableau1[Solde\nnombre],\"0\")+E$1),\"\")=\"\",LOOKUP(2,1/(Tableau1[Société]=$A2),Tableau1[Solde\nnombre])>0),TODAY(),SMALL((Tableau1[Société]=$A2)*(Tableau1[Solde\nnombre]=0)*(Tableau1[Date]),COUNTA(Tableau1[Société])-COUNTIFS(Tableau1[Société],$A2,Tableau1[Solde\nnombre],\"0\")+E$1))))","v":""},{"$f":"IF(F2=\"\",\"\",IF(F2=TODAY(),\"\",IF(AND(IFERROR(SMALL((Tableau1[Société]=$A2)*(Tableau1[Solde\nnombre]=0)*(Tableau1[Date]),COUNTA(Tableau1[Société])-COUNTIFS(Tableau1[Société],$A2,Tableau1[Solde\nnombre],\"0\")+F$1),\"\")=\"\",LOOKUP(2,1/(Tableau1[Société]=$A2),Tableau1[Solde\nnombre])>0),TODAY(),SMALL((Tableau1[Société]=$A2)*(Tableau1[Solde\nnombre]=0)*(Tableau1[Date]),COUNTA(Tableau1[Société])-COUNTIFS(Tableau1[Société],$A2,Tableau1[Solde\nnombre],\"0\")+F$1))))","v":""}]
[{"$f":"INDEX(Tableau1[Société],MATCH(0,COUNTIF($A$1:A2,Tableau1[Société]),0))","v":"Chose"},{"$f":"IFERROR(SMALL((Tableau1[Société]=$A3)*(Tableau1[Solde\nnombre]=0)*(Tableau1[Date]),COUNTA(Tableau1[Société])-COUNTIFS(Tableau1[Société],$A3,Tableau1[Solde\nnombre],\"0\" )+B$1),TODAY())","v":"2021-06-22"},{"$f":"IF(B3=TODAY(),\"\",IF(AND(IFERROR(SMALL((Tableau1[Société]=$A3)*(Tableau1[Solde\nnombre]=0)*(Tableau1[Date]),COUNTA(Tableau1[Société])-COUNTIFS(Tableau1[Société],$A3,Tableau1[Solde\nnombre],\"0\")+C$1),\"\")=\"\",LOOKUP(2,1/(Tableau1[Société]=$A3),Tableau1[Solde\nnombre])>0),TODAY(),IFERROR(SMALL((Tableau1[Société]=$A3)*(Tableau1[Solde\nnombre]=0)*(Tableau1[Date]),COUNTA(Tableau1[Société])-COUNTIFS(Tableau1[Société],$A3,Tableau1[Solde\nnombre],\"0\")+C$1),\"\")))","v":""},{"$f":"IF(C3=\"\",\"\",IF(C3=TODAY(),\"\",IF(AND(IFERROR(SMALL((Tableau1[Société]=$A3)*(Tableau1[Solde\nnombre]=0)*(Tableau1[Date]),COUNTA(Tableau1[Société])-COUNTIFS(Tableau1[Société],$A3,Tableau1[Solde\nnombre],\"0\")+C$1),\"\")=\"\",LOOKUP(2,1/(Tableau1[Société]=$A3),Tableau1[Solde\nnombre])>0),TODAY(),SMALL((Tableau1[Société]=$A3)*(Tableau1[Solde\nnombre]=0)*(Tableau1[Date]),COUNTA(Tableau1[Société])-COUNTIFS(Tableau1[Société],$A3,Tableau1[Solde\nnombre],\"0\")+C$1))))","v":""},{"$f":"IF(D3=\"\",\"\",IF(D3=TODAY(),\"\",IF(AND(IFERROR(SMALL((Tableau1[Société]=$A3)*(Tableau1[Solde\nnombre]=0)*(Tableau1[Date]),COUNTA(Tableau1[Société])-COUNTIFS(Tableau1[Société],$A3,Tableau1[Solde\nnombre],\"0\")+D$1),\"\")=\"\",LOOKUP(2,1/(Tableau1[Société]=$A3),Tableau1[Solde\nnombre])>0),TODAY(),SMALL((Tableau1[Société]=$A3)*(Tableau1[Solde\nnombre]=0)*(Tableau1[Date]),COUNTA(Tableau1[Société])-COUNTIFS(Tableau1[Société],$A3,Tableau1[Solde\nnombre],\"0\")+D$1))))","v":""},{"$f":"IF(E3=\"\",\"\",IF(E3=TODAY(),\"\",IF(AND(IFERROR(SMALL((Tableau1[Société]=$A3)*(Tableau1[Solde\nnombre]=0)*(Tableau1[Date]),COUNTA(Tableau1[Société])-COUNTIFS(Tableau1[Société],$A3,Tableau1[Solde\nnombre],\"0\")+E$1),\"\")=\"\",LOOKUP(2,1/(Tableau1[Société]=$A3),Tableau1[Solde\nnombre])>0),TODAY(),SMALL((Tableau1[Société]=$A3)*(Tableau1[Solde\nnombre]=0)*(Tableau1[Date]),COUNTA(Tableau1[Société])-COUNTIFS(Tableau1[Société],$A3,Tableau1[Solde\nnombre],\"0\")+E$1))))","v":""},{"$f":"IF(F3=\"\",\"\",IF(F3=TODAY(),\"\",IF(AND(IFERROR(SMALL((Tableau1[Société]=$A3)*(Tableau1[Solde\nnombre]=0)*(Tableau1[Date]),COUNTA(Tableau1[Société])-COUNTIFS(Tableau1[Société],$A3,Tableau1[Solde\nnombre],\"0\")+F$1),\"\")=\"\",LOOKUP(2,1/(Tableau1[Société]=$A3),Tableau1[Solde\nnombre])>0),TODAY(),SMALL((Tableau1[Société]=$A3)*(Tableau1[Solde\nnombre]=0)*(Tableau1[Date]),COUNTA(Tableau1[Société])-COUNTIFS(Tableau1[Société],$A3,Tableau1[Solde\nnombre],\"0\")+F$1))))","v":""}]
[{"$f":"INDEX(Tableau1[Société],MATCH(0,COUNTIF($A$1:A3,Tableau1[Société]),0))","v":"Machin"},{"$f":"IFERROR(SMALL((Tableau1[Société]=$A4)*(Tableau1[Solde\nnombre]=0)*(Tableau1[Date]),COUNTA(Tableau1[Société])-COUNTIFS(Tableau1[Société],$A4,Tableau1[Solde\nnombre],\"0\" )+B$1),TODAY())","v":"2019-05-17"},{"$f":"IF(B4=TODAY(),\"\",IF(AND(IFERROR(SMALL((Tableau1[Société]=$A4)*(Tableau1[Solde\nnombre]=0)*(Tableau1[Date]),COUNTA(Tableau1[Société])-COUNTIFS(Tableau1[Société],$A4,Tableau1[Solde\nnombre],\"0\")+C$1),\"\")=\"\",LOOKUP(2,1/(Tableau1[Société]=$A4),Tableau1[Solde\nnombre])>0),TODAY(),SMALL((Tableau1[Société]=$A4)*(Tableau1[Solde\nnombre]=0)*(Tableau1[Date]),COUNTA(Tableau1[Société])-COUNTIFS(Tableau1[Société],$A4,Tableau1[Solde\nnombre],\"0\")+C$1)))","v":"2022-10-25"},{"$f":"IF(C4=\"\",\"\",IF(C4=TODAY(),\"\",IF(AND(IFERROR(SMALL((Tableau1[Société]=$A4)*(Tableau1[Solde\nnombre]=0)*(Tableau1[Date]),COUNTA(Tableau1[Société])-COUNTIFS(Tableau1[Société],$A4,Tableau1[Solde\nnombre],\"0\")+C$1),\"\")=\"\",LOOKUP(2,1/(Tableau1[Société]=$A4),Tableau1[Solde\nnombre])>0),TODAY(),SMALL((Tableau1[Société]=$A4)*(Tableau1[Solde\nnombre]=0)*(Tableau1[Date]),COUNTA(Tableau1[Société])-COUNTIFS(Tableau1[Société],$A4,Tableau1[Solde\nnombre],\"0\")+C$1))))","v":""},{"$f":"IF(D4=\"\",\"\",IF(D4=TODAY(),\"\",IF(AND(IFERROR(SMALL((Tableau1[Société]=$A4)*(Tableau1[Solde\nnombre]=0)*(Tableau1[Date]),COUNTA(Tableau1[Société])-COUNTIFS(Tableau1[Société],$A4,Tableau1[Solde\nnombre],\"0\")+D$1),\"\")=\"\",LOOKUP(2,1/(Tableau1[Société]=$A4),Tableau1[Solde\nnombre])>0),TODAY(),SMALL((Tableau1[Société]=$A4)*(Tableau1[Solde\nnombre]=0)*(Tableau1[Date]),COUNTA(Tableau1[Société])-COUNTIFS(Tableau1[Société],$A4,Tableau1[Solde\nnombre],\"0\")+D$1))))","v":""},{"$f":"IF(E4=\"\",\"\",IF(E4=TODAY(),\"\",IF(AND(IFERROR(SMALL((Tableau1[Société]=$A4)*(Tableau1[Solde\nnombre]=0)*(Tableau1[Date]),COUNTA(Tableau1[Société])-COUNTIFS(Tableau1[Société],$A4,Tableau1[Solde\nnombre],\"0\")+E$1),\"\")=\"\",LOOKUP(2,1/(Tableau1[Société]=$A4),Tableau1[Solde\nnombre])>0),TODAY(),SMALL((Tableau1[Société]=$A4)*(Tableau1[Solde\nnombre]=0)*(Tableau1[Date]),COUNTA(Tableau1[Société])-COUNTIFS(Tableau1[Société],$A4,Tableau1[Solde\nnombre],\"0\")+E$1))))","v":""},{"$f":"IF(F4=\"\",\"\",IF(F4=TODAY(),\"\",IF(AND(IFERROR(SMALL((Tableau1[Société]=$A4)*(Tableau1[Solde\nnombre]=0)*(Tableau1[Date]),COUNTA(Tableau1[Société])-COUNTIFS(Tableau1[Société],$A4,Tableau1[Solde\nnombre],\"0\")+F$1),\"\")=\"\",LOOKUP(2,1/(Tableau1[Société]=$A4),Tableau1[Solde\nnombre])>0),TODAY(),SMALL((Tableau1[Société]=$A4)*(Tableau1[Solde\nnombre]=0)*(Tableau1[Date]),COUNTA(Tableau1[Société])-COUNTIFS(Tableau1[Société],$A4,Tableau1[Solde\nnombre],\"0\")+F$1))))","v":""}]
[{"$f":"INDEX(Tableau1[Société],MATCH(0,COUNTIF($A$1:A4,Tableau1[Société]),0))","v":"Tatol"},{"$f":"IFERROR(SMALL((Tableau1[Société]=$A5)*(Tableau1[Solde\nnombre]=0)*(Tableau1[Date]),COUNTA(Tableau1[Société])-COUNTIFS(Tableau1[Société],$A5,Tableau1[Solde\nnombre],\"0\" )+B$1),TODAY())","v":"2022-10-25"},{"$f":"IF(B5=TODAY(),\"\",IF(AND(IFERROR(SMALL((Tableau1[Société]=$A5)*(Tableau1[Solde\nnombre]=0)*(Tableau1[Date]),COUNTA(Tableau1[Société])-COUNTIFS(Tableau1[Société],$A5,Tableau1[Solde\nnombre],\"0\")+C$1),\"\")=\"\",LOOKUP(2,1/(Tableau1[Société]=$A5),Tableau1[Solde\nnombre])>0),TODAY(),SMALL((Tableau1[Société]=$A5)*(Tableau1[Solde\nnombre]=0)*(Tableau1[Date]),COUNTA(Tableau1[Société])-COUNTIFS(Tableau1[Société],$A5,Tableau1[Solde\nnombre],\"0\")+C$1)))","v":""},{"$f":"IF(C5=\"\",\"\",IF(C5=TODAY(),\"\",IF(AND(IFERROR(SMALL((Tableau1[Société]=$A5)*(Tableau1[Solde\nnombre]=0)*(Tableau1[Date]),COUNTA(Tableau1[Société])-COUNTIFS(Tableau1[Société],$A5,Tableau1[Solde\nnombre],\"0\")+C$1),\"\")=\"\",LOOKUP(2,1/(Tableau1[Société]=$A5),Tableau1[Solde\nnombre])>0),TODAY(),SMALL((Tableau1[Société]=$A5)*(Tableau1[Solde\nnombre]=0)*(Tableau1[Date]),COUNTA(Tableau1[Société])-COUNTIFS(Tableau1[Société],$A5,Tableau1[Solde\nnombre],\"0\")+C$1))))","v":""},{"$f":"IF(D5=\"\",\"\",IF(D5=TODAY(),\"\",IF(AND(IFERROR(SMALL((Tableau1[Société]=$A5)*(Tableau1[Solde\nnombre]=0)*(Tableau1[Date]),COUNTA(Tableau1[Société])-COUNTIFS(Tableau1[Société],$A5,Tableau1[Solde\nnombre],\"0\")+D$1),\"\")=\"\",LOOKUP(2,1/(Tableau1[Société]=$A5),Tableau1[Solde\nnombre])>0),TODAY(),SMALL((Tableau1[Société]=$A5)*(Tableau1[Solde\nnombre]=0)*(Tableau1[Date]),COUNTA(Tableau1[Société])-COUNTIFS(Tableau1[Société],$A5,Tableau1[Solde\nnombre],\"0\")+D$1))))","v":""},{"$f":"IF(E5=\"\",\"\",IF(E5=TODAY(),\"\",IF(AND(IFERROR(SMALL((Tableau1[Société]=$A5)*(Tableau1[Solde\nnombre]=0)*(Tableau1[Date]),COUNTA(Tableau1[Société])-COUNTIFS(Tableau1[Société],$A5,Tableau1[Solde\nnombre],\"0\")+E$1),\"\")=\"\",LOOKUP(2,1/(Tableau1[Société]=$A5),Tableau1[Solde\nnombre])>0),TODAY(),SMALL((Tableau1[Société]=$A5)*(Tableau1[Solde\nnombre]=0)*(Tableau1[Date]),COUNTA(Tableau1[Société])-COUNTIFS(Tableau1[Société],$A5,Tableau1[Solde\nnombre],\"0\")+E$1))))","v":""},{"$f":"IF(F5=\"\",\"\",IF(F5=TODAY(),\"\",IF(AND(IFERROR(SMALL((Tableau1[Société]=$A5)*(Tableau1[Solde\nnombre]=0)*(Tableau1[Date]),COUNTA(Tableau1[Société])-COUNTIFS(Tableau1[Société],$A5,Tableau1[Solde\nnombre],\"0\")+F$1),\"\")=\"\",LOOKUP(2,1/(Tableau1[Société]=$A5),Tableau1[Solde\nnombre])>0),TODAY(),SMALL((Tableau1[Société]=$A5)*(Tableau1[Solde\nnombre]=0)*(Tableau1[Date]),COUNTA(Tableau1[Société])-COUNTIFS(Tableau1[Société],$A5,Tableau1[Solde\nnombre],\"0\")+F$1))))","v":""}]
[{"$f":"INDEX(Tableau1[Société],MATCH(0,COUNTIF($A$1:A5,Tableau1[Société]),0))","v":"Tasle"},{"$f":"IFERROR(SMALL((Tableau1[Société]=$A6)*(Tableau1[Solde\nnombre]=0)*(Tableau1[Date]),COUNTA(Tableau1[Société])-COUNTIFS(Tableau1[Société],$A6,Tableau1[Solde\nnombre],\"0\" )+B$1),TODAY())","v":"2022-10-25"},{"$f":"IF(B6=TODAY(),\"\",IF(AND(IFERROR(SMALL((Tableau1[Société]=$A6)*(Tableau1[Solde\nnombre]=0)*(Tableau1[Date]),COUNTA(Tableau1[Société])-COUNTIFS(Tableau1[Société],$A6,Tableau1[Solde\nnombre],\"0\")+C$1),\"\")=\"\",LOOKUP(2,1/(Tableau1[Société]=$A6),Tableau1[Solde\nnombre])>0),TODAY(),SMALL((Tableau1[Société]=$A6)*(Tableau1[Solde\nnombre]=0)*(Tableau1[Date]),COUNTA(Tableau1[Société])-COUNTIFS(Tableau1[Société],$A6,Tableau1[Solde\nnombre],\"0\")+C$1)))","v":""},{"$f":"IF(C6=\"\",\"\",IF(C6=TODAY(),\"\",IF(AND(IFERROR(SMALL((Tableau1[Société]=$A6)*(Tableau1[Solde\nnombre]=0)*(Tableau1[Date]),COUNTA(Tableau1[Société])-COUNTIFS(Tableau1[Société],$A6,Tableau1[Solde\nnombre],\"0\")+C$1),\"\")=\"\",LOOKUP(2,1/(Tableau1[Société]=$A6),Tableau1[Solde\nnombre])>0),TODAY(),SMALL((Tableau1[Société]=$A6)*(Tableau1[Solde\nnombre]=0)*(Tableau1[Date]),COUNTA(Tableau1[Société])-COUNTIFS(Tableau1[Société],$A6,Tableau1[Solde\nnombre],\"0\")+C$1))))","v":""},{"$f":"IF(D6=\"\",\"\",IF(D6=TODAY(),\"\",IF(AND(IFERROR(SMALL((Tableau1[Société]=$A6)*(Tableau1[Solde\nnombre]=0)*(Tableau1[Date]),COUNTA(Tableau1[Société])-COUNTIFS(Tableau1[Société],$A6,Tableau1[Solde\nnombre],\"0\")+D$1),\"\")=\"\",LOOKUP(2,1/(Tableau1[Société]=$A6),Tableau1[Solde\nnombre])>0),TODAY(),SMALL((Tableau1[Société]=$A6)*(Tableau1[Solde\nnombre]=0)*(Tableau1[Date]),COUNTA(Tableau1[Société])-COUNTIFS(Tableau1[Société],$A6,Tableau1[Solde\nnombre],\"0\")+D$1))))","v":""},{"$f":"IF(E6=\"\",\"\",IF(E6=TODAY(),\"\",IF(AND(IFERROR(SMALL((Tableau1[Société]=$A6)*(Tableau1[Solde\nnombre]=0)*(Tableau1[Date]),COUNTA(Tableau1[Société])-COUNTIFS(Tableau1[Société],$A6,Tableau1[Solde\nnombre],\"0\")+E$1),\"\")=\"\",LOOKUP(2,1/(Tableau1[Société]=$A6),Tableau1[Solde\nnombre])>0),TODAY(),SMALL((Tableau1[Société]=$A6)*(Tableau1[Solde\nnombre]=0)*(Tableau1[Date]),COUNTA(Tableau1[Société])-COUNTIFS(Tableau1[Société],$A6,Tableau1[Solde\nnombre],\"0\")+E$1))))","v":""},{"$f":"IF(F6=\"\",\"\",IF(F6=TODAY(),\"\",IF(AND(IFERROR(SMALL((Tableau1[Société]=$A6)*(Tableau1[Solde\nnombre]=0)*(Tableau1[Date]),COUNTA(Tableau1[Société])-COUNTIFS(Tableau1[Société],$A6,Tableau1[Solde\nnombre],\"0\")+F$1),\"\")=\"\",LOOKUP(2,1/(Tableau1[Société]=$A6),Tableau1[Solde\nnombre])>0),TODAY(),SMALL((Tableau1[Société]=$A6)*(Tableau1[Solde\nnombre]=0)*(Tableau1[Date]),COUNTA(Tableau1[Société])-COUNTIFS(Tableau1[Société],$A6,Tableau1[Solde\nnombre],\"0\")+F$1))))","v":""}]
[{"$f":"INDEX(Tableau1[Société],MATCH(0,COUNTIF($A$1:A6,Tableau1[Société]),0))","v":"Schoups"},{"$f":"IFERROR(SMALL((Tableau1[Société]=$A7)*(Tableau1[Solde\nnombre]=0)*(Tableau1[Date]),COUNTA(Tableau1[Société])-COUNTIFS(Tableau1[Société],$A7,Tableau1[Solde\nnombre],\"0\" )+B$1),TODAY())","v":"2022-07-06"},{"$f":"IF(B7=TODAY(),\"\",IF(AND(IFERROR(SMALL((Tableau1[Société]=$A7)*(Tableau1[Solde\nnombre]=0)*(Tableau1[Date]),COUNTA(Tableau1[Société])-COUNTIFS(Tableau1[Société],$A7,Tableau1[Solde\nnombre],\"0\")+C$1),\"\")=\"\",LOOKUP(2,1/(Tableau1[Société]=$A7),Tableau1[Solde\nnombre])>0),TODAY(),SMALL((Tableau1[Société]=$A7)*(Tableau1[Solde\nnombre]=0)*(Tableau1[Date]),COUNTA(Tableau1[Société])-COUNTIFS(Tableau1[Société],$A7,Tableau1[Solde\nnombre],\"0\")+C$1)))","v":"2022-10-25"},{"$f":"IF(C7=\"\",\"\",IF(C7=TODAY(),\"\",IF(AND(IFERROR(SMALL((Tableau1[Société]=$A7)*(Tableau1[Solde\nnombre]=0)*(Tableau1[Date]),COUNTA(Tableau1[Société])-COUNTIFS(Tableau1[Société],$A7,Tableau1[Solde\nnombre],\"0\")+C$1),\"\")=\"\",LOOKUP(2,1/(Tableau1[Société]=$A7),Tableau1[Solde\nnombre])>0),TODAY(),SMALL((Tableau1[Société]=$A7)*(Tableau1[Solde\nnombre]=0)*(Tableau1[Date]),COUNTA(Tableau1[Société])-COUNTIFS(Tableau1[Société],$A7,Tableau1[Solde\nnombre],\"0\")+C$1))))","v":""},{"$f":"IF(D7=\"\",\"\",IF(D7=TODAY(),\"\",IF(AND(IFERROR(SMALL((Tableau1[Société]=$A7)*(Tableau1[Solde\nnombre]=0)*(Tableau1[Date]),COUNTA(Tableau1[Société])-COUNTIFS(Tableau1[Société],$A7,Tableau1[Solde\nnombre],\"0\")+D$1),\"\")=\"\",LOOKUP(2,1/(Tableau1[Société]=$A7),Tableau1[Solde\nnombre])>0),TODAY(),SMALL((Tableau1[Société]=$A7)*(Tableau1[Solde\nnombre]=0)*(Tableau1[Date]),COUNTA(Tableau1[Société])-COUNTIFS(Tableau1[Société],$A7,Tableau1[Solde\nnombre],\"0\")+D$1))))","v":""},{"$f":"IF(E7=\"\",\"\",IF(E7=TODAY(),\"\",IF(AND(IFERROR(SMALL((Tableau1[Société]=$A7)*(Tableau1[Solde\nnombre]=0)*(Tableau1[Date]),COUNTA(Tableau1[Société])-COUNTIFS(Tableau1[Société],$A7,Tableau1[Solde\nnombre],\"0\")+E$1),\"\")=\"\",LOOKUP(2,1/(Tableau1[Société]=$A7),Tableau1[Solde\nnombre])>0),TODAY(),SMALL((Tableau1[Société]=$A7)*(Tableau1[Solde\nnombre]=0)*(Tableau1[Date]),COUNTA(Tableau1[Société])-COUNTIFS(Tableau1[Société],$A7,Tableau1[Solde\nnombre],\"0\")+E$1))))","v":""},{"$f":"IF(F7=\"\",\"\",IF(F7=TODAY(),\"\",IF(AND(IFERROR(SMALL((Tableau1[Société]=$A7)*(Tableau1[Solde\nnombre]=0)*(Tableau1[Date]),COUNTA(Tableau1[Société])-COUNTIFS(Tableau1[Société],$A7,Tableau1[Solde\nnombre],\"0\")+F$1),\"\")=\"\",LOOKUP(2,1/(Tableau1[Société]=$A7),Tableau1[Solde\nnombre])>0),TODAY(),SMALL((Tableau1[Société]=$A7)*(Tableau1[Solde\nnombre]=0)*(Tableau1[Date]),COUNTA(Tableau1[Société])-COUNTIFS(Tableau1[Société],$A7,Tableau1[Solde\nnombre],\"0\")+F$1))))","v":""}]
[{"$f":"INDEX(Tableau1[Société],MATCH(0,COUNTIF($A$1:A7,Tableau1[Société]),0))","v":"Klary"},{"$f":"IFERROR(SMALL((Tableau1[Société]=$A8)*(Tableau1[Solde\nnombre]=0)*(Tableau1[Date]),COUNTA(Tableau1[Société])-COUNTIFS(Tableau1[Société],$A8,Tableau1[Solde\nnombre],\"0\" )+B$1),TODAY())","v":"2022-10-25"},{"$f":"IF(B8=TODAY(),\"\",IF(AND(IFERROR(SMALL((Tableau1[Société]=$A8)*(Tableau1[Solde\nnombre]=0)*(Tableau1[Date]),COUNTA(Tableau1[Société])-COUNTIFS(Tableau1[Société],$A8,Tableau1[Solde\nnombre],\"0\")+C$1),\"\")=\"\",LOOKUP(2,1/(Tableau1[Société]=$A8),Tableau1[Solde\nnombre])>0),TODAY(),SMALL((Tableau1[Société]=$A8)*(Tableau1[Solde\nnombre]=0)*(Tableau1[Date]),COUNTA(Tableau1[Société])-COUNTIFS(Tableau1[Société],$A8,Tableau1[Solde\nnombre],\"0\")+C$1)))","v":""},{"$f":"IF(C8=\"\",\"\",IF(C8=TODAY(),\"\",IF(AND(IFERROR(SMALL((Tableau1[Société]=$A8)*(Tableau1[Solde\nnombre]=0)*(Tableau1[Date]),COUNTA(Tableau1[Société])-COUNTIFS(Tableau1[Société],$A8,Tableau1[Solde\nnombre],\"0\")+C$1),\"\")=\"\",LOOKUP(2,1/(Tableau1[Société]=$A8),Tableau1[Solde\nnombre])>0),TODAY(),SMALL((Tableau1[Société]=$A8)*(Tableau1[Solde\nnombre]=0)*(Tableau1[Date]),COUNTA(Tableau1[Société])-COUNTIFS(Tableau1[Société],$A8,Tableau1[Solde\nnombre],\"0\")+C$1))))","v":""},{"$f":"IF(D8=\"\",\"\",IF(D8=TODAY(),\"\",IF(AND(IFERROR(SMALL((Tableau1[Société]=$A8)*(Tableau1[Solde\nnombre]=0)*(Tableau1[Date]),COUNTA(Tableau1[Société])-COUNTIFS(Tableau1[Société],$A8,Tableau1[Solde\nnombre],\"0\")+D$1),\"\")=\"\",LOOKUP(2,1/(Tableau1[Société]=$A8),Tableau1[Solde\nnombre])>0),TODAY(),SMALL((Tableau1[Société]=$A8)*(Tableau1[Solde\nnombre]=0)*(Tableau1[Date]),COUNTA(Tableau1[Société])-COUNTIFS(Tableau1[Société],$A8,Tableau1[Solde\nnombre],\"0\")+D$1))))","v":""},{"$f":"IF(E8=\"\",\"\",IF(E8=TODAY(),\"\",IF(AND(IFERROR(SMALL((Tableau1[Société]=$A8)*(Tableau1[Solde\nnombre]=0)*(Tableau1[Date]),COUNTA(Tableau1[Société])-COUNTIFS(Tableau1[Société],$A8,Tableau1[Solde\nnombre],\"0\")+E$1),\"\")=\"\",LOOKUP(2,1/(Tableau1[Société]=$A8),Tableau1[Solde\nnombre])>0),TODAY(),SMALL((Tableau1[Société]=$A8)*(Tableau1[Solde\nnombre]=0)*(Tableau1[Date]),COUNTA(Tableau1[Société])-COUNTIFS(Tableau1[Société],$A8,Tableau1[Solde\nnombre],\"0\")+E$1))))","v":""},{"$f":"IF(F8=\"\",\"\",IF(F8=TODAY(),\"\",IF(AND(IFERROR(SMALL((Tableau1[Société]=$A8)*(Tableau1[Solde\nnombre]=0)*(Tableau1[Date]),COUNTA(Tableau1[Société])-COUNTIFS(Tableau1[Société],$A8,Tableau1[Solde\nnombre],\"0\")+F$1),\"\")=\"\",LOOKUP(2,1/(Tableau1[Société]=$A8),Tableau1[Solde\nnombre])>0),TODAY(),SMALL((Tableau1[Société]=$A8)*(Tableau1[Solde\nnombre]=0)*(Tableau1[Date]),COUNTA(Tableau1[Société])-COUNTIFS(Tableau1[Société],$A8,Tableau1[Solde\nnombre],\"0\")+F$1))))","v":""}]
[{"$f":"INDEX(Tableau1[Société],MATCH(0,COUNTIF($A$1:A8,Tableau1[Société]),0))","v":"Shmorgul"},{"$f":"IFERROR(SMALL((Tableau1[Société]=$A9)*(Tableau1[Solde\nnombre]=0)*(Tableau1[Date]),COUNTA(Tableau1[Société])-COUNTIFS(Tableau1[Société],$A9,Tableau1[Solde\nnombre],\"0\" )+B$1),TODAY())","v":"2022-10-25"},{"$f":"IF(B9=TODAY(),\"\",IF(AND(IFERROR(SMALL((Tableau1[Société]=$A9)*(Tableau1[Solde\nnombre]=0)*(Tableau1[Date]),COUNTA(Tableau1[Société])-COUNTIFS(Tableau1[Société],$A9,Tableau1[Solde\nnombre],\"0\")+C$1),\"\")=\"\",LOOKUP(2,1/(Tableau1[Société]=$A9),Tableau1[Solde\nnombre])>0),TODAY(),SMALL((Tableau1[Société]=$A9)*(Tableau1[Solde\nnombre]=0)*(Tableau1[Date]),COUNTA(Tableau1[Société])-COUNTIFS(Tableau1[Société],$A9,Tableau1[Solde\nnombre],\"0\")+C$1)))","v":""},{"$f":"IF(C9=\"\",\"\",IF(C9=TODAY(),\"\",IF(AND(IFERROR(SMALL((Tableau1[Société]=$A9)*(Tableau1[Solde\nnombre]=0)*(Tableau1[Date]),COUNTA(Tableau1[Société])-COUNTIFS(Tableau1[Société],$A9,Tableau1[Solde\nnombre],\"0\")+C$1),\"\")=\"\",LOOKUP(2,1/(Tableau1[Société]=$A9),Tableau1[Solde\nnombre])>0),TODAY(),SMALL((Tableau1[Société]=$A9)*(Tableau1[Solde\nnombre]=0)*(Tableau1[Date]),COUNTA(Tableau1[Société])-COUNTIFS(Tableau1[Société],$A9,Tableau1[Solde\nnombre],\"0\")+C$1))))","v":""},{"$f":"IF(D9=\"\",\"\",IF(D9=TODAY(),\"\",IF(AND(IFERROR(SMALL((Tableau1[Société]=$A9)*(Tableau1[Solde\nnombre]=0)*(Tableau1[Date]),COUNTA(Tableau1[Société])-COUNTIFS(Tableau1[Société],$A9,Tableau1[Solde\nnombre],\"0\")+D$1),\"\")=\"\",LOOKUP(2,1/(Tableau1[Société]=$A9),Tableau1[Solde\nnombre])>0),TODAY(),SMALL((Tableau1[Société]=$A9)*(Tableau1[Solde\nnombre]=0)*(Tableau1[Date]),COUNTA(Tableau1[Société])-COUNTIFS(Tableau1[Société],$A9,Tableau1[Solde\nnombre],\"0\")+D$1))))","v":""},{"$f":"IF(E9=\"\",\"\",IF(E9=TODAY(),\"\",IF(AND(IFERROR(SMALL((Tableau1[Société]=$A9)*(Tableau1[Solde\nnombre]=0)*(Tableau1[Date]),COUNTA(Tableau1[Société])-COUNTIFS(Tableau1[Société],$A9,Tableau1[Solde\nnombre],\"0\")+E$1),\"\")=\"\",LOOKUP(2,1/(Tableau1[Société]=$A9),Tableau1[Solde\nnombre])>0),TODAY(),SMALL((Tableau1[Société]=$A9)*(Tableau1[Solde\nnombre]=0)*(Tableau1[Date]),COUNTA(Tableau1[Société])-COUNTIFS(Tableau1[Société],$A9,Tableau1[Solde\nnombre],\"0\")+E$1))))","v":""},{"$f":"IF(F9=\"\",\"\",IF(F9=TODAY(),\"\",IF(AND(IFERROR(SMALL((Tableau1[Société]=$A9)*(Tableau1[Solde\nnombre]=0)*(Tableau1[Date]),COUNTA(Tableau1[Société])-COUNTIFS(Tableau1[Société],$A9,Tableau1[Solde\nnombre],\"0\")+F$1),\"\")=\"\",LOOKUP(2,1/(Tableau1[Société]=$A9),Tableau1[Solde\nnombre])>0),TODAY(),SMALL((Tableau1[Société]=$A9)*(Tableau1[Solde\nnombre]=0)*(Tableau1[Date]),COUNTA(Tableau1[Société])-COUNTIFS(Tableau1[Société],$A9,Tableau1[Solde\nnombre],\"0\")+F$1))))","v":""}]
[{"$f":"INDEX(Tableau1[Société],MATCH(0,COUNTIF($A$1:A9,Tableau1[Société]),0))","v":"Plastoc"},{"$f":"IFERROR(SMALL((Tableau1[Société]=$A10)*(Tableau1[Solde\nnombre]=0)*(Tableau1[Date]),COUNTA(Tableau1[Société])-COUNTIFS(Tableau1[Société],$A10,Tableau1[Solde\nnombre],\"0\" )+B$1),TODAY())","v":"2022-10-12"},{"$f":"IF(B10=TODAY(),\"\",IF(AND(IFERROR(SMALL((Tableau1[Société]=$A10)*(Tableau1[Solde\nnombre]=0)*(Tableau1[Date]),COUNTA(Tableau1[Société])-COUNTIFS(Tableau1[Société],$A10,Tableau1[Solde\nnombre],\"0\")+C$1),\"\")=\"\",LOOKUP(2,1/(Tableau1[Société]=$A10),Tableau1[Solde\nnombre])>0),TODAY(),SMALL((Tableau1[Société]=$A10)*(Tableau1[Solde\nnombre]=0)*(Tableau1[Date]),COUNTA(Tableau1[Société])-COUNTIFS(Tableau1[Société],$A10,Tableau1[Solde\nnombre],\"0\")+C$1)))","v":"2022-10-12"},{"$f":"IF(C10=\"\",\"\",IF(C10=TODAY(),\"\",IF(AND(IFERROR(SMALL((Tableau1[Société]=$A10)*(Tableau1[Solde\nnombre]=0)*(Tableau1[Date]),COUNTA(Tableau1[Société])-COUNTIFS(Tableau1[Société],$A10,Tableau1[Solde\nnombre],\"0\")+C$1),\"\")=\"\",LOOKUP(2,1/(Tableau1[Société]=$A10),Tableau1[Solde\nnombre])>0),TODAY(),SMALL((Tableau1[Société]=$A10)*(Tableau1[Solde\nnombre]=0)*(Tableau1[Date]),COUNTA(Tableau1[Société])-COUNTIFS(Tableau1[Société],$A10,Tableau1[Solde\nnombre],\"0\")+C$1))))","v":"2022-10-12"},{"$f":"IF(D10=\"\",\"\",IF(D10=TODAY(),\"\",IF(AND(IFERROR(SMALL((Tableau1[Société]=$A10)*(Tableau1[Solde\nnombre]=0)*(Tableau1[Date]),COUNTA(Tableau1[Société])-COUNTIFS(Tableau1[Société],$A10,Tableau1[Solde\nnombre],\"0\")+D$1),\"\")=\"\",LOOKUP(2,1/(Tableau1[Société]=$A10),Tableau1[Solde\nnombre])>0),TODAY(),SMALL((Tableau1[Société]=$A10)*(Tableau1[Solde\nnombre]=0)*(Tableau1[Date]),COUNTA(Tableau1[Société])-COUNTIFS(Tableau1[Société],$A10,Tableau1[Solde\nnombre],\"0\")+D$1))))","v":"2022-10-13"},{"$f":"IF(E10=\"\",\"\",IF(E10=TODAY(),\"\",IF(AND(IFERROR(SMALL((Tableau1[Société]=$A10)*(Tableau1[Solde\nnombre]=0)*(Tableau1[Date]),COUNTA(Tableau1[Société])-COUNTIFS(Tableau1[Société],$A10,Tableau1[Solde\nnombre],\"0\")+E$1),\"\")=\"\",LOOKUP(2,1/(Tableau1[Société]=$A10),Tableau1[Solde\nnombre])>0),TODAY(),SMALL((Tableau1[Société]=$A10)*(Tableau1[Solde\nnombre]=0)*(Tableau1[Date]),COUNTA(Tableau1[Société])-COUNTIFS(Tableau1[Société],$A10,Tableau1[Solde\nnombre],\"0\")+E$1))))","v":"2022-10-25"},{"$f":"IF(F10=\"\",\"\",IF(F10=TODAY(),\"\",IF(AND(IFERROR(SMALL((Tableau1[Société]=$A10)*(Tableau1[Solde\nnombre]=0)*(Tableau1[Date]),COUNTA(Tableau1[Société])-COUNTIFS(Tableau1[Société],$A10,Tableau1[Solde\nnombre],\"0\")+F$1),\"\")=\"\",LOOKUP(2,1/(Tableau1[Société]=$A10),Tableau1[Solde\nnombre])>0),TODAY(),SMALL((Tableau1[Société]=$A10)*(Tableau1[Solde\nnombre]=0)*(Tableau1[Date]),COUNTA(Tableau1[Société])-COUNTIFS(Tableau1[Société],$A10,Tableau1[Solde\nnombre],\"0\")+F$1))))","v":""},null,"=> rectifier formule, 1 vente en trop, le 25-10 doit être en E10"]

{"sheet":"Nbre jours","index":3,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Possession","Nombre\nJours 1","Nombre\nJours 2","Nombre\nJours 3","Nombre\nJours 4","Nombre\nJours 5"]
[{"$f":"Achats!A2","v":"Bidule"},{"$f":"Ventes!B2-Achats!B2+1","v":1392},{"$f":"IFERROR(Ventes!C2-Achats!C2+1,\"\")","v":723},{"$f":"IFERROR(Ventes!D2-Achats!D2+1,\"\")","v":""},{"$f":"IFERROR(Ventes!E2-Achats!E2+1,\"\")","v":""},{"$f":"IFERROR(Ventes!F2-Achats!F2+1,\"\")","v":""}]
[{"$f":"Achats!A3","v":"Chose"},{"$f":"Ventes!B3-Achats!B3+1","v":1518},{"$f":"IFERROR(Ventes!C3-Achats!C3+1,\"\")","v":""},{"$f":"IFERROR(Ventes!D3-Achats!D3+1,\"\")","v":""},{"$f":"IFERROR(Ventes!E3-Achats!E3+1,\"\")","v":""},{"$f":"IFERROR(Ventes!F3-Achats!F3+1,\"\")","v":""}]
[{"$f":"Achats!A4","v":"Machin"},{"$f":"Ventes!B4-Achats!B4+1","v":258},{"$f":"IFERROR(Ventes!C4-Achats!C4+1,\"\")","v":175},{"$f":"IFERROR(Ventes!D4-Achats!D4+1,\"\")","v":""},{"$f":"IFERROR(Ventes!E4-Achats!E4+1,\"\")","v":""},{"$f":"IFERROR(Ventes!F4-Achats!F4+1,\"\")","v":""}]
[{"$f":"Achats!A5","v":"Tatol"},{"$f":"Ventes!B5-Achats!B5+1","v":1411},{"$f":"IFERROR(Ventes!C5-Achats!C5+1,\"\")","v":""},{"$f":"IFERROR(Ventes!D5-Achats!D5+1,\"\")","v":""},{"$f":"IFERROR(Ventes!E5-Achats!E5+1,\"\")","v":""},{"$f":"IFERROR(Ventes!F5-Achats!F5+1,\"\")","v":""}]
[{"$f":"Achats!A6","v":"Tasle"},{"$f":"Ventes!B6-Achats!B6+1","v":1335},{"$f":"IFERROR(Ventes!C6-Achats!C6+1,\"\")","v":""},{"$f":"IFERROR(Ventes!D6-Achats!D6+1,\"\")","v":""},{"$f":"IFERROR(Ventes!E6-Achats!E6+1,\"\")","v":""},{"$f":"IFERROR(Ventes!F6-Achats!F6+1,\"\")","v":""}]
[{"$f":"Achats!A7","v":"Schoups"},{"$f":"Ventes!B7-Achats!B7+1","v":1},{"$f":"IFERROR(Ventes!C7-Achats!C7+1,\"\")","v":6},{"$f":"IFERROR(Ventes!D7-Achats!D7+1,\"\")","v":""},{"$f":"IFERROR(Ventes!E7-Achats!E7+1,\"\")","v":""},{"$f":"IFERROR(Ventes!F7-Achats!F7+1,\"\")","v":""}]
[{"$f":"Achats!A8","v":"Klary"},{"$f":"Ventes!B8-Achats!B8+1","v":30},{"$f":"IFERROR(Ventes!C8-Achats!C8+1,\"\")","v":""},{"$f":"IFERROR(Ventes!D8-Achats!D8+1,\"\")","v":""},{"$f":"IFERROR(Ventes!E8-Achats!E8+1,\"\")","v":""},{"$f":"IFERROR(Ventes!F8-Achats!F8+1,\"\")","v":""}]
[{"$f":"Achats!A9","v":"Shmorgul"},{"$f":"Ventes!B9-Achats!B9+1","v":23},{"$f":"IFERROR(Ventes!C9-Achats!C9+1,\"\")","v":""},{"$f":"IFERROR(Ventes!D9-Achats!D9+1,\"\")","v":""},{"$f":"IFERROR(Ventes!E9-Achats!E9+1,\"\")","v":""},{"$f":"IFERROR(Ventes!F9-Achats!F9+1,\"\")","v":""}]
[{"$f":"Achats!A10","v":"Plastoc"},{"$f":"Ventes!B10-Achats!B10+1","v":1},{"$f":"IFERROR(Ventes!C10-Achats!C10+1,\"\")","v":0},{"$f":"IFERROR(Ventes!D10-Achats!D10+1,\"\")","v":0},{"$f":"IFERROR(Ventes!E10-Achats!E10+1,\"\")","v":1},{"$f":"IFERROR(Ventes!F10-Achats!F10+1,\"\")","v":10}]

{"sheet":"Poss Tot","index":4,"n_rows":10,"n_cols":2,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Société","Durée totale de possession (jours)"]
[{"$f":"Achats!A2","v":"Bidule"},{"$f":"SUM('Nbre jours'!B2:ZZ2)","v":2115}]
[{"$f":"Achats!A3","v":"Chose"},{"$f":"SUM('Nbre jours'!B3:ZZ3)","v":1518}]
[{"$f":"Achats!A4","v":"Machin"},{"$f":"SUM('Nbre jours'!B4:ZZ4)","v":433}]
[{"$f":"Achats!A5","v":"Tatol"},{"$f":"SUM('Nbre jours'!B5:ZZ5)","v":1411}]
[{"$f":"Achats!A6","v":"Tasle"},{"$f":"SUM('Nbre jours'!B6:ZZ6)","v":1335}]
[{"$f":"Achats!A7","v":"Schoups"},{"$f":"SUM('Nbre jours'!B7:ZZ7)","v":7}]
[{"$f":"Achats!A8","v":"Klary"},{"$f":"SUM('Nbre jours'!B8:ZZ8)","v":30}]
[{"$f":"Achats!A9","v":"Shmorgul"},{"$f":"SUM('Nbre jours'!B9:ZZ9)","v":23}]
[{"$f":"Achats!A10","v":"Plastoc"},{"$f":"SUM('Nbre jours'!B10:ZZ10)","v":12}]

{"sheet":"Inter","index":5,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Intervalles","Inter 1","Inter 2","Inter 3"]
[{"$f":"Achats!A2","v":"Bidule"},{"$f":"IFERROR(Achats!C2-Ventes!B2-1,\"\")","v":0},{"$f":"IFERROR(Achats!D2-Ventes!C2-1,\"\")","v":""},{"$f":"IFERROR(Achats!E2-Ventes!D2-1,\"\")","v":""}]
[{"$f":"Achats!A3","v":"Chose"},{"$f":"IFERROR(Achats!C3-Ventes!B3-1,\"\")","v":""},{"$f":"IFERROR(Achats!D3-Ventes!C3-1,\"\")","v":""},{"$f":"IFERROR(Achats!E3-Ventes!D3-1,\"\")","v":""}]
[{"$f":"Achats!A4","v":"Machin"},{"$f":"IFERROR(Achats!C4-Ventes!B4-1,\"\")","v":1082},{"$f":"IFERROR(Achats!D4-Ventes!C4-1,\"\")","v":""},{"$f":"IFERROR(Achats!E4-Ventes!D4-1,\"\")","v":""}]
[{"$f":"Achats!A5","v":"Tatol"},{"$f":"IFERROR(Achats!C5-Ventes!B5-1,\"\")","v":""},{"$f":"IFERROR(Achats!D5-Ventes!C5-1,\"\")","v":""},{"$f":"IFERROR(Achats!E5-Ventes!D5-1,\"\")","v":""}]
[{"$f":"Achats!A6","v":"Tasle"},{"$f":"IFERROR(Achats!C6-Ventes!B6-1,\"\")","v":""},{"$f":"IFERROR(Achats!D6-Ventes!C6-1,\"\")","v":""},{"$f":"IFERROR(Achats!E6-Ventes!D6-1,\"\")","v":""}]
[{"$f":"Achats!A7","v":"Schoups"},{"$f":"IFERROR(Achats!C7-Ventes!B7-1,\"\")","v":105},{"$f":"IFERROR(Achats!D7-Ventes!C7-1,\"\")","v":""},{"$f":"IFERROR(Achats!E7-Ventes!D7-1,\"\")","v":""}]
[{"$f":"Achats!A8","v":"Klary"},{"$f":"IFERROR(Achats!C8-Ventes!B8-1,\"\")","v":""},{"$f":"IFERROR(Achats!D8-Ventes!C8-1,\"\")","v":""},{"$f":"IFERROR(Achats!E8-Ventes!D8-1,\"\")","v":""}]
[{"$f":"Achats!A9","v":"Shmorgul"},{"$f":"IFERROR(Achats!C9-Ventes!B9-1,\"\")","v":""},{"$f":"IFERROR(Achats!D9-Ventes!C9-1,\"\")","v":""},{"$f":"IFERROR(Achats!E9-Ventes!D9-1,\"\")","v":""}]
[{"$f":"Achats!A10","v":"Plastoc"},{"$f":"IFERROR(Achats!C10-Ventes!B10-1,\"\")","v":0},{"$f":"IFERROR(Achats!D10-Ventes!C10-1,\"\")","v":0},{"$f":"IFERROR(Achats!E10-Ventes!D10-1,\"\")","v":0}]

{"sheet":"Récap","index":6,"n_rows":10,"n_cols":8,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Société","Date\nachat 1","Nombre\nJours 1","Inter 1","Nombre\nJours 2","Inter 2","Nombre\nJours 3","Inter 3"]
[{"$f":"Achats!A2","v":"Bidule"},{"$f":"Achats!B2","v":"2017-01-10"},{"$f":"'Nbre jours'!B2","v":1392},{"$f":"Inter!B2","v":0},{"$f":"'Nbre jours'!C2","v":723}]
[{"$f":"Achats!A3","v":"Chose"},{"$f":"Achats!B3","v":"2017-04-27"},{"$f":"'Nbre jours'!B3","v":1518},{"$f":"Inter!B3","v":""},{"$f":"'Nbre jours'!C3","v":""}]
[{"$f":"Achats!A4","v":"Machin"},{"$f":"Achats!B4","v":"2018-09-02"},{"$f":"'Nbre jours'!B4","v":258},{"$f":"Inter!B4","v":1082},{"$f":"'Nbre jours'!C4","v":175}]
[{"$f":"Achats!A5","v":"Tatol"},{"$f":"Achats!B5","v":"2018-12-15"},{"$f":"'Nbre jours'!B5","v":1411},{"$f":"Inter!B5","v":""},{"$f":"'Nbre jours'!C5","v":""}]
[{"$f":"Achats!A6","v":"Tasle"},{"$f":"Achats!B6","v":"2019-03-01"},{"$f":"'Nbre jours'!B6","v":1335},{"$f":"Inter!B6","v":""},{"$f":"'Nbre jours'!C6","v":""}]
[{"$f":"Achats!A7","v":"Schoups"},{"$f":"Achats!B7","v":"2022-07-06"},{"$f":"'Nbre jours'!B7","v":1},{"$f":"Inter!B7","v":105},{"$f":"'Nbre jours'!C7","v":6}]
[{"$f":"Achats!A8","v":"Klary"},{"$f":"Achats!B8","v":"2022-09-26"},{"$f":"'Nbre jours'!B8","v":30},{"$f":"Inter!B8","v":""},{"$f":"'Nbre jours'!C8","v":""}]
[{"$f":"Achats!A9","v":"Shmorgul"},{"$f":"Achats!B9","v":"2022-10-03"},{"$f":"'Nbre jours'!B9","v":23},{"$f":"Inter!B9","v":""},{"$f":"'Nbre jours'!C9","v":""}]
[{"$f":"Achats!A10","v":"Plastoc"},{"$f":"Achats!B10","v":"2022-10-12"},{"$f":"'Nbre jours'!B10","v":1},{"$f":"Inter!B10","v":0},{"$f":"'Nbre jours'!C10","v":0}]

{"sheet":"Graphique","index":7,"n_rows":4,"n_cols":9,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,"MAX qui se met à jour à l'ouverture du fichier ;"]
[null,"Min =",{"$f":"MIN(Recap[Date\nachat 1])","v":42745},{"$f":"C2","v":"2017-01-10"},null,null,{"$f":"TODAY()","v":44859}]
[null,"Max =",{"$f":"TODAY()+300","v":45159},{"$f":"C3","v":"2023-08-21"},null,null,{"$f":"G2","v":"2022-10-25"},null,"(code VBA sur ThisWorkbook)"]
[null,"=> changeables en direct (code VBA sur feuille 8 \"Graphique\")"]