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