{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Лист1"],"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":"Лист1","index":0,"n_rows":19,"n_cols":9,"rows_kept":19,"cut":false,"hidden":false,"merged":[[0,5,0,7],[13,5,13,7]]}
[null,null,"глобал","ШК",null,"Даные--Удалить дубликаты",null,null,"Формула UDF"]
["Алкоголь                                          ","Бальзами                                          ",104770,4820076000034,null,"Алкоголь                                          ","Бальзами                                          ",104770,{"$f":"СцепитьЕсли($C$2:$C$11,H2,$D$2:$D$11,CHAR(10))","v":"4820076000034\n4820139760189"}]
["Алкоголь                                          ","Бальзами                                          ",104770,4820139760189,null,"Алкоголь                                          ","Бальзами                                          ",62867,{"$f":"СцепитьЕсли($C$2:$C$11,H3,$D$2:$D$11,CHAR(10))","v":"503\n4820001232042"}]
["Алкоголь                                          ","Бальзами                                          ",62867,503,null,"Алкоголь                                          ","Бальзами                                          ",32342,"4820001233029\n4820001232028"]
["Алкоголь                                          ","Бальзами                                          ",62867,4820001232042,null,"Алкоголь                                          ","Бальзами                                          ",62868,"4820001232055\n4820001232059"]
["Алкоголь                                          ","Бальзами                                          ",32342,4820001233029,null,"Алкоголь                                          ","Бальзами                                          ",32343,"4820001234020\n4820001232011"]
["Алкоголь                                          ","Бальзами                                          ",32342,4820001232028]
["Алкоголь                                          ","Бальзами                                          ",62868,4820001232055]
["Алкоголь                                          ","Бальзами                                          ",62868,4820001232059]
["Алкоголь                                          ","Бальзами                                          ",32343,4820001234020]
["Алкоголь                                          ","Бальзами                                          ",32343,4820001232011]
[]
[null,"Хочу видеть "]
[null,null,null,null,null,"Формулами",null,null,"UDF"]
["Алкоголь                                          ","Бальзами                                          ",104770,"4820076000034 4820139760189",null,{"$f":"INDEX($A$2:$D$11,MATCH($H15,$C$2:$C$11,0),1)","v":"Алкоголь                                          "},{"$f":"INDEX($A$2:$D$11,MATCH($H15,$C$2:$C$11,0),2)","v":"Бальзами                                          "},{"$f":"INDEX($C$2:$C$11,SMALL(IF(MATCH($C$2:$C$11,$C$2:$C$11,0)=ROW($A$1:$A$10),ROW($A$1:$A$10)),ROW(A1)))","v":104770},{"$f":"СцепитьЕсли($C$2:$C$11,H15,$D$2:$D$11,CHAR(10))","v":"4820076000034\n4820139760189"}]
["Алкоголь                                          ","Бальзами                                          ",62867,"4820001232042 503",null,{"$f":"INDEX($A$2:$D$11,MATCH($H16,$C$2:$C$11,0),1)","v":"Алкоголь                                          "},{"$f":"INDEX($A$2:$D$11,MATCH($H16,$C$2:$C$11,0),2)","v":"Бальзами                                          "},{"$f":"INDEX($C$2:$C$11,SMALL(IF(MATCH($C$2:$C$11,$C$2:$C$11,0)=ROW($A$1:$A$10),ROW($A$1:$A$10)),ROW(A2)))","v":62867},{"$f":"СцепитьЕсли($C$2:$C$11,H16,$D$2:$D$11,CHAR(10))","v":"503\n4820001232042"}]
["Алкоголь                                          ","Бальзами                                          ",32342,"4820001233029 4820001232028",null,"Алкоголь                                          ","Бальзами                                          ",{"$f":"INDEX($C$2:$C$11,SMALL(IF(MATCH($C$2:$C$11,$C$2:$C$11,0)=ROW($A$1:$A$10),ROW($A$1:$A$10)),ROW(A3)))","v":32342},"4820001233029\n4820001232028"]
["Алкоголь                                          ","Бальзами                                          ",62868,"4820001232055 4820001232059",null,"Алкоголь                                          ","Бальзами                                          ",{"$f":"INDEX($C$2:$C$11,SMALL(IF(MATCH($C$2:$C$11,$C$2:$C$11,0)=ROW($A$1:$A$10),ROW($A$1:$A$10)),ROW(A4)))","v":62868},"4820001232055\n4820001232059"]
["Алкоголь                                          ","Бальзами                                          ",32343,"4820001234020 4820001232011",null,"Алкоголь                                          ","Бальзами                                          ",{"$f":"INDEX($C$2:$C$11,SMALL(IF(MATCH($C$2:$C$11,$C$2:$C$11,0)=ROW($A$1:$A$10),ROW($A$1:$A$10)),ROW(A5)))","v":32343},"4820001234020\n4820001232011"]