{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["avec Morefunc","sol. VBA"],"not_rendered":{"charts":0,"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":"avec Morefunc","index":0,"n_rows":13,"n_cols":7,"rows_kept":13,"cut":false,"hidden":false,"merged":[[8,0,12,0]]}
[]
["BA26653123","1452-1254",null,null,null,{"$f":"_xll.VALEURS.UNIQUES($A$2:$A$7,1)","v":"BA26653123"},{"$f":"IF(F2<>\"\",SUBSTITUTE(SUBSTITUTE(_xll.MCONCAT(IF($A$2:$A$7=F2,$B$2:$B$7),\", \"),\", FAUX\",\"\"),\"FAUX, \",\"\"),\"\")","v":"1452-1254, 1452-1255, 1452-1256"}]
["BA26653123","1452-1255",null,null,null,"D1256651",{"$f":"IF(F3<>\"\",SUBSTITUTE(SUBSTITUTE(_xll.MCONCAT(IF($A$2:$A$7=F3,$B$2:$B$7),\", \"),\", FAUX\",\"\"),\"FAUX, \",\"\"),\"\")","v":"2625-12656"}]
["BA26653123","1452-1256",null,null,null,"HE1654654",{"$f":"IF(F4<>\"\",SUBSTITUTE(SUBSTITUTE(_xll.MCONCAT(IF($A$2:$A$7=F4,$B$2:$B$7),\", \"),\", FAUX\",\"\"),\"FAUX, \",\"\"),\"\")","v":"1465-15431, 1465-15432"}]
["HE1654654","1465-15431",null,null,null,"",{"$f":"IF(F5<>\"\",SUBSTITUTE(SUBSTITUTE(_xll.MCONCAT(IF($A$2:$A$7=F5,$B$2:$B$7),\", \"),\", FAUX\",\"\"),\"FAUX, \",\"\"),\"\")","v":""}]
["HE1654654","1465-15432",null,null,null,"",{"$f":"IF(F6<>\"\",SUBSTITUTE(SUBSTITUTE(_xll.MCONCAT(IF($A$2:$A$7=F6,$B$2:$B$7),\", \"),\", FAUX\",\"\"),\"FAUX, \",\"\"),\"\")","v":""}]
["D1256651","2625-12656",null,null,null,"",{"$f":"IF(F7<>\"\",SUBSTITUTE(SUBSTITUTE(_xll.MCONCAT(IF($A$2:$A$7=F7,$B$2:$B$7),\", \"),\", FAUX\",\"\"),\"FAUX, \",\"\"),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(F8<>\"\",SUBSTITUTE(SUBSTITUTE(_xll.MCONCAT(IF($A$2:$A$7=F8,$B$2:$B$7),\",\"),\",FAUX\",\"\"),\"FAUX,\",\"\"),\"\")","v":""}]
["Solution avec Morefunc","F2:F7 :","=VALEURS.UNIQUES($A$2:$A$7;1)"]
[null,null,"à valider par CTRL+SHIFT+ENTER"]
[null,"G2 :","=SI(F2<>\"\";SUBSTITUE(SUBSTITUE(MCONCAT(SI($A$2:$A$7=F2;$B$2:$B$7);\",\");\",FAUX\";\"\");\"FAUX,\";\"\");\"\")"]
[null,null,"à valider par CTRL+SHIFT+ENTER"]
[null,null,"puis recopier vers le bas sur G2:G7"]

{"sheet":"sol. VBA","index":1,"n_rows":8,"n_cols":7,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["data",null,null,null,null,"Résultat"]
["BA26653123","1452-1254",null,null,null,"BA26653123","1452-1254, 1452-1255, 1452-1256"]
["BA26653123","1452-1255",null,null,null,"HE1654654","1465-15431, 1465-15432"]
["BA26653123","1452-1256",null,null,null,"D1256651","2625-12656"]
["HE1654654","1465-15431",null,null,null,null,{"$f":"IF(F5<>\"\",SUBSTITUTE(SUBSTITUTE(_xll.MCONCAT(IF($A$2:$A$7=F5,$B$2:$B$7),\",\"),\",FAUX\",\"\"),\"FAUX,\",\"\"),\"\")","v":""}]
["HE1654654","1465-15432",null,null,null,null,{"$f":"IF(F6<>\"\",SUBSTITUTE(SUBSTITUTE(_xll.MCONCAT(IF($A$2:$A$7=F6,$B$2:$B$7),\",\"),\",FAUX\",\"\"),\"FAUX,\",\"\"),\"\")","v":""}]
["D1256651","2625-12656",null,null,null,null,{"$f":"IF(F7<>\"\",SUBSTITUTE(SUBSTITUTE(_xll.MCONCAT(IF($A$2:$A$7=F7,$B$2:$B$7),\",\"),\",FAUX\",\"\"),\"FAUX,\",\"\"),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(F8<>\"\",SUBSTITUTE(SUBSTITUTE(_xll.MCONCAT(IF($A$2:$A$7=F8,$B$2:$B$7),\",\"),\",FAUX\",\"\"),\"FAUX,\",\"\"),\"\")","v":""}]