{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Zadání","Souhrn"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"comments":1,"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":"Zadání","index":0,"n_rows":50,"n_cols":5,"rows_kept":50,"cut":false,"hidden":false,"merged":[]}
["2023-01-01",54,"m",1,"xx"]
["2023-01-01",null,null,null,"xxxx"]
["2023-01-01",null,null,null,"xx"]
["2023-01-01",56,"p",1,"xxxx"]
["2023-01-01",null,null,null,"xx"]
["2023-01-01",null,null,null,"x"]
["2023-01-01",null,null,null,"xxxx"]
["2023-01-01",87,"m",2,"xxxxx"]
["2023-01-01",null,null,null,"xx"]
["2023-01-01",null,null,null,"xxxx"]
["2023-01-01",98,"o",1,"x"]
["2023-01-01",null,null,null,"xxx"]
["2023-01-01",null,null,null,"xxx"]
["2023-01-02",56,"o",2,"xx"]
["2023-01-02",null,null,null,"xxxx"]
["2023-01-02",null,null,null,"x"]
["2023-01-02",null,null,null,"xx"]
["2023-01-02",65,"m",3,"xxx"]
["2023-01-02",null,null,null,"xx"]
["2023-01-02",null,null,null,"xx"]
["2023-01-02",67,"p",2,"x"]
["2023-01-02",null,null,null,"xxxx"]
["2023-01-02",null,null,null,"xxxx"]
["2023-01-02",null,null,null,"x"]
["2023-01-02",85,"o",3,"xxx"]
["2023-01-02",null,null,null,"xxxxx"]
["2023-01-02",null,null,null,"xxxx"]
["2023-01-02",null,null,null,"xx"]
["2023-01-03",54,"o",4,"x"]
["2023-01-03",null,null,null,"xx"]
["2023-01-03",null,null,null,"xxx"]
["2023-01-03",41,"s",1,"xx"]
["2023-01-03",null,null,null,"xx"]
["2023-01-03",null,null,null,"x"]
["2023-01-03",20,"s",2,"xxxx"]
["2023-01-03",null,null,null,"xx"]
["2023-01-03",null,null,null,"x"]
["2023-01-03",21,"o",5,"xxxx"]
["2023-01-03",null,null,null,"xxxxx"]
["2023-01-03",null,null,null,"xx"]
["2023-01-04",87,"p",3,"xxxx"]
["2023-01-04",null,null,null,"xx"]
["2023-01-04",55,"o",6,"xx"]
["2023-01-04",null,null,null,"x"]
["2023-01-04",null,null,null,"xxxx"]
["2023-01-04",null,null,null,"xxxx"]
["2023-01-04",99,"o",7,"x"]
["2023-01-04",87,"o",8,"xx"]
["2023-01-05",1,"o",2]
["2023-01-06",2,"o",222]

{"sheet":"Souhrn","index":1,"n_rows":40,"n_cols":55,"rows_kept":40,"cut":false,"hidden":false,"merged":[[0,5,0,6],[0,2,0,3]]}
[null,null,"očekávaný výsledek",null,null,"příklad výsledku",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Označenia riadkov","54","m","1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Column1","Column2","Column3","Column4",null,null,null,null,null,null,null,null,null,null,"Cesta"]
["2023-01-01",54,{"$f":"VLOOKUP(B2,Zadání!B:C,2,FALSE)","v":"m"},null,null,"m",1,null,"Sloupec:",null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-01-01",56,"p",1,null,null,{"$f":"IFERROR(OFFSET(Zadání!$A$1:$D$1,SMALL(IF((OFFSET(OBLA,,1)<>\"\")*(OFFSET(OBLA,,3)<>\"\"),ROW(OBLA)-1,FALSE),ROW(A1)),),\"\")","v":"2023-01-01"},54,"m",1,null,null,{"$f":"_xlfn._xlws.FILTER(OFFSET(OBLA,,,,4),(OFFSET(OBLA,,1)<>\"\")*(OFFSET(OBLA,,3)<>\"\"),\"\")","v":"2023-01-01"},54,"m",1,null,null,"2023-01-01",54,"m",1,null,null,"2023-01-01",54,"m",1,null,null,null,null,{"$f":"SUBSTITUTE(LEFT(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1))-1),\"[\",\"\")","v":"E:\\Download\\Kopírovanie.xlsm"}]
["2023-01-01",56,{"$f":"VLOOKUP(B3,Zadání!B:C,2,FALSE)","v":"p"},null,null,"p",1,null,"A","ručně vypsané ze zadání",null,null,null,null,null,null,null,null,null,null,null,null,"2023-01-01",87,"m",2,null,null,{"$f":"IFERROR(OFFSET(Zadání!$A$1:$D$1,SMALL(IF((OFFSET(OBLA,,1)<>\"\")*(OFFSET(OBLA,,3)<>\"\"),ROW(OBLA)-1,FALSE),ROW(A2)),),\"\")","v":"2023-01-01"},56,"p",1,null,null,"2023-01-01",56,"p",1,null,null,"2023-01-01",56,"p",1,null,null,"2023-01-01",56,"p",1]
["2023-01-01",87,{"$f":"VLOOKUP(B4,Zadání!B:C,2,FALSE)","v":"m"},null,null,"m",2,null,"B","ručně vypsané ze zadání",null,null,null,null,null,null,null,null,null,null,null,null,"2023-01-01",98,"o",1,null,null,{"$f":"IFERROR(OFFSET(Zadání!$A$1:$D$1,SMALL(IF((OFFSET(OBLA,,1)<>\"\")*(OFFSET(OBLA,,3)<>\"\"),ROW(OBLA)-1,FALSE),ROW(A3)),),\"\")","v":"2023-01-01"},87,"m",2,null,null,"2023-01-01",87,"m",2,null,null,"2023-01-01",87,"m",2,null,null,"2023-01-01",87,"m",2]
["2023-01-01",98,{"$f":"VLOOKUP(B5,Zadání!B:C,2,FALSE)","v":"o"},null,null,"o",1,null,"C","potřebuji, aby se podle shody sloupce A a B vyplnila hodnota z listu zadání ze sloupce C",null,null,null,null,null,null,null,null,null,null,null,null,"2023-01-02",56,"o",2,null,null,{"$f":"IFERROR(OFFSET(Zadání!$A$1:$D$1,SMALL(IF((OFFSET(OBLA,,1)<>\"\")*(OFFSET(OBLA,,3)<>\"\"),ROW(OBLA)-1,FALSE),ROW(A4)),),\"\")","v":"2023-01-01"},98,"o",1,null,null,"2023-01-01",98,"o",1,null,null,"2023-01-01",98,"o",1,null,null,"2023-01-01",98,"o",1]
["2023-01-02",56,null,null,null,"o",2,null,"D","potřebuji, aby se podle shody sloupce A a B vyplnila hodnota z listu zadání ze sloupce D",null,null,null,null,null,null,null,null,null,null,null,null,"2023-01-02",65,"m",3,null,null,{"$f":"IFERROR(OFFSET(Zadání!$A$1:$D$1,SMALL(IF((OFFSET(OBLA,,1)<>\"\")*(OFFSET(OBLA,,3)<>\"\"),ROW(OBLA)-1,FALSE),ROW(A5)),),\"\")","v":"2023-01-02"},56,"o",2,null,null,"2023-01-02",56,"o",2,null,null,"2023-01-02",56,"o",2,null,null,"2023-01-02",56,"o",2]
["2023-01-02",65,null,null,null,"m",3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-01-02",67,"p",2,null,null,{"$f":"IFERROR(OFFSET(Zadání!$A$1:$D$1,SMALL(IF((OFFSET(OBLA,,1)<>\"\")*(OFFSET(OBLA,,3)<>\"\"),ROW(OBLA)-1,FALSE),ROW(A6)),),\"\")","v":"2023-01-02"},65,"m",3,null,null,"2023-01-02",65,"m",3,null,null,"2023-01-02",65,"m",3,null,null,"2023-01-02",65,"m",3]
["2023-01-02",67,null,null,null,"p",2,null,"F","příklad co by se mělo vyplnit",null,null,null,null,null,null,null,null,null,null,null,null,"2023-01-02",85,"o",3,null,null,{"$f":"IFERROR(OFFSET(Zadání!$A$1:$D$1,SMALL(IF((OFFSET(OBLA,,1)<>\"\")*(OFFSET(OBLA,,3)<>\"\"),ROW(OBLA)-1,FALSE),ROW(A7)),),\"\")","v":"2023-01-02"},67,"p",2,null,null,"2023-01-02",67,"p",2,null,null,"2023-01-02",67,"p",2,null,null,"2023-01-02",67,"p",2]
["2023-01-02",85,null,null,null,"o",3,null,"G","příklad co by se mělo vyplnit",null,null,null,null,null,null,null,null,null,null,null,null,"2023-01-03",20,"s",2,null,null,{"$f":"IFERROR(OFFSET(Zadání!$A$1:$D$1,SMALL(IF((OFFSET(OBLA,,1)<>\"\")*(OFFSET(OBLA,,3)<>\"\"),ROW(OBLA)-1,FALSE),ROW(A8)),),\"\")","v":"2023-01-02"},85,"o",3,null,null,"2023-01-02",85,"o",3,null,null,"2023-01-02",85,"o",3,null,null,"2023-01-02",85,"o",3]
["2023-01-03",54,null,null,null,"o",4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-01-03",21,"o",5,null,null,{"$f":"IFERROR(OFFSET(Zadání!$A$1:$D$1,SMALL(IF((OFFSET(OBLA,,1)<>\"\")*(OFFSET(OBLA,,3)<>\"\"),ROW(OBLA)-1,FALSE),ROW(A9)),),\"\")","v":"2023-01-03"},54,"o",4,null,null,"2023-01-03",54,"o",4,null,null,"2023-01-03",54,"o",4,null,null,"2023-01-03",54,"o",4]
["2023-01-03",41,null,null,null,"s",1,null,"V jednoduchosti to je jako bych zkopíroval celý list zadání, odstranil sloupce E a vyšsí a ve sloupcích B-D odstranil prázdné buňky formou celé řádky",null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-01-03",41,"s",1,null,null,{"$f":"IFERROR(OFFSET(Zadání!$A$1:$D$1,SMALL(IF((OFFSET(OBLA,,1)<>\"\")*(OFFSET(OBLA,,3)<>\"\"),ROW(OBLA)-1,FALSE),ROW(A10)),),\"\")","v":"2023-01-03"},41,"s",1,null,null,"2023-01-03",41,"s",1,null,null,"2023-01-03",41,"s",1,null,null,"2023-01-03",41,"s",1]
["2023-01-03",20,null,null,null,"s",2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-01-03",54,"o",4,null,null,{"$f":"IFERROR(OFFSET(Zadání!$A$1:$D$1,SMALL(IF((OFFSET(OBLA,,1)<>\"\")*(OFFSET(OBLA,,3)<>\"\"),ROW(OBLA)-1,FALSE),ROW(A11)),),\"\")","v":"2023-01-03"},20,"s",2,null,null,"2023-01-03",20,"s",2,null,null,"2023-01-03",20,"s",2,null,null,"2023-01-03",20,"s",2]
["2023-01-03",21,null,null,null,"o",5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-01-04",55,"o",6,null,null,{"$f":"IFERROR(OFFSET(Zadání!$A$1:$D$1,SMALL(IF((OFFSET(OBLA,,1)<>\"\")*(OFFSET(OBLA,,3)<>\"\"),ROW(OBLA)-1,FALSE),ROW(A12)),),\"\")","v":"2023-01-03"},21,"o",5,null,null,"2023-01-03",21,"o",5,null,null,"2023-01-03",21,"o",5,null,null,"2023-01-03",21,"o",5]
["2023-01-04",87,null,null,null,"p",3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-01-04",87,"o",8,null,null,{"$f":"IFERROR(OFFSET(Zadání!$A$1:$D$1,SMALL(IF((OFFSET(OBLA,,1)<>\"\")*(OFFSET(OBLA,,3)<>\"\"),ROW(OBLA)-1,FALSE),ROW(A13)),),\"\")","v":"2023-01-04"},87,"p",3,null,null,"2023-01-04",87,"p",3,null,null,"2023-01-04",87,"p",3,null,null,"2023-01-04",87,"p",3]
["2023-01-04",55,null,null,null,"o",6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-01-04",87,"p",3,null,null,{"$f":"IFERROR(OFFSET(Zadání!$A$1:$D$1,SMALL(IF((OFFSET(OBLA,,1)<>\"\")*(OFFSET(OBLA,,3)<>\"\"),ROW(OBLA)-1,FALSE),ROW(A14)),),\"\")","v":"2023-01-04"},55,"o",6,null,null,"2023-01-04",55,"o",6,null,null,"2023-01-04",55,"o",6,null,null,"2023-01-04",55,"o",6]
["2023-01-04",99,null,null,null,"o",7,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-01-04",99,"o",7,null,null,{"$f":"IFERROR(OFFSET(Zadání!$A$1:$D$1,SMALL(IF((OFFSET(OBLA,,1)<>\"\")*(OFFSET(OBLA,,3)<>\"\"),ROW(OBLA)-1,FALSE),ROW(A15)),),\"\")","v":"2023-01-04"},99,"o",7,null,null,"2023-01-04",99,"o",7,null,null,"2023-01-04",99,"o",7,null,null,"2023-01-04",99,"o",7]
["2023-01-04",87,null,null,null,"o",8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-01-05",1,"o",2,null,null,{"$f":"IFERROR(OFFSET(Zadání!$A$1:$D$1,SMALL(IF((OFFSET(OBLA,,1)<>\"\")*(OFFSET(OBLA,,3)<>\"\"),ROW(OBLA)-1,FALSE),ROW(A16)),),\"\")","v":"2023-01-04"},87,"o",8,null,null,"2023-01-04",87,"o",8,null,null,"2023-01-04",87,"o",8,null,null,"2023-01-04",87,"o",8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-01-06",2,"o",222,null,null,{"$f":"IFERROR(OFFSET(Zadání!$A$1:$D$1,SMALL(IF((OFFSET(OBLA,,1)<>\"\")*(OFFSET(OBLA,,3)<>\"\"),ROW(OBLA)-1,FALSE),ROW(A17)),),\"\")","v":"2023-01-05"},1,"o",2,null,null,"2023-01-05",1,"o",2,null,null,"2023-01-05",1,"o",2,null,null,"2023-01-05",1,"o",2]
[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,{"$f":"IFERROR(OFFSET(Zadání!$A$1:$D$1,SMALL(IF((OFFSET(OBLA,,1)<>\"\")*(OFFSET(OBLA,,3)<>\"\"),ROW(OBLA)-1,FALSE),ROW(A18)),),\"\")","v":"2023-01-06"},2,"o",222,null,null,"2023-01-06",2,"o",222,null,null,"2023-01-06",2,"o",222,null,null,"2023-01-06",2,"o",222]
[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,{"$f":"IFERROR(OFFSET(Zadání!$A$1:$D$1,SMALL(IF((OFFSET(OBLA,,1)<>\"\")*(OFFSET(OBLA,,3)<>\"\"),ROW(OBLA)-1,FALSE),ROW(A19)),),\"\")","v":""}]
[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,{"$f":"IFERROR(OFFSET(Zadání!$A$1:$D$1,SMALL(IF((OFFSET(OBLA,,1)<>\"\")*(OFFSET(OBLA,,3)<>\"\"),ROW(OBLA)-1,FALSE),ROW(A20)),),\"\")","v":""}]
[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,{"$f":"IFERROR(OFFSET(Zadání!$A$1:$D$1,SMALL(IF((OFFSET(OBLA,,1)<>\"\")*(OFFSET(OBLA,,3)<>\"\"),ROW(OBLA)-1,FALSE),ROW(A21)),),\"\")","v":""}]
[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,{"$f":"IFERROR(OFFSET(Zadání!$A$1:$D$1,SMALL(IF((OFFSET(OBLA,,1)<>\"\")*(OFFSET(OBLA,,3)<>\"\"),ROW(OBLA)-1,FALSE),ROW(A22)),),\"\")","v":""}]
[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,{"$f":"IFERROR(OFFSET(Zadání!$A$1:$D$1,SMALL(IF((OFFSET(OBLA,,1)<>\"\")*(OFFSET(OBLA,,3)<>\"\"),ROW(OBLA)-1,FALSE),ROW(A23)),),\"\")","v":""}]
[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,{"$f":"IFERROR(OFFSET(Zadání!$A$1:$D$1,SMALL(IF((OFFSET(OBLA,,1)<>\"\")*(OFFSET(OBLA,,3)<>\"\"),ROW(OBLA)-1,FALSE),ROW(A24)),),\"\")","v":""}]
[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,{"$f":"IFERROR(OFFSET(Zadání!$A$1:$D$1,SMALL(IF((OFFSET(OBLA,,1)<>\"\")*(OFFSET(OBLA,,3)<>\"\"),ROW(OBLA)-1,FALSE),ROW(A25)),),\"\")","v":""}]
[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,{"$f":"IFERROR(OFFSET(Zadání!$A$1:$D$1,SMALL(IF((OFFSET(OBLA,,1)<>\"\")*(OFFSET(OBLA,,3)<>\"\"),ROW(OBLA)-1,FALSE),ROW(A26)),),\"\")","v":""}]
[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,{"$f":"IFERROR(OFFSET(Zadání!$A$1:$D$1,SMALL(IF((OFFSET(OBLA,,1)<>\"\")*(OFFSET(OBLA,,3)<>\"\"),ROW(OBLA)-1,FALSE),ROW(A27)),),\"\")","v":""}]
[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,{"$f":"IFERROR(OFFSET(Zadání!$A$1:$D$1,SMALL(IF((OFFSET(OBLA,,1)<>\"\")*(OFFSET(OBLA,,3)<>\"\"),ROW(OBLA)-1,FALSE),ROW(A28)),),\"\")","v":""}]
[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,{"$f":"IFERROR(OFFSET(Zadání!$A$1:$D$1,SMALL(IF((OFFSET(OBLA,,1)<>\"\")*(OFFSET(OBLA,,3)<>\"\"),ROW(OBLA)-1,FALSE),ROW(A29)),),\"\")","v":""}]
[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,{"$f":"IFERROR(OFFSET(Zadání!$A$1:$D$1,SMALL(IF((OFFSET(OBLA,,1)<>\"\")*(OFFSET(OBLA,,3)<>\"\"),ROW(OBLA)-1,FALSE),ROW(A30)),),\"\")","v":""}]
[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,{"$f":"IFERROR(OFFSET(Zadání!$A$1:$D$1,SMALL(IF((OFFSET(OBLA,,1)<>\"\")*(OFFSET(OBLA,,3)<>\"\"),ROW(OBLA)-1,FALSE),ROW(A31)),),\"\")","v":""}]
[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,{"$f":"IFERROR(OFFSET(Zadání!$A$1:$D$1,SMALL(IF((OFFSET(OBLA,,1)<>\"\")*(OFFSET(OBLA,,3)<>\"\"),ROW(OBLA)-1,FALSE),ROW(A32)),),\"\")","v":""}]
[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,{"$f":"IFERROR(OFFSET(Zadání!$A$1:$D$1,SMALL(IF((OFFSET(OBLA,,1)<>\"\")*(OFFSET(OBLA,,3)<>\"\"),ROW(OBLA)-1,FALSE),ROW(A33)),),\"\")","v":""}]
[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,{"$f":"IFERROR(OFFSET(Zadání!$A$1:$D$1,SMALL(IF((OFFSET(OBLA,,1)<>\"\")*(OFFSET(OBLA,,3)<>\"\"),ROW(OBLA)-1,FALSE),ROW(A34)),),\"\")","v":""}]
[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,{"$f":"IFERROR(OFFSET(Zadání!$A$1:$D$1,SMALL(IF((OFFSET(OBLA,,1)<>\"\")*(OFFSET(OBLA,,3)<>\"\"),ROW(OBLA)-1,FALSE),ROW(A35)),),\"\")","v":""}]
[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,{"$f":"IFERROR(OFFSET(Zadání!$A$1:$D$1,SMALL(IF((OFFSET(OBLA,,1)<>\"\")*(OFFSET(OBLA,,3)<>\"\"),ROW(OBLA)-1,FALSE),ROW(A36)),),\"\")","v":""}]
[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,{"$f":"IFERROR(OFFSET(Zadání!$A$1:$D$1,SMALL(IF((OFFSET(OBLA,,1)<>\"\")*(OFFSET(OBLA,,3)<>\"\"),ROW(OBLA)-1,FALSE),ROW(A37)),),\"\")","v":""}]
[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,{"$f":"IFERROR(OFFSET(Zadání!$A$1:$D$1,SMALL(IF((OFFSET(OBLA,,1)<>\"\")*(OFFSET(OBLA,,3)<>\"\"),ROW(OBLA)-1,FALSE),ROW(A38)),),\"\")","v":""}]
[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,{"$f":"IFERROR(OFFSET(Zadání!$A$1:$D$1,SMALL(IF((OFFSET(OBLA,,1)<>\"\")*(OFFSET(OBLA,,3)<>\"\"),ROW(OBLA)-1,FALSE),ROW(A39)),),\"\")","v":""}]