{"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":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":"лист","index":0,"n_rows":27,"n_cols":22,"rows_kept":27,"cut":false,"hidden":false,"merged":[[1,0,1,4],[1,7,1,9],[1,11,1,13],[1,15,1,17]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"курьер","курьер 1"]
["Таблица основная",null,null,null,null,null,null,"Таблица 1",null,null,null,"Таблица  2",null,null,null,"Таблица  2"]
["номер","адрес/название","время","сумма","курьер","курьер 1",null,"п/н","Адрес","Сумма",null,"п/н","Адрес","Сумма",null,"п/н","Адрес","Сумма",null,null,"Адрес ","Сумма "]
[1,"ул Первая",null,1,"курьер 1",null,null,1,{"$f":"IF(E4=$F$3,B4,\"\")","v":"ул Первая"},{"$f":"IF(E4=$F$3,D4,\"\")","v":1},null,1,{"$f":"IFERROR(INDEX(I$4:I$23,SMALL(IF(I$4:I$23<>\"\",$H$4:$H$23),ROW(M1))),\"\")","v":"ул Первая"},{"$f":"IFERROR(INDEX(J$4:J$23,SMALL(IF(J$4:J$23<>\"\",$H$4:$H$23),ROW(N1))),\"\")","v":1},null,1,{"$f":"IFERROR(INDEX(B$4:B$23,SMALL(IF(E$4:E$23<>\"\",$A$4:$A$23),ROW(Q1))),\"\")","v":"ул Первая"},{"$f":"IFERROR(INDEX(D$4:D$23,SMALL(IF(E$4:E$23<>\"\",$A$4:$A$23),ROW(R1))),\"\")","v":1},null,null,"ул Вторая",7]
[2,"ул Вторая",null,2,null,null,null,2,"","",null,2,{"$f":"IFERROR(INDEX(I$4:I$23,SMALL(IF(I$4:I$23<>\"\",$H$4:$H$23),ROW(M2))),\"\")","v":"ул Первая"},{"$f":"IFERROR(INDEX(J$4:J$23,SMALL(IF(J$4:J$23<>\"\",$H$4:$H$23),ROW(N2))),\"\")","v":4},null,2,{"$f":"IFERROR(INDEX(B$4:B$23,SMALL(IF(E$4:E$23<>\"\",$A$4:$A$23),ROW(Q2))),\"\")","v":"ул Первая"},{"$f":"IFERROR(INDEX(D$4:D$23,SMALL(IF(E$4:E$23<>\"\",$A$4:$A$23),ROW(R2))),\"\")","v":4},null,null,"ул Первая",14]
[3,"ул Первая",null,3,null,null,null,3,"","",null,3,{"$f":"IFERROR(INDEX(I$4:I$23,SMALL(IF(I$4:I$23<>\"\",$H$4:$H$23),ROW(M3))),\"\")","v":"ул Третья"},{"$f":"IFERROR(INDEX(J$4:J$23,SMALL(IF(J$4:J$23<>\"\",$H$4:$H$23),ROW(N3))),\"\")","v":5},null,3,{"$f":"IFERROR(INDEX(B$4:B$23,SMALL(IF(E$4:E$23<>\"\",$A$4:$A$23),ROW(Q3))),\"\")","v":"ул Третья"},{"$f":"IFERROR(INDEX(D$4:D$23,SMALL(IF(E$4:E$23<>\"\",$A$4:$A$23),ROW(R3))),\"\")","v":5},null,null,"ул Третья",5]
[4,"ул Первая",null,4,"курьер 1",null,null,4,"ул Первая",4,null,4,{"$f":"IFERROR(INDEX(I$4:I$23,SMALL(IF(I$4:I$23<>\"\",$H$4:$H$23),ROW(M4))),\"\")","v":"ул Вторая"},{"$f":"IFERROR(INDEX(J$4:J$23,SMALL(IF(J$4:J$23<>\"\",$H$4:$H$23),ROW(N4))),\"\")","v":7},null,4,{"$f":"IFERROR(INDEX(B$4:B$23,SMALL(IF(E$4:E$23<>\"\",$A$4:$A$23),ROW(Q4))),\"\")","v":"ул Вторая"},{"$f":"IFERROR(INDEX(D$4:D$23,SMALL(IF(E$4:E$23<>\"\",$A$4:$A$23),ROW(R4))),\"\")","v":7},null,null,"Общий итог",26]
[5,"ул Третья",null,5,"курьер 1",null,null,5,"ул Третья",5,null,5,{"$f":"IFERROR(INDEX(I$4:I$23,SMALL(IF(I$4:I$23<>\"\",$H$4:$H$23),ROW(M5))),\"\")","v":"ул Первая"},{"$f":"IFERROR(INDEX(J$4:J$23,SMALL(IF(J$4:J$23<>\"\",$H$4:$H$23),ROW(N5))),\"\")","v":9},null,5,{"$f":"IFERROR(INDEX(B$4:B$23,SMALL(IF(E$4:E$23<>\"\",$A$4:$A$23),ROW(Q5))),\"\")","v":"ул Первая"},{"$f":"IFERROR(INDEX(D$4:D$23,SMALL(IF(E$4:E$23<>\"\",$A$4:$A$23),ROW(R5))),\"\")","v":9}]
[6,"ул Пятая",null,6,null,null,null,6,"","",null,6,{"$f":"IFERROR(INDEX(I$4:I$23,SMALL(IF(I$4:I$23<>\"\",$H$4:$H$23),ROW(M6))),\"\")","v":""},{"$f":"IFERROR(INDEX(J$4:J$23,SMALL(IF(J$4:J$23<>\"\",$H$4:$H$23),ROW(N6))),\"\")","v":""},null,6,{"$f":"IFERROR(INDEX(B$4:B$23,SMALL(IF(E$4:E$23<>\"\",$A$4:$A$23),ROW(Q6))),\"\")","v":""},{"$f":"IFERROR(INDEX(D$4:D$23,SMALL(IF(E$4:E$23<>\"\",$A$4:$A$23),ROW(R6))),\"\")","v":""}]
[7,"ул Вторая",null,7,"курьер 1",null,null,7,"ул Вторая",7,null,7,{"$f":"IFERROR(INDEX(I$4:I$23,SMALL(IF(I$4:I$23<>\"\",$H$4:$H$23),ROW(M7))),\"\")","v":""},{"$f":"IFERROR(INDEX(J$4:J$23,SMALL(IF(J$4:J$23<>\"\",$H$4:$H$23),ROW(N7))),\"\")","v":""},null,7,{"$f":"IFERROR(INDEX(B$4:B$23,SMALL(IF(E$4:E$23<>\"\",$A$4:$A$23),ROW(Q7))),\"\")","v":""},{"$f":"IFERROR(INDEX(D$4:D$23,SMALL(IF(E$4:E$23<>\"\",$A$4:$A$23),ROW(R7))),\"\")","v":""}]
[8,"ул Первая",null,8,null,null,null,8,"","",null,8,{"$f":"IFERROR(INDEX(I$4:I$23,SMALL(IF(I$4:I$23<>\"\",$H$4:$H$23),ROW(M8))),\"\")","v":""},{"$f":"IFERROR(INDEX(J$4:J$23,SMALL(IF(J$4:J$23<>\"\",$H$4:$H$23),ROW(N8))),\"\")","v":""},null,8,{"$f":"IFERROR(INDEX(B$4:B$23,SMALL(IF(E$4:E$23<>\"\",$A$4:$A$23),ROW(Q8))),\"\")","v":""},{"$f":"IFERROR(INDEX(D$4:D$23,SMALL(IF(E$4:E$23<>\"\",$A$4:$A$23),ROW(R8))),\"\")","v":""}]
[9,"ул Первая",null,9,"курьер 1",null,null,9,"ул Первая",9,null,9,{"$f":"IFERROR(INDEX(I$4:I$23,SMALL(IF(I$4:I$23<>\"\",$H$4:$H$23),ROW(M9))),\"\")","v":""},{"$f":"IFERROR(INDEX(J$4:J$23,SMALL(IF(J$4:J$23<>\"\",$H$4:$H$23),ROW(N9))),\"\")","v":""},null,9,{"$f":"IFERROR(INDEX(B$4:B$23,SMALL(IF(E$4:E$23<>\"\",$A$4:$A$23),ROW(Q9))),\"\")","v":""},{"$f":"IFERROR(INDEX(D$4:D$23,SMALL(IF(E$4:E$23<>\"\",$A$4:$A$23),ROW(R9))),\"\")","v":""}]
[10,null,null,null,null,null,null,10,"","",null,10,{"$f":"IFERROR(INDEX(I$4:I$23,SMALL(IF(I$4:I$23<>\"\",$H$4:$H$23),ROW(M10))),\"\")","v":""},{"$f":"IFERROR(INDEX(J$4:J$23,SMALL(IF(J$4:J$23<>\"\",$H$4:$H$23),ROW(N10))),\"\")","v":""},null,10,{"$f":"IFERROR(INDEX(B$4:B$23,SMALL(IF(E$4:E$23<>\"\",$A$4:$A$23),ROW(Q10))),\"\")","v":""},{"$f":"IFERROR(INDEX(D$4:D$23,SMALL(IF(E$4:E$23<>\"\",$A$4:$A$23),ROW(R10))),\"\")","v":""}]
[11,null,null,null,null,null,null,11,"","",null,11,{"$f":"IFERROR(INDEX(I$4:I$23,SMALL(IF(I$4:I$23<>\"\",$H$4:$H$23),ROW(M11))),\"\")","v":""},{"$f":"IFERROR(INDEX(J$4:J$23,SMALL(IF(J$4:J$23<>\"\",$H$4:$H$23),ROW(N11))),\"\")","v":""},null,11,{"$f":"IFERROR(INDEX(B$4:B$23,SMALL(IF(E$4:E$23<>\"\",$A$4:$A$23),ROW(Q11))),\"\")","v":""},{"$f":"IFERROR(INDEX(D$4:D$23,SMALL(IF(E$4:E$23<>\"\",$A$4:$A$23),ROW(R11))),\"\")","v":""}]
[12,null,null,null,null,null,null,12,"","",null,12,{"$f":"IFERROR(INDEX(I$4:I$23,SMALL(IF(I$4:I$23<>\"\",$H$4:$H$23),ROW(M12))),\"\")","v":""},{"$f":"IFERROR(INDEX(J$4:J$23,SMALL(IF(J$4:J$23<>\"\",$H$4:$H$23),ROW(N12))),\"\")","v":""},null,12,{"$f":"IFERROR(INDEX(B$4:B$23,SMALL(IF(E$4:E$23<>\"\",$A$4:$A$23),ROW(Q12))),\"\")","v":""},{"$f":"IFERROR(INDEX(D$4:D$23,SMALL(IF(E$4:E$23<>\"\",$A$4:$A$23),ROW(R12))),\"\")","v":""}]
[13,null,null,null,null,null,null,13,"","",null,13,{"$f":"IFERROR(INDEX(I$4:I$23,SMALL(IF(I$4:I$23<>\"\",$H$4:$H$23),ROW(M13))),\"\")","v":""},{"$f":"IFERROR(INDEX(J$4:J$23,SMALL(IF(J$4:J$23<>\"\",$H$4:$H$23),ROW(N13))),\"\")","v":""},null,13,{"$f":"IFERROR(INDEX(B$4:B$23,SMALL(IF(E$4:E$23<>\"\",$A$4:$A$23),ROW(Q13))),\"\")","v":""},{"$f":"IFERROR(INDEX(D$4:D$23,SMALL(IF(E$4:E$23<>\"\",$A$4:$A$23),ROW(R13))),\"\")","v":""}]
[14,null,null,null,null,null,null,14,"","",null,14,{"$f":"IFERROR(INDEX(I$4:I$23,SMALL(IF(I$4:I$23<>\"\",$H$4:$H$23),ROW(M14))),\"\")","v":""},{"$f":"IFERROR(INDEX(J$4:J$23,SMALL(IF(J$4:J$23<>\"\",$H$4:$H$23),ROW(N14))),\"\")","v":""},null,14,{"$f":"IFERROR(INDEX(B$4:B$23,SMALL(IF(E$4:E$23<>\"\",$A$4:$A$23),ROW(Q14))),\"\")","v":""},{"$f":"IFERROR(INDEX(D$4:D$23,SMALL(IF(E$4:E$23<>\"\",$A$4:$A$23),ROW(R14))),\"\")","v":""}]
[15,null,null,null,null,null,null,15,"","",null,15,{"$f":"IFERROR(INDEX(I$4:I$23,SMALL(IF(I$4:I$23<>\"\",$H$4:$H$23),ROW(M15))),\"\")","v":""},{"$f":"IFERROR(INDEX(J$4:J$23,SMALL(IF(J$4:J$23<>\"\",$H$4:$H$23),ROW(N15))),\"\")","v":""},null,15,{"$f":"IFERROR(INDEX(B$4:B$23,SMALL(IF(E$4:E$23<>\"\",$A$4:$A$23),ROW(Q15))),\"\")","v":""},{"$f":"IFERROR(INDEX(D$4:D$23,SMALL(IF(E$4:E$23<>\"\",$A$4:$A$23),ROW(R15))),\"\")","v":""}]
[16,null,null,null,null,null,null,16,"","",null,16,{"$f":"IFERROR(INDEX(I$4:I$23,SMALL(IF(I$4:I$23<>\"\",$H$4:$H$23),ROW(M16))),\"\")","v":""},{"$f":"IFERROR(INDEX(J$4:J$23,SMALL(IF(J$4:J$23<>\"\",$H$4:$H$23),ROW(N16))),\"\")","v":""},null,16,{"$f":"IFERROR(INDEX(B$4:B$23,SMALL(IF(E$4:E$23<>\"\",$A$4:$A$23),ROW(Q16))),\"\")","v":""},{"$f":"IFERROR(INDEX(D$4:D$23,SMALL(IF(E$4:E$23<>\"\",$A$4:$A$23),ROW(R16))),\"\")","v":""}]
[17,null,null,null,null,null,null,17,"","",null,17,{"$f":"IFERROR(INDEX(I$4:I$23,SMALL(IF(I$4:I$23<>\"\",$H$4:$H$23),ROW(M17))),\"\")","v":""},{"$f":"IFERROR(INDEX(J$4:J$23,SMALL(IF(J$4:J$23<>\"\",$H$4:$H$23),ROW(N17))),\"\")","v":""},null,17,{"$f":"IFERROR(INDEX(B$4:B$23,SMALL(IF(E$4:E$23<>\"\",$A$4:$A$23),ROW(Q17))),\"\")","v":""},{"$f":"IFERROR(INDEX(D$4:D$23,SMALL(IF(E$4:E$23<>\"\",$A$4:$A$23),ROW(R17))),\"\")","v":""}]
[18,null,null,null,null,null,null,18,"","",null,18,{"$f":"IFERROR(INDEX(I$4:I$23,SMALL(IF(I$4:I$23<>\"\",$H$4:$H$23),ROW(M18))),\"\")","v":""},{"$f":"IFERROR(INDEX(J$4:J$23,SMALL(IF(J$4:J$23<>\"\",$H$4:$H$23),ROW(N18))),\"\")","v":""},null,18,{"$f":"IFERROR(INDEX(B$4:B$23,SMALL(IF(E$4:E$23<>\"\",$A$4:$A$23),ROW(Q18))),\"\")","v":""},{"$f":"IFERROR(INDEX(D$4:D$23,SMALL(IF(E$4:E$23<>\"\",$A$4:$A$23),ROW(R18))),\"\")","v":""}]
[19,null,null,null,null,null,null,19,"","",null,19,{"$f":"IFERROR(INDEX(I$4:I$23,SMALL(IF(I$4:I$23<>\"\",$H$4:$H$23),ROW(M19))),\"\")","v":""},{"$f":"IFERROR(INDEX(J$4:J$23,SMALL(IF(J$4:J$23<>\"\",$H$4:$H$23),ROW(N19))),\"\")","v":""},null,19,{"$f":"IFERROR(INDEX(B$4:B$23,SMALL(IF(E$4:E$23<>\"\",$A$4:$A$23),ROW(Q19))),\"\")","v":""},{"$f":"IFERROR(INDEX(D$4:D$23,SMALL(IF(E$4:E$23<>\"\",$A$4:$A$23),ROW(R19))),\"\")","v":""}]
[20,null,null,null,null,null,null,20,"","",null,20,{"$f":"IFERROR(INDEX(I$4:I$23,SMALL(IF(I$4:I$23<>\"\",$H$4:$H$23),ROW(M20))),\"\")","v":""},{"$f":"IFERROR(INDEX(J$4:J$23,SMALL(IF(J$4:J$23<>\"\",$H$4:$H$23),ROW(N20))),\"\")","v":""},null,20,{"$f":"IFERROR(INDEX(M$4:M$23,SMALL(IF(M$4:M$23<>\"\",$H$4:$H$23),ROW(Q20))),\"\")","v":""},{"$f":"IFERROR(INDEX(N$4:N$23,SMALL(IF(N$4:N$23<>\"\",$H$4:$H$23),ROW(R20))),\"\")","v":""}]
[]
[]
[]
[null,null,null,null,null,"Нужно чтобы из Таблицы 1 данные автоматически заполнялись в Таблице 2, но без промежуточных пустых строк?"]