{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["лист"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"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":"лист","index":0,"n_rows":27,"n_cols":14,"rows_kept":27,"cut":false,"hidden":false,"merged":[[1,0,1,4],[1,7,1,9],[1,11,1,13]]}
[]
["Таблица основная",null,null,null,null,null,null,"Таблица 1",null,null,null,"Таблица  2"]
["номер","адрес/название","время","сумма","курьер","курьер 1",null,"п/н","Адресс","Сумма",null,"п/н","Адресс","Сумма"]
[1,"ул Первая",null,1,"курьер 1",null,null,1,{"$f":"IFERROR(INDEX($B$4:$B$23,SMALL(IF($E$4:$E$23=$F$3,ROW($B$4:$B$23)-3),ROW(A1))),\"\")","v":"ул Первая"},{"$f":"IFERROR(INDEX($D$4:$D$23,SMALL(IF($E$4:$E$23=$F$3,ROW($D$4:$D$23)-3),ROW(A1))),\"\")","v":1},null,1,"ул Первая",1]
[2,"ул Вторая",null,2,null,null,null,2,{"$f":"IFERROR(INDEX($B$4:$B$23,SMALL(IF($E$4:$E$23=$F$3,ROW($B$4:$B$23)-3),ROW(A2))),\"\")","v":"ул Первая"},{"$f":"IFERROR(INDEX($D$4:$D$23,SMALL(IF($E$4:$E$23=$F$3,ROW($D$4:$D$23)-3),ROW(A2))),\"\")","v":4},null,2,"ул Первая",4]
[3,"ул Первая",null,3,null,null,null,3,{"$f":"IFERROR(INDEX($B$4:$B$23,SMALL(IF($E$4:$E$23=$F$3,ROW($B$4:$B$23)-3),ROW(A3))),\"\")","v":"ул Третья"},{"$f":"IFERROR(INDEX($D$4:$D$23,SMALL(IF($E$4:$E$23=$F$3,ROW($D$4:$D$23)-3),ROW(A3))),\"\")","v":5},null,3,"ул Третья",5]
[4,"ул Первая",null,4,"курьер 1",null,null,4,{"$f":"IFERROR(INDEX($B$4:$B$23,SMALL(IF($E$4:$E$23=$F$3,ROW($B$4:$B$23)-3),ROW(A4))),\"\")","v":"ул Вторая"},{"$f":"IFERROR(INDEX($D$4:$D$23,SMALL(IF($E$4:$E$23=$F$3,ROW($D$4:$D$23)-3),ROW(A4))),\"\")","v":7},null,4,"ул Вторая",7]
[5,"ул Третья",null,5,"курьер 1",null,null,5,{"$f":"IFERROR(INDEX($B$4:$B$23,SMALL(IF($E$4:$E$23=$F$3,ROW($B$4:$B$23)-3),ROW(A5))),\"\")","v":"ул Первая"},{"$f":"IFERROR(INDEX($D$4:$D$23,SMALL(IF($E$4:$E$23=$F$3,ROW($D$4:$D$23)-3),ROW(A5))),\"\")","v":9},null,5,"ул Первая",9]
[6,"ул Пятая",null,6,null,null,null,6,{"$f":"IFERROR(INDEX($B$4:$B$23,SMALL(IF($E$4:$E$23=$F$3,ROW($B$4:$B$23)-3),ROW(A6))),\"\")","v":""},{"$f":"IFERROR(INDEX($D$4:$D$23,SMALL(IF($E$4:$E$23=$F$3,ROW($D$4:$D$23)-3),ROW(A6))),\"\")","v":""},null,6]
[7,"ул Вторая",null,7,"курьер 1",null,null,7,{"$f":"IFERROR(INDEX($B$4:$B$23,SMALL(IF($E$4:$E$23=$F$3,ROW($B$4:$B$23)-3),ROW(A7))),\"\")","v":""},{"$f":"IFERROR(INDEX($D$4:$D$23,SMALL(IF($E$4:$E$23=$F$3,ROW($D$4:$D$23)-3),ROW(A7))),\"\")","v":""},null,7]
[8,"ул Первая",null,8,null,null,null,8,{"$f":"IFERROR(INDEX($B$4:$B$23,SMALL(IF($E$4:$E$23=$F$3,ROW($B$4:$B$23)-3),ROW(A8))),\"\")","v":""},{"$f":"IFERROR(INDEX($D$4:$D$23,SMALL(IF($E$4:$E$23=$F$3,ROW($D$4:$D$23)-3),ROW(A8))),\"\")","v":""},null,8]
[9,"ул Первая",null,9,"курьер 1",null,null,9,{"$f":"IFERROR(INDEX($B$4:$B$23,SMALL(IF($E$4:$E$23=$F$3,ROW($B$4:$B$23)-3),ROW(A9))),\"\")","v":""},{"$f":"IFERROR(INDEX($D$4:$D$23,SMALL(IF($E$4:$E$23=$F$3,ROW($D$4:$D$23)-3),ROW(A9))),\"\")","v":""},null,9]
[10,null,null,null,null,null,null,10,{"$f":"IFERROR(INDEX($B$4:$B$23,SMALL(IF($E$4:$E$23=$F$3,ROW($B$4:$B$23)-3),ROW(A10))),\"\")","v":""},{"$f":"IFERROR(INDEX($D$4:$D$23,SMALL(IF($E$4:$E$23=$F$3,ROW($D$4:$D$23)-3),ROW(A10))),\"\")","v":""},null,10]
[11,null,null,null,null,null,null,11,{"$f":"IFERROR(INDEX($B$4:$B$23,SMALL(IF($E$4:$E$23=$F$3,ROW($B$4:$B$23)-3),ROW(A11))),\"\")","v":""},{"$f":"IFERROR(INDEX($D$4:$D$23,SMALL(IF($E$4:$E$23=$F$3,ROW($D$4:$D$23)-3),ROW(A11))),\"\")","v":""},null,11]
[12,null,null,null,null,null,null,12,{"$f":"IFERROR(INDEX($B$4:$B$23,SMALL(IF($E$4:$E$23=$F$3,ROW($B$4:$B$23)-3),ROW(A12))),\"\")","v":""},{"$f":"IFERROR(INDEX($D$4:$D$23,SMALL(IF($E$4:$E$23=$F$3,ROW($D$4:$D$23)-3),ROW(A12))),\"\")","v":""},null,12]
[13,null,null,null,null,null,null,13,{"$f":"IFERROR(INDEX($B$4:$B$23,SMALL(IF($E$4:$E$23=$F$3,ROW($B$4:$B$23)-3),ROW(A13))),\"\")","v":""},{"$f":"IFERROR(INDEX($D$4:$D$23,SMALL(IF($E$4:$E$23=$F$3,ROW($D$4:$D$23)-3),ROW(A13))),\"\")","v":""},null,13]
[14,null,null,null,null,null,null,14,{"$f":"IFERROR(INDEX($B$4:$B$23,SMALL(IF($E$4:$E$23=$F$3,ROW($B$4:$B$23)-3),ROW(A14))),\"\")","v":""},{"$f":"IFERROR(INDEX($D$4:$D$23,SMALL(IF($E$4:$E$23=$F$3,ROW($D$4:$D$23)-3),ROW(A14))),\"\")","v":""},null,14]
[15,null,null,null,null,null,null,15,{"$f":"IFERROR(INDEX($B$4:$B$23,SMALL(IF($E$4:$E$23=$F$3,ROW($B$4:$B$23)-3),ROW(A15))),\"\")","v":""},{"$f":"IFERROR(INDEX($D$4:$D$23,SMALL(IF($E$4:$E$23=$F$3,ROW($D$4:$D$23)-3),ROW(A15))),\"\")","v":""},null,15]
[16,null,null,null,null,null,null,16,{"$f":"IFERROR(INDEX($B$4:$B$23,SMALL(IF($E$4:$E$23=$F$3,ROW($B$4:$B$23)-3),ROW(A16))),\"\")","v":""},{"$f":"IFERROR(INDEX($D$4:$D$23,SMALL(IF($E$4:$E$23=$F$3,ROW($D$4:$D$23)-3),ROW(A16))),\"\")","v":""},null,16]
[17,null,null,null,null,null,null,17,{"$f":"IFERROR(INDEX($B$4:$B$23,SMALL(IF($E$4:$E$23=$F$3,ROW($B$4:$B$23)-3),ROW(A17))),\"\")","v":""},{"$f":"IFERROR(INDEX($D$4:$D$23,SMALL(IF($E$4:$E$23=$F$3,ROW($D$4:$D$23)-3),ROW(A17))),\"\")","v":""},null,17]
[18,null,null,null,null,null,null,18,{"$f":"IFERROR(INDEX($B$4:$B$23,SMALL(IF($E$4:$E$23=$F$3,ROW($B$4:$B$23)-3),ROW(A18))),\"\")","v":""},{"$f":"IFERROR(INDEX($D$4:$D$23,SMALL(IF($E$4:$E$23=$F$3,ROW($D$4:$D$23)-3),ROW(A18))),\"\")","v":""},null,18]
[19,null,null,null,null,null,null,19,{"$f":"IFERROR(INDEX($B$4:$B$23,SMALL(IF($E$4:$E$23=$F$3,ROW($B$4:$B$23)-3),ROW(A19))),\"\")","v":""},{"$f":"IFERROR(INDEX($D$4:$D$23,SMALL(IF($E$4:$E$23=$F$3,ROW($D$4:$D$23)-3),ROW(A19))),\"\")","v":""},null,19]
[20,null,null,null,null,null,null,20,{"$f":"IFERROR(INDEX($B$4:$B$23,SMALL(IF($E$4:$E$23=$F$3,ROW($B$4:$B$23)-3),ROW(A20))),\"\")","v":""},{"$f":"IFERROR(INDEX($D$4:$D$23,SMALL(IF($E$4:$E$23=$F$3,ROW($D$4:$D$23)-3),ROW(A20))),\"\")","v":""},null,20]
[]
[]
[]
[null,null,null,null,null,"Нужно чтобы из Таблицы 1 данные автоматически заполнялись в Таблице 2, но без промежуточных пустых строк?"]