{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Лист1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":0,"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":37,"n_cols":11,"rows_kept":37,"cut":false,"hidden":false,"merged":[[29,3,29,5],[15,3,15,5],[16,3,16,5]]}
[null,null,null,null,null,null,null,null,"Специальность","Дизайн"]
[null,null,null,"№","ФИО","Специальность","Баллы"]
[null,null,null,1," Светлана Алексеевна","Дизайн",200,null,"№","ФИО","балл"]
[null,null,null,2," Виктор Григорьевич","Живопись",220,null,5," Ксения Дмитриевна",230]
[null,null,null,3," Валерия Сергеевна","Живопись",180,null,1," Светлана Алексеевна",200]
[null,null,null,4," Надежда Анатольевна","Дизайн",190,null,6," Екатерина Дмитриевна",195]
[null,null,null,5," Ксения Дмитриевна","Дизайн",230,null,4," Надежда Анатольевна",190]
[null,null,null,6," Екатерина Дмитриевна","Дизайн",195,null,"Общий итог",null,815]
[null,null,null,7," Екатерина Петровна","Живопись",205]
[null,null,null,8," Марина Олеговна","Живопись",190]
[null,null,null,9," Александра Михайловна","Живопись",185]
[null,null,null,10," Светлана Андреевна","Живопись",190]
[null,null,null,11," Дарья Вячеславовна","Живопись",210]
[null,null,null,12," Екатерина Геннадьевна","Живопись",215]
[]
[null,null,null,"Так нужно получить"]
[null,null,null,"Дизайн"]
[null,null,null,"№","ФИО","Специальность","Баллы"]
[null,null,null,{"$f":"IFERROR(INDEX($D$3:$D$14,SMALL(IF($F$3:$F$14=\"Дизайн\",ROW($D$3:$D$14)-2),ROW(D3)-2)),\"\")","v":1},{"$f":"IFERROR(INDEX($E$3:$G$14,MATCH($D19,$D$3:$D$14,0),MATCH(E$18,$E$2:$G$2,0)),\"\")","v":" Светлана Алексеевна"},{"$f":"IFERROR(INDEX($E$3:$G$14,MATCH($D19,$D$3:$D$14,0),MATCH(F$18,$E$2:$G$2,0)),\"\")","v":"Дизайн"},{"$f":"IFERROR(INDEX($E$3:$G$14,MATCH($D19,$D$3:$D$14,0),MATCH(G$18,$E$2:$G$2,0)),\"\")","v":200}]
[null,null,null,{"$f":"IFERROR(INDEX($D$3:$D$14,SMALL(IF($F$3:$F$14=\"Дизайн\",ROW($D$3:$D$14)-2),ROW(D4)-2)),\"\")","v":4},{"$f":"IFERROR(INDEX($E$3:$G$14,MATCH($D20,$D$3:$D$14,0),MATCH(E$18,$E$2:$G$2,0)),\"\")","v":" Надежда Анатольевна"},{"$f":"IFERROR(INDEX($E$3:$G$14,MATCH($D20,$D$3:$D$14,0),MATCH(F$18,$E$2:$G$2,0)),\"\")","v":"Дизайн"},{"$f":"IFERROR(INDEX($E$3:$G$14,MATCH($D20,$D$3:$D$14,0),MATCH(G$18,$E$2:$G$2,0)),\"\")","v":190}]
[null,null,null,{"$f":"IFERROR(INDEX($D$3:$D$14,SMALL(IF($F$3:$F$14=\"Дизайн\",ROW($D$3:$D$14)-2),ROW(D5)-2)),\"\")","v":5},{"$f":"IFERROR(INDEX($E$3:$G$14,MATCH($D21,$D$3:$D$14,0),MATCH(E$18,$E$2:$G$2,0)),\"\")","v":" Ксения Дмитриевна"},{"$f":"IFERROR(INDEX($E$3:$G$14,MATCH($D21,$D$3:$D$14,0),MATCH(F$18,$E$2:$G$2,0)),\"\")","v":"Дизайн"},{"$f":"IFERROR(INDEX($E$3:$G$14,MATCH($D21,$D$3:$D$14,0),MATCH(G$18,$E$2:$G$2,0)),\"\")","v":230}]
[null,null,null,{"$f":"IFERROR(INDEX($D$3:$D$14,SMALL(IF($F$3:$F$14=\"Дизайн\",ROW($D$3:$D$14)-2),ROW(D6)-2)),\"\")","v":6},{"$f":"IFERROR(INDEX($E$3:$G$14,MATCH($D22,$D$3:$D$14,0),MATCH(E$18,$E$2:$G$2,0)),\"\")","v":" Екатерина Дмитриевна"},{"$f":"IFERROR(INDEX($E$3:$G$14,MATCH($D22,$D$3:$D$14,0),MATCH(F$18,$E$2:$G$2,0)),\"\")","v":"Дизайн"},{"$f":"IFERROR(INDEX($E$3:$G$14,MATCH($D22,$D$3:$D$14,0),MATCH(G$18,$E$2:$G$2,0)),\"\")","v":195}]
[null,null,null,{"$f":"IFERROR(INDEX($D$3:$D$14,SMALL(IF($F$3:$F$14=\"Дизайн\",ROW($D$3:$D$14)-2),ROW(D7)-2)),\"\")","v":""},{"$f":"IFERROR(INDEX($E$3:$G$14,MATCH($D23,$D$3:$D$14,0),MATCH(E$18,$E$2:$G$2,0)),\"\")","v":""},{"$f":"IFERROR(INDEX($E$3:$G$14,MATCH($D23,$D$3:$D$14,0),MATCH(F$18,$E$2:$G$2,0)),\"\")","v":""},{"$f":"IFERROR(INDEX($E$3:$G$14,MATCH($D23,$D$3:$D$14,0),MATCH(G$18,$E$2:$G$2,0)),\"\")","v":""}]
[null,null,null,{"$f":"IFERROR(INDEX($D$3:$D$14,SMALL(IF($F$3:$F$14=\"Дизайн\",ROW($D$3:$D$14)-2),ROW(D8)-2)),\"\")","v":""},{"$f":"IFERROR(INDEX($E$3:$G$14,MATCH($D24,$D$3:$D$14,0),MATCH(E$18,$E$2:$G$2,0)),\"\")","v":""},{"$f":"IFERROR(INDEX($E$3:$G$14,MATCH($D24,$D$3:$D$14,0),MATCH(F$18,$E$2:$G$2,0)),\"\")","v":""},{"$f":"IFERROR(INDEX($E$3:$G$14,MATCH($D24,$D$3:$D$14,0),MATCH(G$18,$E$2:$G$2,0)),\"\")","v":""}]
[null,null,null,{"$f":"IFERROR(INDEX($D$3:$D$14,SMALL(IF($F$3:$F$14=\"Дизайн\",ROW($D$3:$D$14)-2),ROW(D9)-2)),\"\")","v":""},{"$f":"IFERROR(INDEX($E$3:$G$14,MATCH($D25,$D$3:$D$14,0),MATCH(E$18,$E$2:$G$2,0)),\"\")","v":""},{"$f":"IFERROR(INDEX($E$3:$G$14,MATCH($D25,$D$3:$D$14,0),MATCH(F$18,$E$2:$G$2,0)),\"\")","v":""},{"$f":"IFERROR(INDEX($E$3:$G$14,MATCH($D25,$D$3:$D$14,0),MATCH(G$18,$E$2:$G$2,0)),\"\")","v":""}]
[]
[]
[]
[]
[null,null,null,"Живопись"]
[null,null,null,"№","ФИО","Специальность"]
[null,null,null,{"$f":"IFERROR(INDEX($D$3:$D$14,SMALL(IF($F$3:$F$14=\"Живопись\",ROW($D$3:$D$14)-2),ROW(D3)-2)),\"\")","v":""}," Виктор Григорьевич","Живопись"]
[null,null,null,3," Валерия Сергеевна","Живопись"]
[null,null,null,8," Марина Олеговна","Живопись"]
[null,null,null,9," Александра Михайловна","Живопись"]
[null,null,null,10," Светлана Андреевна","Живопись"]
[null,null,null,11," Дарья Вячеславовна","Живопись"]