{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["DONNEES","CONC"],"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":"DONNEES","index":0,"n_rows":16,"n_cols":19,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["Client",null,null,null,null,null,null,null,null,null,null,null,"E-mail",null,null,null,"A prendre",null,"codage"]
[43,null,null,null,null,null,null,null,null,null,null,null,"oiseau@orange.fr",null,null,null,1,null,{"$f":"IF(COUNTIF($M$1:$M1,\"*\"&M2&\"*\"),\"\",IF(Q2=1,A2&\"_\"&COUNTIF($A$2:A2,A2),\"\"))","v":"43_1"}]
[43,null,null,null,null,null,null,null,null,null,null,null,"chien@orange.fr",null,null,null,0,null,{"$f":"IF(COUNTIF($M$1:$M2,\"*\"&M3&\"*\"),\"\",IF(Q3=1,A3&\"_\"&COUNTIF($A$2:A3,A3),\"\"))","v":""}]
[57,null,null,null,null,null,null,null,null,null,null,null,"rat@orange.fr",null,null,null,1,null,{"$f":"IF(COUNTIF($M$1:$M3,\"*\"&M4&\"*\"),\"\",IF(Q4=1,A4&\"_\"&COUNTIF($A$2:A4,A4),\"\"))","v":"57_1"}]
[111,null,null,null,null,null,null,null,null,null,null,null,"loup@orange.fr;brebis@orange.fr",null,null,null,1,null,{"$f":"IF(COUNTIF($M$1:$M4,\"*\"&M5&\"*\"),\"\",IF(Q5=1,A5&\"_\"&COUNTIF($A$2:A5,A5),\"\"))","v":"111_1"}]
[111,null,null,null,null,null,null,null,null,null,null,null,"moineau@orange.fr",null,null,null,1,null,{"$f":"IF(COUNTIF($M$1:$M5,\"*\"&M6&\"*\"),\"\",IF(Q6=1,A6&\"_\"&COUNTIF($A$2:A6,A6),\"\"))","v":"111_2"}]
[111,null,null,null,null,null,null,null,null,null,null,null,"brebis@orange.fr",null,null,null,1,null,{"$f":"IF(COUNTIF($M$1:$M6,\"*\"&M7&\"*\"),\"\",IF(Q7=1,A7&\"_\"&COUNTIF($A$2:A7,A7),\"\"))","v":""}]
[99,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,{"$f":"IF(COUNTIF($M$1:$M7,\"*\"&M8&\"*\"),\"\",IF(Q8=1,A8&\"_\"&COUNTIF($A$2:A8,A8),\"\"))","v":""}]
[14,null,null,null,null,null,null,null,null,null,null,null,"elephant@orange.fr",null,null,null,0,null,{"$f":"IF(COUNTIF($M$1:$M8,\"*\"&M9&\"*\"),\"\",IF(Q9=1,A9&\"_\"&COUNTIF($A$2:A9,A9),\"\"))","v":""}]
[]
[null,"Objectif : concaténer en feuille \"CONC\", colonne D,  tous les mails du client de CONC!Bx si la colonne Q contient \"1\""]
[null,"Elimination des doublons dans les mails"]
[]
[null,"Dans le fichier original : 450000 lignes de données ! (30 Mo) !"]
[]
[null,"Merci par avance pour l'aide apportée."]

{"sheet":"CONC","index":1,"n_rows":4,"n_cols":6,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[null,"Code",null,"Mails concaténés","Résultat attendu en D :"]
[null,43,null,null,{"$f":"IFERROR(INDEX(DONNEES!$M:$M,MATCH(CONC!$B2&\"_\"&1,DONNEES!$S:$S,0),1),\"\")&IFERROR(\";\"&INDEX(DONNEES!$M:$M,MATCH(CONC!$B2&\"_\"&2,DONNEES!$S:$S,0),1),\"\")&IFERROR(\";\"&INDEX(DONNEES!$M:$M,MATCH(CONC!$B2&\"_\"&2,DONNEES!$S:$S,0),3),\"\")&IFERROR(\";\"&INDEX(DONNEES!$M:$M,MATCH(CONC!$B2&\"_\"&2,DONNEES!$S:$S,0),4),\"\")","v":"oiseau@orange.fr"},"oiseau seulement car il y a un 0 dans Q3"]
[null,111,null,null,{"$f":"IFERROR(INDEX(DONNEES!$M:$M,MATCH(CONC!$B3&\"_\"&1,DONNEES!$S:$S,0),1),\"\")&IFERROR(\";\"&INDEX(DONNEES!$M:$M,MATCH(CONC!$B3&\"_\"&2,DONNEES!$S:$S,0),1),\"\")&IFERROR(\";\"&INDEX(DONNEES!$M:$M,MATCH(CONC!$B3&\"_\"&2,DONNEES!$S:$S,0),3),\"\")&IFERROR(\";\"&INDEX(DONNEES!$M:$M,MATCH(CONC!$B3&\"_\"&2,DONNEES!$S:$S,0),4),\"\")","v":"loup@orange.fr;brebis@orange.fr;moineau@orange.fr"},"4 mails pour le 111, mais 1 en doublon, donc 3 au final."]
[null,99,null,null,{"$f":"IFERROR(INDEX(DONNEES!$M:$M,MATCH(CONC!$B4&\"_\"&1,DONNEES!$S:$S,0),1),\"\")&IFERROR(\";\"&INDEX(DONNEES!$M:$M,MATCH(CONC!$B4&\"_\"&2,DONNEES!$S:$S,0),1),\"\")&IFERROR(\";\"&INDEX(DONNEES!$M:$M,MATCH(CONC!$B4&\"_\"&2,DONNEES!$S:$S,0),3),\"\")&IFERROR(\";\"&INDEX(DONNEES!$M:$M,MATCH(CONC!$B4&\"_\"&2,DONNEES!$S:$S,0),4),\"\")","v":""}]