{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Лист1","Лист2"],"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":"Лист1","index":0,"n_rows":35,"n_cols":19,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Имя","Значение","Имя","Значение",null,null,"Имя","Значение","Имя","Значение",null,"Имя","Значение",null,"Имя","Значение","Имя","Значение"]
[null,"Иван",5,"Петр",9,null,null,"Иван",5,"Петр",9,null,{"$f":"IFERROR(INDEX($H$3:$K$18,IF(MOD(ROW(H3),2)>0,ROW(H3)-(ROW(H3)+1)/2,ROW(H3)-(ROW(H3))/2-1),IF(MOD(ROW(H3),2)>0,COLUMN(H$3)-7,COLUMN(H$3)-5)),\"\")","v":"Иван"},{"$f":"IFERROR(INDEX($H$3:$K$18,IF(MOD(ROW(I3),2)>0,ROW(I3)-(ROW(I3)+1)/2,ROW(I3)-(ROW(I3))/2-1),IF(MOD(ROW(I3),2)>0,COLUMN(I$3)-7,COLUMN(I$3)-5)),\"\")","v":5},null,{"$f":"IF(ISERROR(INDEX($M$3:$M$22,MATCH(0,COUNTIF(P$2:P2,$M$3:$M$22),0))),\"\",INDEX($M$3:$M$22,MATCH(0,COUNTIF(P$2:P2,$M$3:$M$22),0)))","v":"Иван"},{"$f":"IFERROR(SUMIF($M$3:$M$22,P3,$N$3:$N$22),\"\")","v":33},{"$f":"IFERROR(INDEX($M$3:$M$22,MATCH(0,IF(ISBLANK($M$3:$M$22),\"\",COUNTIF($R$2:R2,$M$3:$M$22)),0)),\"\")","v":"Иван"},{"$f":"IFERROR(SUMIF($M$3:$M$22,R3,$N$3:$N$22),\"\")","v":33}]
[null,"Леша",5,"Федя",7,null,null,"Леша",5,"Федя",7,null,{"$f":"IFERROR(INDEX($H$3:$K$18,IF(MOD(ROW(H4),2)>0,ROW(H4)-(ROW(H4)+1)/2,ROW(H4)-(ROW(H4))/2-1),IF(MOD(ROW(H4),2)>0,COLUMN(H$3)-7,COLUMN(H$3)-5)),\"\")","v":"Петр"},9,null,{"$f":"IF(ISERROR(INDEX($M$3:$M$22,MATCH(0,COUNTIF(P$2:P3,$M$3:$M$22),0))),\"\",INDEX($M$3:$M$22,MATCH(0,COUNTIF(P$2:P3,$M$3:$M$22),0)))","v":"Петр"},{"$f":"IFERROR(SUMIF($M$3:$M$22,P4,$N$3:$N$22),\"\")","v":27},{"$f":"IFERROR(INDEX($M$3:$M$22,MATCH(0,IF(ISBLANK($M$3:$M$22),\"\",COUNTIF($R$2:R3,$M$3:$M$22)),0)),\"\")","v":"Петр"},{"$f":"IFERROR(SUMIF($M$3:$M$22,R4,$N$3:$N$22),\"\")","v":27}]
[null,"Федя",1,"Иван",9,null,null,"Федя",1,"Иван",9,null,"Леша",5,null,{"$f":"IF(ISERROR(INDEX($M$3:$M$22,MATCH(0,COUNTIF(P$2:P4,$M$3:$M$22),0))),\"\",INDEX($M$3:$M$22,MATCH(0,COUNTIF(P$2:P4,$M$3:$M$22),0)))","v":"Леша"},15,{"$f":"IFERROR(INDEX($M$3:$M$22,MATCH(0,IF(ISBLANK($M$3:$M$22),\"\",COUNTIF($R$2:R4,$M$3:$M$22)),0)),\"\")","v":"Леша"},15]
[null,"Лена",3,"Катя",7,null,null,"Лена",3,"Катя",7,null,"Федя",7,null,{"$f":"IF(ISERROR(INDEX($M$3:$M$22,MATCH(0,COUNTIF(P$2:P5,$M$3:$M$22),0))),\"\",INDEX($M$3:$M$22,MATCH(0,COUNTIF(P$2:P5,$M$3:$M$22),0)))","v":"Федя"},23,{"$f":"IFERROR(INDEX($M$3:$M$22,MATCH(0,IF(ISBLANK($M$3:$M$22),\"\",COUNTIF($R$2:R5,$M$3:$M$22)),0)),\"\")","v":"Федя"},23]
[null,null,null,null,null,null,null,"Лена",3,"Катя",7,null,"Федя",1,null,{"$f":"IF(ISERROR(INDEX($M$3:$M$22,MATCH(0,COUNTIF(P$2:P6,$M$3:$M$22),0))),\"\",INDEX($M$3:$M$22,MATCH(0,COUNTIF(P$2:P6,$M$3:$M$22),0)))","v":"Лена"},6,{"$f":"IFERROR(INDEX($M$3:$M$22,MATCH(0,IF(ISBLANK($M$3:$M$22),\"\",COUNTIF($R$2:R6,$M$3:$M$22)),0)),\"\")","v":"Лена"},6]
[null,null,null,null,null,null,null,"Иван",5,"Петр",9,null,"Иван",9,null,{"$f":"IF(ISERROR(INDEX($M$3:$M$22,MATCH(0,COUNTIF(P$2:P7,$M$3:$M$22),0))),\"\",INDEX($M$3:$M$22,MATCH(0,COUNTIF(P$2:P7,$M$3:$M$22),0)))","v":"Катя"},14,{"$f":"IFERROR(INDEX($M$3:$M$22,MATCH(0,IF(ISBLANK($M$3:$M$22),\"\",COUNTIF($R$2:R7,$M$3:$M$22)),0)),\"\")","v":"Катя"},14]
[null,"нужно получить следующее:",null,null,null,null,null,"Леша",5,"Федя",7,null,"Лена",3,null,{"$f":"IF(ISERROR(INDEX($M$3:$M$22,MATCH(0,COUNTIF(P$2:P8,$M$3:$M$22),0))),\"\",INDEX($M$3:$M$22,MATCH(0,COUNTIF(P$2:P8,$M$3:$M$22),0)))","v":""},null,{"$f":"IFERROR(INDEX($M$3:$M$22,MATCH(0,IF(ISBLANK($M$3:$M$22),\"\",COUNTIF($R$2:R8,$M$3:$M$22)),0)),\"\")","v":""}]
[null,null,null,null,null,null,null,"Федя",1,"Иван",9,null,"Катя",7,null,{"$f":"IF(ISERROR(INDEX($M$3:$M$22,MATCH(0,COUNTIF(P$2:P9,$M$3:$M$22),0))),\"\",INDEX($M$3:$M$22,MATCH(0,COUNTIF(P$2:P9,$M$3:$M$22),0)))","v":""},null,{"$f":"IFERROR(INDEX($M$3:$M$22,MATCH(0,IF(ISBLANK($M$3:$M$22),\"\",COUNTIF($R$2:R9,$M$3:$M$22)),0)),\"\")","v":""}]
[null,"Имя","Значение",null,null,null,null,"Иван",5,"Петр",9,null,"Лена",3,null,{"$f":"IF(ISERROR(INDEX($M$3:$M$22,MATCH(0,COUNTIF(P$2:P10,$M$3:$M$22),0))),\"\",INDEX($M$3:$M$22,MATCH(0,COUNTIF(P$2:P10,$M$3:$M$22),0)))","v":""},null,{"$f":"IFERROR(INDEX($M$3:$M$22,MATCH(0,IF(ISBLANK($M$3:$M$22),\"\",COUNTIF($R$2:R10,$M$3:$M$22)),0)),\"\")","v":""}]
[null,"Иван",14,null,null,null,null,"Леша",5,"Федя",7,null,"Катя",7,null,{"$f":"IF(ISERROR(INDEX($M$3:$M$22,MATCH(0,COUNTIF(P$2:P11,$M$3:$M$22),0))),\"\",INDEX($M$3:$M$22,MATCH(0,COUNTIF(P$2:P11,$M$3:$M$22),0)))","v":""},null,{"$f":"IFERROR(INDEX($M$3:$M$22,MATCH(0,IF(ISBLANK($M$3:$M$22),\"\",COUNTIF($R$2:R11,$M$3:$M$22)),0)),\"\")","v":""}]
[null,"Петр",9,null,null,null,null,null,null,null,null,null,"Иван",5,null,{"$f":"IF(ISERROR(INDEX($M$3:$M$22,MATCH(0,COUNTIF(P$2:P12,$M$3:$M$22),0))),\"\",INDEX($M$3:$M$22,MATCH(0,COUNTIF(P$2:P12,$M$3:$M$22),0)))","v":""},null,{"$f":"IFERROR(INDEX($M$3:$M$22,MATCH(0,IF(ISBLANK($M$3:$M$22),\"\",COUNTIF($R$2:R12,$M$3:$M$22)),0)),\"\")","v":""}]
[null,"Федя",8,null,null,null,null,null,null,null,null,null,"Петр",9,null,{"$f":"IF(ISERROR(INDEX($M$3:$M$22,MATCH(0,COUNTIF(P$2:P13,$M$3:$M$22),0))),\"\",INDEX($M$3:$M$22,MATCH(0,COUNTIF(P$2:P13,$M$3:$M$22),0)))","v":""},null,{"$f":"IFERROR(INDEX($M$3:$M$22,MATCH(0,IF(ISBLANK($M$3:$M$22),\"\",COUNTIF($R$2:R13,$M$3:$M$22)),0)),\"\")","v":""}]
[null,"Катя",7,null,null,null,null,null,null,null,null,null,"Леша",5,null,{"$f":"IF(ISERROR(INDEX($M$3:$M$22,MATCH(0,COUNTIF(P$2:P14,$M$3:$M$22),0))),\"\",INDEX($M$3:$M$22,MATCH(0,COUNTIF(P$2:P14,$M$3:$M$22),0)))","v":""},null,{"$f":"IFERROR(INDEX($M$3:$M$22,MATCH(0,IF(ISBLANK($M$3:$M$22),\"\",COUNTIF($R$2:R14,$M$3:$M$22)),0)),\"\")","v":""}]
[null,"Леша",5,null,null,null,null,null,null,null,null,null,"Федя",7,null,null,null,{"$f":"IFERROR(INDEX($M$3:$M$22,MATCH(0,IF(ISBLANK($M$3:$M$22),\"\",COUNTIF($R$2:R15,$M$3:$M$22)),0)),\"\")","v":""}]
[null,"Лена",3,null,null,null,null,null,null,null,null,null,"Федя",1,null,{"$f":"IF(ISERROR(INDEX($M$3:$M$22,MATCH(0,COUNTIF(P$2:P16,$M$3:$M$22),0))),\"\",INDEX($M$3:$M$22,MATCH(0,COUNTIF(P$2:P16,$M$3:$M$22),0)))","v":""},null,{"$f":"IFERROR(INDEX($M$3:$M$22,MATCH(0,IF(ISBLANK($M$3:$M$22),\"\",COUNTIF($R$2:R16,$M$3:$M$22)),0)),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Иван",9,null,{"$f":"IF(ISERROR(INDEX($M$3:$M$22,MATCH(0,COUNTIF(P$2:P17,$M$3:$M$22),0))),\"\",INDEX($M$3:$M$22,MATCH(0,COUNTIF(P$2:P17,$M$3:$M$22),0)))","v":""},null,{"$f":"IFERROR(INDEX($M$3:$M$22,MATCH(0,IF(ISBLANK($M$3:$M$22),\"\",COUNTIF($R$2:R17,$M$3:$M$22)),0)),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Иван",5,null,{"$f":"IF(ISERROR(INDEX($M$3:$M$22,MATCH(0,COUNTIF(P$2:P18,$M$3:$M$22),0))),\"\",INDEX($M$3:$M$22,MATCH(0,COUNTIF(P$2:P18,$M$3:$M$22),0)))","v":""},null,{"$f":"IFERROR(INDEX($M$3:$M$22,MATCH(0,IF(ISBLANK($M$3:$M$22),\"\",COUNTIF($R$2:R18,$M$3:$M$22)),0)),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Петр",9,null,{"$f":"IF(ISERROR(INDEX($M$3:$M$22,MATCH(0,COUNTIF(P$2:P19,$M$3:$M$22),0))),\"\",INDEX($M$3:$M$22,MATCH(0,COUNTIF(P$2:P19,$M$3:$M$22),0)))","v":""},null,{"$f":"IFERROR(INDEX($M$3:$M$22,MATCH(0,IF(ISBLANK($M$3:$M$22),\"\",COUNTIF($R$2:R19,$M$3:$M$22)),0)),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Леша",5,null,{"$f":"IF(ISERROR(INDEX($M$3:$M$22,MATCH(0,COUNTIF(P$2:P20,$M$3:$M$22),0))),\"\",INDEX($M$3:$M$22,MATCH(0,COUNTIF(P$2:P20,$M$3:$M$22),0)))","v":""},null,{"$f":"IFERROR(INDEX($M$3:$M$22,MATCH(0,IF(ISBLANK($M$3:$M$22),\"\",COUNTIF($R$2:R20,$M$3:$M$22)),0)),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Федя",7,null,{"$f":"IF(ISERROR(INDEX($M$3:$M$22,MATCH(0,COUNTIF(P$2:P21,$M$3:$M$22),0))),\"\",INDEX($M$3:$M$22,MATCH(0,COUNTIF(P$2:P21,$M$3:$M$22),0)))","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(H$12:H$19,MATCH(0,COUNTIF(H$12:H27,H$12:H$19),0)),\"\")","v":""}]
[null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(H$12:H$19,MATCH(0,COUNTIF(H$12:H28,H$12:H$19),0)),\"\")","v":""}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($H$3:$K$8,IF(MOD(ROW(H35),2)>0,ROW(H35)-(ROW(H35)+1)/2,ROW(H35)-(ROW(H35))/2-1),IF(MOD(ROW(H35),2)>0,COLUMN(H$3)-7,COLUMN(H$3)-5)),\"\")","v":""},{"$f":"IFERROR(INDEX($H$3:$K$8,IF(MOD(ROW(I35),2)>0,ROW(I35)-(ROW(I35)+1)/2,ROW(I35)-(ROW(I35))/2-1),IF(MOD(ROW(I35),2)>0,COLUMN(I$3)-7,COLUMN(I$3)-5)),\"\")","v":""}]

{"sheet":"Лист2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}