{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Вопрос 1","Вопрос 2","Лист3"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":1,"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":20,"n_cols":17,"rows_kept":20,"cut":false,"hidden":false,"merged":[[13,14,19,14],[13,16,13,20],[14,16,14,20],[15,16,15,20],[16,16,16,20],[17,16,17,20],[18,16,18,20],[19,16,19,20],[2,3,3,12],[5,14,11,14],[5,16,5,20],[6,16,6,20],[7,16,7,20],[8,16,8,20],[9,16,9,20],[10,16,10,20],[11,16,11,20],[11,5,11,9],[3,14,3,20],[1,3,1,12],[13,3,19,3],[13,5,13,9],[14,5,14,9],[15,5,15,9],[16,5,16,9],[17,5,17,9],[18,5,18,9],[19,5,19,9],[5,3,11,3],[5,5,5,9],[6,5,6,9],[7,5,7,9],[8,5,8,9],[9,5,9,9],[10,5,10,9]]}
[]
[null,null,null,"ВОПРОС № 1"]
[null,null,null,"Как в ячейке F8 протянуть через ВПР (искомое значение D6  (или другое) значения E из таблицы BE \"Вопрос 2\"  при условии, что там два одинаковых искомых значения, но разные значения этих искомых значений."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Вот так должно быть"]
[]
[null,null,null,1,"Снижение",null,null,null,null,null,null,null,null,null,1,"Снижение"]
[null,null,null,null,"Ндин/Рзатр",null,null,null,null,null,null,null,null,null,null,"Ндин/Рзатр"]
[null,null,null,null,"Пробы",{"$f":"JoinArr(TRANSPOSE(LOOKUP(SMALL(IF('Вопрос 2'!$B$6:$B$29=D6,ROW('Вопрос 2'!$B$6:$B$29)),ROW($A$1:INDEX($A:$A,COUNTIF('Вопрос 2'!$B$6:$B$29,D6)))),ROW('Вопрос 2'!$B$6:$B$29),'Вопрос 2'!$D$6:$D$29)),\",\")","v":"418,207"},null,null,null,null,null,null,null,null,null,"Пробы","418, 207"]
[null,null,null,null,"Скребки",null,null,null,null,null,null,null,null,null,null,"Скребки"]
[null,null,null,null,"Штуцера",null,null,null,null,null,null,null,null,null,null,"Штуцера"]
[null,null,null,null,"АГЗУ",null,null,null,null,null,null,null,null,null,null,"АГЗУ"]
[null,null,null,null,"СВУ ",null,null,null,null,null,null,null,null,null,null,"СВУ "]
[]
[null,null,null,"25А","Снижение",null,null,null,null,null,null,null,null,null,"25А","Снижение"]
[null,null,null,null,"Ндин/Рзатр",null,null,null,null,null,null,null,null,null,null,"Ндин/Рзатр"]
[null,null,null,null,"Пробы",{"$f":"JoinArr(TRANSPOSE(LOOKUP(SMALL(IF('Вопрос 2'!$B$6:$B$29=D14,ROW('Вопрос 2'!$B$6:$B$29)),ROW($A$1:INDEX($A:$A,COUNTIF('Вопрос 2'!$B$6:$B$29,D14)))),ROW('Вопрос 2'!$B$6:$B$29),'Вопрос 2'!$D$6:$D$29)),\",\")","v":"1078,1080Г"},null,null,null,null,null,null,null,null,null,"Пробы","1078,1080Г"]
[null,null,null,null,"Скребки",null,null,null,null,null,null,null,null,null,null,"Скребки"]
[null,null,null,null,"Штуцера",null,null,null,null,null,null,null,null,null,null,"Штуцера"]
[null,null,null,null,"АГЗУ",null,null,null,null,null,null,null,null,null,null,"АГЗУ"]
[null,null,null,null,"СВУ ",null,null,null,null,null,null,null,null,null,null,"СВУ "]

{"sheet":"Вопрос 2","index":1,"n_rows":29,"n_cols":8,"rows_kept":29,"cut":false,"hidden":false,"merged":[[3,7,3,16],[2,7,2,16]]}
[]
[]
[null,null,null,null,null,null,null,"ВОПРОС № 2"]
[null,null,null,null,null,null,null,"Как в колонке B Отделить буквы К, ВП, БК,аК,аВП,Р ?? "]
[]
[null,43,null,191,"43К"]
[null,"25А",null,1078,"25АВП"]
[null,15,null,1229,"15К"]
[null,12,null,1107,"12К"]
[null,"15Б",null,1221,"15БК"]
[null,3,null,908,"3ВП"]
[null,18,null,1076,"18К"]
[null,"25А",null,"1080Г","25АВП"]
[null,18,null,"636Г","18К"]
[null,5,null,"959Л","5ВП"]
[null,2,null,"209У","2Р"]
[null,37,null,"147Г","37К"]
[null,5,null,122,"5ВП"]
[null,3,null,405,"3ВП"]
[null,26,null,1169,"26К"]
[null,"7А",null,1196,"7аК"]
[null,21,null,847,"21ВП"]
[null,4,null,"928Л","4ВП"]
[null,9,null,837,"9АВП"]
[null,15,null,1219,"15К"]
[null,1,null,418,"1ВП"]
[null,8,null,924,"8К"]
[null,7,null,"1132Л","7К"]
[null,1,null,207,"1ВП"]

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