{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Test"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"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":"Test","index":0,"n_rows":13,"n_cols":27,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Niečo","Značka",null,"Spolu",null,null,null,"Niečo","Značka","Pomoc",null,"Spolu",null,null,null,"Niečo","Pomoc",null,"Spolu",null,null,null,"Niečo","Spolu",null,"Niečo","Spolu"]
["Fero",1,null,{"$f":"_xlfn.TEXTJOIN(\",\",TRUE,_xlfn._xlws.FILTER(A2:A13,(B2:B13<>\"\")*(A2:A13<>\"\")))","v":"Fero,Jano,Gabo,Tóno"},null,null,null,"Fero","a",{"$f":"IF(OR(H2=\"\",I2=\"\"),IF(COUNTIFS($H$2:$H2,\"<>\",$I$2:$I2,\"<>\")>0,J1,\"\"),IF(COUNTIFS($H$2:$H2,\"<>\",$I$2:$I2,\"<>\")=1,H2,J1&\",\"&H2))","v":"Fero"},null,{"$f":"INDEX(J2:J13,ROWS(H2:H13))","v":"Fero,Jano,Gabo,Tóno"},null,null,null,"Fero","Mišo",null,{"$f":"_xlfn.TEXTJOIN(\",\",TRUE,Q2:Q13)","v":"Mišo,Miro,Noro,Gabo"},null,null,null,"Fero","Fero,Mišo,Jano,Miro,Dano,Robo,Jaro,Noro,Gabo,Tóno,Ďuro",null,"Fero","Mišo,Jaro,Noro,Ďuro"]
["Mišo",null,null,null,null,null,null,"Mišo",null,{"$f":"IF(OR(H3=\"\",I3=\"\"),IF(COUNTIFS($H$2:$H3,\"<>\",$I$2:$I3,\"<>\")>0,J2,\"\"),IF(COUNTIFS($H$2:$H3,\"<>\",$I$2:$I3,\"<>\")=1,H3,J2&\",\"&H3))","v":"Fero"},null,null,null,null,null,"Mišo","Miro",null,null,null,null,null,"Mišo",null,null,"Mišo"]
["Jano",1,null,null,null,null,null,"Jano",1,{"$f":"IF(OR(H4=\"\",I4=\"\"),IF(COUNTIFS($H$2:$H4,\"<>\",$I$2:$I4,\"<>\")>0,J3,\"\"),IF(COUNTIFS($H$2:$H4,\"<>\",$I$2:$I4,\"<>\")=1,H4,J3&\",\"&H4))","v":"Fero,Jano"},null,null,null,null,null,"Jano","Noro",null,null,null,null,null,"Jano",null,null,"Jano"]
["Miro",null,null,null,null,null,null,"Miro",null,{"$f":"IF(OR(H5=\"\",I5=\"\"),IF(COUNTIFS($H$2:$H5,\"<>\",$I$2:$I5,\"<>\")>0,J4,\"\"),IF(COUNTIFS($H$2:$H5,\"<>\",$I$2:$I5,\"<>\")=1,H5,J4&\",\"&H5))","v":"Fero,Jano"},null,null,null,null,null,"Miro","Gabo",null,"1. Zmazať stĺpec Q",null,null,null,"Miro",null,null,"Miro"]
["Dano",null,null,null,null,null,null,"Dano",null,{"$f":"IF(OR(H6=\"\",I6=\"\"),IF(COUNTIFS($H$2:$H6,\"<>\",$I$2:$I6,\"<>\")>0,J5,\"\"),IF(COUNTIFS($H$2:$H6,\"<>\",$I$2:$I6,\"<>\")=1,H6,J5&\",\"&H6))","v":"Fero,Jano"},null,null,null,null,null,"Dano",null,null,"2. Označiť v stĺpci P",null,null,null,"Dano",null,null,"Dano"]
[null,1,null,null,null,null,null,null,1,{"$f":"IF(OR(H7=\"\",I7=\"\"),IF(COUNTIFS($H$2:$H7,\"<>\",$I$2:$I7,\"<>\")>0,J6,\"\"),IF(COUNTIFS($H$2:$H7,\"<>\",$I$2:$I7,\"<>\")=1,H7,J6&\",\"&H7))","v":"Fero,Jano"},null,null,null,null,null,null,null,null,"3. Kopírovať označené - Ctrl+C"]
["Robo",null,null,null,null,null,null,"Robo",null,{"$f":"IF(OR(H8=\"\",I8=\"\"),IF(COUNTIFS($H$2:$H8,\"<>\",$I$2:$I8,\"<>\")>0,J7,\"\"),IF(COUNTIFS($H$2:$H8,\"<>\",$I$2:$I8,\"<>\")=1,H8,J7&\",\"&H8))","v":"Fero,Jano"},null,null,null,null,null,"Robo",null,null,"4. Označiť bunku Q2",null,null,null,"Robo",null,null,"Robo"]
["Jaro",null,null,null,null,null,null,"Jaro",null,{"$f":"IF(OR(H9=\"\",I9=\"\"),IF(COUNTIFS($H$2:$H9,\"<>\",$I$2:$I9,\"<>\")>0,J8,\"\"),IF(COUNTIFS($H$2:$H9,\"<>\",$I$2:$I9,\"<>\")=1,H9,J8&\",\"&H9))","v":"Fero,Jano"},null,null,null,null,null,"Jaro",null,null,"5. Vložiť - Ctrl+V",null,null,null,"Jaro",null,null,"Jaro"]
["Noro",null,null,null,null,null,null,"Noro",null,{"$f":"IF(OR(H10=\"\",I10=\"\"),IF(COUNTIFS($H$2:$H10,\"<>\",$I$2:$I10,\"<>\")>0,J9,\"\"),IF(COUNTIFS($H$2:$H10,\"<>\",$I$2:$I10,\"<>\")=1,H10,J9&\",\"&H10))","v":"Fero,Jano"},null,null,null,null,null,"Noro",null,null,null,null,null,null,"Noro",null,null,"Noro"]
["Gabo",1,null,null,null,null,null,"Gabo",1,{"$f":"IF(OR(H11=\"\",I11=\"\"),IF(COUNTIFS($H$2:$H11,\"<>\",$I$2:$I11,\"<>\")>0,J10,\"\"),IF(COUNTIFS($H$2:$H11,\"<>\",$I$2:$I11,\"<>\")=1,H11,J10&\",\"&H11))","v":"Fero,Jano,Gabo"},null,null,null,null,null,"Gabo",null,null,null,null,null,null,"Gabo",null,null,"Gabo"]
["Tóno",1,null,null,null,null,null,"Tóno",1,{"$f":"IF(OR(H12=\"\",I12=\"\"),IF(COUNTIFS($H$2:$H12,\"<>\",$I$2:$I12,\"<>\")>0,J11,\"\"),IF(COUNTIFS($H$2:$H12,\"<>\",$I$2:$I12,\"<>\")=1,H12,J11&\",\"&H12))","v":"Fero,Jano,Gabo,Tóno"},null,null,null,null,null,"Tóno",null,null,null,null,null,null,"Tóno",null,null,"Tóno"]
["Ďuro",null,null,null,null,null,null,"Ďuro",null,{"$f":"IF(OR(H13=\"\",I13=\"\"),IF(COUNTIFS($H$2:$H13,\"<>\",$I$2:$I13,\"<>\")>0,J12,\"\"),IF(COUNTIFS($H$2:$H13,\"<>\",$I$2:$I13,\"<>\")=1,H13,J12&\",\"&H13))","v":"Fero,Jano,Gabo,Tóno"},null,null,null,null,null,"Ďuro",null,null,null,null,null,null,"Ďuro",null,null,"Ďuro"]