{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Feuil1","Feuil2","Feuil3"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"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":37,"n_cols":15,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
["Client","founisseur",null,"codage client","codage four.",null,"Client","fournisseurs"]
["EE_07","pi",null,{"$f":"IF(COUNTIF($A$2:A2,A2)=1,MAX($D$1:D1)+1,0)","v":1},{"$f":"IF(SUMPRODUCT(($A$2:A2&$B$2:B2=A2&B2)*1)=1,A2&\"_\"&COUNTIF($E$1:E1,\"*\"&A2&\"*\"),\"\")","v":"EE_07_0"},null,{"$f":"IFERROR(INDEX(A:A,MATCH(ROW()-1,D:D,0)),\"\")","v":"EE_07"},{"$f":"IFERROR(INDEX($B:$B,MATCH($G2&\"_\"&COLUMN()-8,$E:$E,0)),\"\")","v":"pi"},"Phi","Beta","","","","",""]
["AA_07","Ksi",null,{"$f":"IF(COUNTIF($A$2:A3,A3)=1,MAX($D$1:D2)+1,0)","v":2},{"$f":"IF(SUMPRODUCT(($A$2:A3&$B$2:B3=A3&B3)*1)=1,A3&\"_\"&COUNTIF($E$1:E2,\"*\"&A3&\"*\"),\"\")","v":"AA_07_0"},null,{"$f":"IFERROR(INDEX(A:A,MATCH(ROW()-1,D:D,0)),\"\")","v":"AA_07"},"Ksi","Phi","Delta","Omega","Alpha","rho","",""]
["AA_07","Phi",null,{"$f":"IF(COUNTIF($A$2:A4,A4)=1,MAX($D$1:D3)+1,0)","v":0},{"$f":"IF(SUMPRODUCT(($A$2:A4&$B$2:B4=A4&B4)*1)=1,A4&\"_\"&COUNTIF($E$1:E3,\"*\"&A4&\"*\"),\"\")","v":"AA_07_1"},null,"CC_07","Beta","Gamma","Delta","","","","",""]
["CC_07","Beta",null,{"$f":"IF(COUNTIF($A$2:A5,A5)=1,MAX($D$1:D4)+1,0)","v":3},{"$f":"IF(SUMPRODUCT(($A$2:A5&$B$2:B5=A5&B5)*1)=1,A5&\"_\"&COUNTIF($E$1:E4,\"*\"&A5&\"*\"),\"\")","v":"CC_07_0"},null,"U","","Alpha","","","","","",""]
["U","Alpha",null,{"$f":"IF(COUNTIF($A$2:A6,A6)=1,MAX($D$1:D5)+1,0)","v":4},{"$f":"IF(SUMPRODUCT(($A$2:A6&$B$2:B6=A6&B6)*1)=1,A6&\"_\"&COUNTIF($E$1:E5,\"*\"&A6&\"*\"),\"\")","v":"U_1"},null,"YYY_07","Pi","Delta","Alpha","","","","",""]
["YYY_07","Pi",null,{"$f":"IF(COUNTIF($A$2:A7,A7)=1,MAX($D$1:D6)+1,0)","v":5},{"$f":"IF(SUMPRODUCT(($A$2:A7&$B$2:B7=A7&B7)*1)=1,A7&\"_\"&COUNTIF($E$1:E6,\"*\"&A7&\"*\"),\"\")","v":"YYY_07_0"},null,"XXY_07","Ksi","Alpha","Omega","Gamma","","","",""]
["CC_07","Gamma",null,{"$f":"IF(COUNTIF($A$2:A8,A8)=1,MAX($D$1:D7)+1,0)","v":0},{"$f":"IF(SUMPRODUCT(($A$2:A8&$B$2:B8=A8&B8)*1)=1,A8&\"_\"&COUNTIF($E$1:E7,\"*\"&A8&\"*\"),\"\")","v":"CC_07_1"},null,"BB_07","rho","Beta","Delta","","","","",""]
["CC_07","Delta",null,{"$f":"IF(COUNTIF($A$2:A9,A9)=1,MAX($D$1:D8)+1,0)","v":0},{"$f":"IF(SUMPRODUCT(($A$2:A9&$B$2:B9=A9&B9)*1)=1,A9&\"_\"&COUNTIF($E$1:E8,\"*\"&A9&\"*\"),\"\")","v":"CC_07_2"},null,"VZXY_07","Pi","","","","","","",""]
["XXY_07","Ksi",null,{"$f":"IF(COUNTIF($A$2:A10,A10)=1,MAX($D$1:D9)+1,0)","v":6},{"$f":"IF(SUMPRODUCT(($A$2:A10&$B$2:B10=A10&B10)*1)=1,A10&\"_\"&COUNTIF($E$1:E9,\"*\"&A10&\"*\"),\"\")","v":"XXY_07_0"},null,"CC_07 ","Omega","","","","","","",""]
["XXY_07","Alpha",null,{"$f":"IF(COUNTIF($A$2:A11,A11)=1,MAX($D$1:D10)+1,0)","v":0},{"$f":"IF(SUMPRODUCT(($A$2:A11&$B$2:B11=A11&B11)*1)=1,A11&\"_\"&COUNTIF($E$1:E10,\"*\"&A11&\"*\"),\"\")","v":"XXY_07_1"},null,"UTR_07","Phi","Beta","Ksi","","","","",""]
["AA_07","Delta",null,{"$f":"IF(COUNTIF($A$2:A12,A12)=1,MAX($D$1:D11)+1,0)","v":0},{"$f":"IF(SUMPRODUCT(($A$2:A12&$B$2:B12=A12&B12)*1)=1,A12&\"_\"&COUNTIF($E$1:E11,\"*\"&A12&\"*\"),\"\")","v":"AA_07_2"},null,"DD_07","Beta","Pi","","","","","",""]
["BB_07","rho",null,{"$f":"IF(COUNTIF($A$2:A13,A13)=1,MAX($D$1:D12)+1,0)","v":7},{"$f":"IF(SUMPRODUCT(($A$2:A13&$B$2:B13=A13&B13)*1)=1,A13&\"_\"&COUNTIF($E$1:E12,\"*\"&A13&\"*\"),\"\")","v":"BB_07_0"},null,"VZ_07","Alpha","","","","","","",""]
["VZXY_07","Pi",null,{"$f":"IF(COUNTIF($A$2:A14,A14)=1,MAX($D$1:D13)+1,0)","v":8},{"$f":"IF(SUMPRODUCT(($A$2:A14&$B$2:B14=A14&B14)*1)=1,A14&\"_\"&COUNTIF($E$1:E13,\"*\"&A14&\"*\"),\"\")","v":"VZXY_07_0"},null,"TK_07","epsilon","","","","","","",""]
["EE_07","Phi",null,{"$f":"IF(COUNTIF($A$2:A15,A15)=1,MAX($D$1:D14)+1,0)","v":0},{"$f":"IF(SUMPRODUCT(($A$2:A15&$B$2:B15=A15&B15)*1)=1,A15&\"_\"&COUNTIF($E$1:E14,\"*\"&A15&\"*\"),\"\")","v":"EE_07_1"},null,"","","","","","","","",""]
["YYY_07","Delta",null,{"$f":"IF(COUNTIF($A$2:A16,A16)=1,MAX($D$1:D15)+1,0)","v":0},{"$f":"IF(SUMPRODUCT(($A$2:A16&$B$2:B16=A16&B16)*1)=1,A16&\"_\"&COUNTIF($E$1:E15,\"*\"&A16&\"*\"),\"\")","v":"YYY_07_1"},null,"","","","","","","","",""]
["CC_07 ","Omega",null,{"$f":"IF(COUNTIF($A$2:A17,A17)=1,MAX($D$1:D16)+1,0)","v":9},{"$f":"IF(SUMPRODUCT(($A$2:A17&$B$2:B17=A17&B17)*1)=1,A17&\"_\"&COUNTIF($E$1:E16,\"*\"&A17&\"*\"),\"\")","v":"CC_07 _0"}]
["UTR_07","Phi",null,{"$f":"IF(COUNTIF($A$2:A18,A18)=1,MAX($D$1:D17)+1,0)","v":10},{"$f":"IF(SUMPRODUCT(($A$2:A18&$B$2:B18=A18&B18)*1)=1,A18&\"_\"&COUNTIF($E$1:E17,\"*\"&A18&\"*\"),\"\")","v":"UTR_07_0"},null,"la colonne D détecte les clients différents pour édition en colonne G"]
["UTR_07","Beta",null,{"$f":"IF(COUNTIF($A$2:A19,A19)=1,MAX($D$1:D18)+1,0)","v":0},{"$f":"IF(SUMPRODUCT(($A$2:A19&$B$2:B19=A19&B19)*1)=1,A19&\"_\"&COUNTIF($E$1:E18,\"*\"&A19&\"*\"),\"\")","v":"UTR_07_1"},null,"Si la liste des clients est figée, ce système peu être remplacé par"]
["BB_07","Beta",null,{"$f":"IF(COUNTIF($A$2:A20,A20)=1,MAX($D$1:D19)+1,0)","v":0},{"$f":"IF(SUMPRODUCT(($A$2:A20&$B$2:B20=A20&B20)*1)=1,A20&\"_\"&COUNTIF($E$1:E19,\"*\"&A20&\"*\"),\"\")","v":"BB_07_1"},null,"copie de A /collage sur G et ruban/données/supprimer les doublons"]
["AA_07","Omega",null,{"$f":"IF(COUNTIF($A$2:A21,A21)=1,MAX($D$1:D20)+1,0)","v":0},{"$f":"IF(SUMPRODUCT(($A$2:A21&$B$2:B21=A21&B21)*1)=1,A21&\"_\"&COUNTIF($E$1:E20,\"*\"&A21&\"*\"),\"\")","v":"AA_07_3"}]
["XXY_07","Omega",null,{"$f":"IF(COUNTIF($A$2:A22,A22)=1,MAX($D$1:D21)+1,0)","v":0},{"$f":"IF(SUMPRODUCT(($A$2:A22&$B$2:B22=A22&B22)*1)=1,A22&\"_\"&COUNTIF($E$1:E21,\"*\"&A22&\"*\"),\"\")","v":"XXY_07_2"},null,"la colonne E détecte les fournisseurs différents par client"]
["YYY_07","Alpha",null,{"$f":"IF(COUNTIF($A$2:A23,A23)=1,MAX($D$1:D22)+1,0)","v":0},{"$f":"IF(SUMPRODUCT(($A$2:A23&$B$2:B23=A23&B23)*1)=1,A23&\"_\"&COUNTIF($E$1:E22,\"*\"&A23&\"*\"),\"\")","v":"YYY_07_2"},null,"ces deux colonnes peuvent être masquées ou se situer sur une feuille masquée"]
["YYY_07","Alpha",null,{"$f":"IF(COUNTIF($A$2:A24,A24)=1,MAX($D$1:D23)+1,0)","v":0},{"$f":"IF(SUMPRODUCT(($A$2:A24&$B$2:B24=A24&B24)*1)=1,A24&\"_\"&COUNTIF($E$1:E23,\"*\"&A24&\"*\"),\"\")","v":""}]
["EE_07","Beta",null,{"$f":"IF(COUNTIF($A$2:A25,A25)=1,MAX($D$1:D24)+1,0)","v":0},{"$f":"IF(SUMPRODUCT(($A$2:A25&$B$2:B25=A25&B25)*1)=1,A25&\"_\"&COUNTIF($E$1:E24,\"*\"&A25&\"*\"),\"\")","v":"EE_07_2"}]
["UTR_07","Ksi",null,{"$f":"IF(COUNTIF($A$2:A26,A26)=1,MAX($D$1:D25)+1,0)","v":0},{"$f":"IF(SUMPRODUCT(($A$2:A26&$B$2:B26=A26&B26)*1)=1,A26&\"_\"&COUNTIF($E$1:E25,\"*\"&A26&\"*\"),\"\")","v":"UTR_07_2"}]
["AA_07","Alpha",null,{"$f":"IF(COUNTIF($A$2:A27,A27)=1,MAX($D$1:D26)+1,0)","v":0},{"$f":"IF(SUMPRODUCT(($A$2:A27&$B$2:B27=A27&B27)*1)=1,A27&\"_\"&COUNTIF($E$1:E26,\"*\"&A27&\"*\"),\"\")","v":"AA_07_4"}]
["XXY_07","Gamma",null,{"$f":"IF(COUNTIF($A$2:A28,A28)=1,MAX($D$1:D27)+1,0)","v":0},{"$f":"IF(SUMPRODUCT(($A$2:A28&$B$2:B28=A28&B28)*1)=1,A28&\"_\"&COUNTIF($E$1:E27,\"*\"&A28&\"*\"),\"\")","v":"XXY_07_3"}]
["XXY_07","Gamma",null,{"$f":"IF(COUNTIF($A$2:A29,A29)=1,MAX($D$1:D28)+1,0)","v":0},{"$f":"IF(SUMPRODUCT(($A$2:A29&$B$2:B29=A29&B29)*1)=1,A29&\"_\"&COUNTIF($E$1:E28,\"*\"&A29&\"*\"),\"\")","v":""}]
["AA_07","Omega",null,{"$f":"IF(COUNTIF($A$2:A30,A30)=1,MAX($D$1:D29)+1,0)","v":0},{"$f":"IF(SUMPRODUCT(($A$2:A30&$B$2:B30=A30&B30)*1)=1,A30&\"_\"&COUNTIF($E$1:E29,\"*\"&A30&\"*\"),\"\")","v":""}]
["DD_07","Beta",null,{"$f":"IF(COUNTIF($A$2:A31,A31)=1,MAX($D$1:D30)+1,0)","v":11},{"$f":"IF(SUMPRODUCT(($A$2:A31&$B$2:B31=A31&B31)*1)=1,A31&\"_\"&COUNTIF($E$1:E30,\"*\"&A31&\"*\"),\"\")","v":"DD_07_0"}]
["BB_07","Delta",null,{"$f":"IF(COUNTIF($A$2:A32,A32)=1,MAX($D$1:D31)+1,0)","v":0},{"$f":"IF(SUMPRODUCT(($A$2:A32&$B$2:B32=A32&B32)*1)=1,A32&\"_\"&COUNTIF($E$1:E31,\"*\"&A32&\"*\"),\"\")","v":"BB_07_2"}]
["DD_07","Pi",null,{"$f":"IF(COUNTIF($A$2:A33,A33)=1,MAX($D$1:D32)+1,0)","v":0},{"$f":"IF(SUMPRODUCT(($A$2:A33&$B$2:B33=A33&B33)*1)=1,A33&\"_\"&COUNTIF($E$1:E32,\"*\"&A33&\"*\"),\"\")","v":"DD_07_1"}]
["DD_07","Beta",null,{"$f":"IF(COUNTIF($A$2:A34,A34)=1,MAX($D$1:D33)+1,0)","v":0},{"$f":"IF(SUMPRODUCT(($A$2:A34&$B$2:B34=A34&B34)*1)=1,A34&\"_\"&COUNTIF($E$1:E33,\"*\"&A34&\"*\"),\"\")","v":""}]
["VZ_07","Alpha",null,{"$f":"IF(COUNTIF($A$2:A35,A35)=1,MAX($D$1:D34)+1,0)","v":12},{"$f":"IF(SUMPRODUCT(($A$2:A35&$B$2:B35=A35&B35)*1)=1,A35&\"_\"&COUNTIF($E$1:E34,\"*\"&A35&\"*\"),\"\")","v":"VZ_07_0"}]
["AA_07","rho",null,{"$f":"IF(COUNTIF($A$2:A36,A36)=1,MAX($D$1:D35)+1,0)","v":0},{"$f":"IF(SUMPRODUCT(($A$2:A36&$B$2:B36=A36&B36)*1)=1,A36&\"_\"&COUNTIF($E$1:E35,\"*\"&A36&\"*\"),\"\")","v":"AA_07_5"}]
["TK_07","epsilon",null,{"$f":"IF(COUNTIF($A$2:A37,A37)=1,MAX($D$1:D36)+1,0)","v":13},{"$f":"IF(SUMPRODUCT(($A$2:A37&$B$2:B37=A37&B37)*1)=1,A37&\"_\"&COUNTIF($E$1:E36,\"*\"&A37&\"*\"),\"\")","v":"TK_07_0"}]

{"sheet":"Feuil2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Feuil3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}