{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Лист1","Лист2"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":1,"pivot_tables":1},"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":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Столбец1","Столбец2","Доп.столбец"]
["а","апельсин",{"$f":"IF(COUNTIF(A3:$A$30,A2)=0,B2,VLOOKUP(A2,A3:$C$30,3,0)&\", \"&B2)","v":"айва, ананас, апельсин"}]
["б","банан",{"$f":"IF(COUNTIF(A4:$A$30,A3)=0,B3,VLOOKUP(A3,A4:$C$30,3,0)&\", \"&B3)","v":"банан"}]
["в","виноград",{"$f":"IF(COUNTIF(A5:$A$30,A4)=0,B4,VLOOKUP(A4,A5:$C$30,3,0)&\", \"&B4)","v":"вишня, виноград"}]
["а","ананас",{"$f":"IF(COUNTIF(A6:$A$30,A5)=0,B5,VLOOKUP(A5,A6:$C$30,3,0)&\", \"&B5)","v":"айва, ананас"}]
["а","айва",{"$f":"IF(COUNTIF(A7:$A$30,A6)=0,B6,VLOOKUP(A6,A7:$C$30,3,0)&\", \"&B6)","v":"айва"}]
["в","вишня",{"$f":"IF(COUNTIF(A8:$A$30,A7)=0,B7,VLOOKUP(A7,A8:$C$30,3,0)&\", \"&B7)","v":"вишня"}]
[]
[null,null,{"$f":"IF(B9=\"\",\"\",IF(COUNT($B$5:B9)>1,LOOKUP(2,1/($B$4:B8<>\"\"),$C$4:C8)&\", \",\"\")&LOOKUP(2,1/($B$4:B9<>\"\"),$B$4:B9&\" ед. - \"&$A$4:A9))","v":""}]
[null,null,{"$f":"IF(B10=\"\",\"\",IF(COUNT($B$5:B10)>1,LOOKUP(2,1/($B$4:B9<>\"\"),$C$4:C9)&\", \",\"\")&LOOKUP(2,1/($B$4:B10<>\"\"),$B$4:B10&\" ед. - \"&$A$4:A10))","v":""}]
[null,null,{"$f":"IF(B11=\"\",\"\",IF(COUNT($B$5:B11)>1,LOOKUP(2,1/($B$4:B10<>\"\"),$C$4:C10)&\", \",\"\")&LOOKUP(2,1/($B$4:B11<>\"\"),$B$4:B11&\" ед. - \"&$A$4:A11))","v":""}]

{"sheet":"Лист2","index":1,"n_rows":5,"n_cols":4,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Названия строк"]
["а",{"$f":"ertert(Лист2!A2,Лист1!A1:B10,2,\", \")","v":"апельсин, ананас, айва"},null,{"$f":"VLOOKUP(A2,Лист1!$A$1:$C$7,3)","v":"айва, ананас, апельсин"}]
["б",{"$f":"ertert(Лист2!A3,Лист1!A2:B11,2,\", \")","v":"банан"},null,{"$f":"VLOOKUP(A3,Лист1!$A$1:$C$7,3)","v":"банан"}]
["в",{"$f":"ertert(Лист2!A4,Лист1!A3:B12,2,\", \")","v":"виноград, вишня"},null,{"$f":"VLOOKUP(A4,Лист1!$A$1:$C$7,3)","v":"вишня, виноград"}]
["Общий итог"]