{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Hárok1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"Hárok1","index":0,"n_rows":8,"n_cols":6,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["900100MP",null,{"$f":"IF(B1=\"\",IFERROR(INDEX(B:B,MATCH(LEFT(A1,6),IF($B$1:$B$5=\"\",\"\",LEFT($A$1:$A$5,6)),0)),\"\"),B1)","v":"Dres s límečkem"},null,null,"1. Urobte si pomocný stĺpec C s maticovým vzorcom (Ctrl+Shift+Enter), pričom upravte rozsah $A$1:$A$5 a $B$1:$B$5. Vzorec z C1 pretiahnuť do všetkých C buniek rozsahu podľa $A$1:$A$5"]
["900100-S",null,{"$f":"IF(B2=\"\",IFERROR(INDEX(B:B,MATCH(LEFT(A2,6),IF($B$1:$B$5=\"\",\"\",LEFT($A$1:$A$5,6)),0)),\"\"),B2)","v":"Dres s límečkem"},null,null,"2. Označte rozsah C, Ctrl+C, označte B1, pravý klik, možnosti prilepenia Hodnoty. Stlpec C vymažte."]
["900200-S","blbina",{"$f":"IF(B3=\"\",IFERROR(INDEX(B:B,MATCH(LEFT(A3,6),IF($B$1:$B$5=\"\",\"\",LEFT($A$1:$A$5,6)),0)),\"\"),B3)","v":"blbina"}]
["900100XY","Dres s límečkem",{"$f":"IF(B4=\"\",IFERROR(INDEX(B:B,MATCH(LEFT(A4,6),IF($B$1:$B$5=\"\",\"\",LEFT($A$1:$A$5,6)),0)),\"\"),B4)","v":"Dres s límečkem"},null,null,"Ak to môže byť makrom, tak stĺpec C nepotrebujete"]
["888777-L",null,{"$f":"IF(B5=\"\",IFERROR(INDEX(B:B,MATCH(LEFT(A5,6),IF($B$1:$B$5=\"\",\"\",LEFT($A$1:$A$5,6)),0)),\"\"),B5)","v":""}]
[]
[]
[null,null,null,null,null,"Záleží na početnosti operácie, množstve dát, možnosti použiť fo firme makro,..."]