{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["VBA Without duplicate ","VBA With duplicate","UNIQUE FUNC","TEXTJOIN With Duplicate","TEXTJOIN without Duplicates"],"not_rendered":{"charts":0,"images":0,"macros":1,"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":"VBA Without duplicate ","index":0,"n_rows":17,"n_cols":10,"rows_kept":17,"cut":false,"hidden":false,"merged":[[2,1,2,6]]}
[]
[]
[null,"VLOOKUP Multiple Values in One Cell"]
[]
[null,"Name","Product","Total Sales",null,"Name","Product"]
[null,"Novo","Mobile",10,null,"Novo",{"$f":"ValueswithoutRep(F6,$B$6:$D$14,2)","v":" Mobile, Laptop, AC"}]
[null,"Larry","Mobile",20,null,"John"]
[null,"Novo","Laptop",5,null,"Larry"]
[null,"John","TV",9]
[null,"Novo","Laptop",3]
[null,"Larry","Fridge",8]
[null,"Cartier","Headphone",15]
[null,"John","Mobile",13]
[null,"Novo","AC",2]
[]
[]
[null,null,null,null,null,null,null,null,null," "]

{"sheet":"VBA With duplicate","index":1,"n_rows":17,"n_cols":10,"rows_kept":17,"cut":false,"hidden":false,"merged":[[2,1,2,6]]}
[]
[]
[null,"VLOOKUP Multiple Values in One Cell"]
[]
[null,"Name","Product","Total Sales",null,"Name","Product"]
[null,"Novo","Mobile",10,null,"Novo",{"$f":"ValueswithRep($B$6:$B$14,F6,$C$6:$C$14,\", \")","v":"Mobile, Laptop, Laptop, AC"}]
[null,"Larry","Mobile",20,null,"John"]
[null,"Novo","Laptop",5,null,"Larry"]
[null,"John","TV",9]
[null,"Novo","Laptop",3]
[null,"Larry","Fridge",8]
[null,"Cartier","Headphone",15]
[null,"John","Mobile",13]
[null,"Novo","AC",2]
[]
[]
[null,null,null,null,null,null,null,null,null," "]

{"sheet":"UNIQUE FUNC","index":2,"n_rows":17,"n_cols":10,"rows_kept":17,"cut":false,"hidden":false,"merged":[[2,1,2,6]]}
[]
[]
[null,"VLOOKUP Multiple Values in One Cell"]
[]
[null,"Name","Product","Total Sales",null,"Name","Product"]
[null,"Novo","Mobile",10,null,"John",{"$f":"_xlfn.TEXTJOIN(\", \",TRUE,_xlfn.UNIQUE(IF(F6=$B$6:$B$14,$C$6:$C$14,\"\")))","v":"TV, Mobile"}]
[null,"Larry","Mobile",20,null,"Novo",{"$f":"_xlfn.TEXTJOIN(\", \",TRUE,_xlfn.UNIQUE(IF(F7=$B$6:$B$14,$C$6:$C$14,\"\")))","v":"Mobile, Laptop, AC"}]
[null,"Novo","Laptop",5,null,"Larry",{"$f":"_xlfn.TEXTJOIN(\", \",TRUE,_xlfn.UNIQUE(IF(F8=$B$6:$B$14,$C$6:$C$14,\"\")))","v":"Mobile, Fridge"}]
[null,"John","TV",9]
[null,"Novo","Laptop",3]
[null,"Larry","Fridge",8]
[null,"Cartier","Headphone",15]
[null,"John","Mobile",13]
[null,"Novo","AC",2]
[]
[]
[null,null,null,null,null,null,null,null,null," "]

{"sheet":"TEXTJOIN With Duplicate","index":3,"n_rows":14,"n_cols":7,"rows_kept":14,"cut":false,"hidden":false,"merged":[[2,1,2,6]]}
[]
[]
[null,"VLOOKUP Multiple Values in One Cell"]
[]
[null,"Name","Product","Total Sales",null,"Name","Product"]
[null,"Novo","Mobile",10,null,"John",{"$f":"_xlfn.TEXTJOIN(\",\",TRUE,IF($B$6:$B$14=F6,$C$6:$C$14,\"\"))","v":"TV,Mobile"}]
[null,"Larry","Mobile",20,null,"Novo",{"$f":"_xlfn.TEXTJOIN(\",\",TRUE,IF($B$6:$B$14=F7,$C$6:$C$14,\"\"))","v":"Mobile,Laptop,Laptop,AC"}]
[null,"Novo","Laptop",5,null,"Larry",{"$f":"_xlfn.TEXTJOIN(\",\",TRUE,IF($B$6:$B$14=F8,$C$6:$C$14,\"\"))","v":"Mobile,Fridge"}]
[null,"John","TV",9]
[null,"Novo","Laptop",3]
[null,"Larry","Fridge",8]
[null,"Cartier","Headphone",15]
[null,"John","Mobile",13]
[null,"Novo","AC",2]

{"sheet":"TEXTJOIN without Duplicates","index":4,"n_rows":17,"n_cols":10,"rows_kept":17,"cut":false,"hidden":false,"merged":[[2,1,2,6]]}
[]
[]
[null,"VLOOKUP Multiple Values in One Cell"]
[]
[null,"Name","Product","Total Sales",null,"Name","Product"]
[null,"Novo","Mobile",10,null,"John",{"$f":"_xlfn.TEXTJOIN(\",\", TRUE, IF(IFERROR(MATCH($C$6:$C$14, IF(F6=$B$6:$B$14, $C$6:$C$14, \"\"), 0),\"\")=MATCH(ROW($C$6:$C$14), ROW($C$6:$C$14)), $C$6:$C$14, \"\"))","v":"TV,Mobile"}]
[null,"Larry","Mobile",20,null,"Novo",{"$f":"_xlfn.TEXTJOIN(\",\", TRUE, IF(IFERROR(MATCH($C$6:$C$14, IF(F7=$B$6:$B$14, $C$6:$C$14, \"\"), 0),\"\")=MATCH(ROW($C$6:$C$14), ROW($C$6:$C$14)), $C$6:$C$14, \"\"))","v":"Mobile,Laptop,AC"}]
[null,"Novo","Laptop",5,null,"Larry",{"$f":"_xlfn.TEXTJOIN(\",\", TRUE, IF(IFERROR(MATCH($C$6:$C$14, IF(F8=$B$6:$B$14, $C$6:$C$14, \"\"), 0),\"\")=MATCH(ROW($C$6:$C$14), ROW($C$6:$C$14)), $C$6:$C$14, \"\"))","v":"Mobile,Fridge"}]
[null,"John","TV",9]
[null,"Novo","Laptop",3]
[null,"Larry","Fridge",8]
[null,"Cartier","Headphone",15]
[null,"John","Mobile",13]
[null,"Novo","AC",2]
[]
[]
[null,null,null,null,null,null,null,null,null," "]