{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["start","oszthatóság","szűrés","szűrlet_másolat","index","eredmény","start2"],"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":"start","index":0,"n_rows":22,"n_cols":9,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["id","adat","3.adat_1","3.adat_2","3.adat_3","3.adat_4","3.adat_5","3.adat_6","3.adat_7"]
[1,"adat1",1,2,3,4,5,6,7]
[2,"adat2"]
[3,"adat3"]
[4,"adat4"]
[5,"adat5"]
[6,"adat6"]
[7,"adat7"]
[8,"adat8"]
[9,"adat9"]
[10,"adat10"]
[11,"adat11"]
[12,"adat12"]
[13,"adat13"]
[14,"adat14"]
[15,"adat15"]
[16,"adat16"]
[17,"adat17"]
[]
["Feladat","Minden 3. adatot transzponálni a 2. sorba a C oszloptól a B2 mellé…"]
["Makró","https://www.youtube.com/watch?v=zA_Q_Yws0gQ"]
["Makró2","CTRL+SHIFT+G (start2 munkalap)"]

{"sheet":"oszthatóság","index":1,"n_rows":18,"n_cols":3,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["id","adat","oszthatóság"]
[1,"adat1",{"$f":"IF(A2/3=INT(A2/3),1,0)","v":0}]
[2,"adat2",{"$f":"IF(A3/3=INT(A3/3),1,0)","v":0}]
[3,"adat3",1]
[4,"adat4",0]
[5,"adat5",0]
[6,"adat6",1]
[7,"adat7",0]
[8,"adat8",0]
[9,"adat9",1]
[10,"adat10",0]
[11,"adat11",0]
[12,"adat12",1]
[13,"adat13",0]
[14,"adat14",0]
[15,"adat15",1]
[16,"adat16",0]
[17,"adat17",0]

{"sheet":"szűrés","index":2,"n_rows":18,"n_cols":3,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["id","adat","oszthatóság"]
[1,"adat1",{"$f":"IF(A2/3=INT(A2/3),1,0)","v":0}]
[2,"adat2",{"$f":"IF(A3/3=INT(A3/3),1,0)","v":0}]
[3,"adat3",1]
[4,"adat4",0]
[5,"adat5",0]
[6,"adat6",1]
[7,"adat7",0]
[8,"adat8",0]
[9,"adat9",1]
[10,"adat10",0]
[11,"adat11",0]
[12,"adat12",1]
[13,"adat13",0]
[14,"adat14",0]
[15,"adat15",1]
[16,"adat16",0]
[17,"adat17",0]

{"sheet":"szűrlet_másolat","index":3,"n_rows":6,"n_cols":3,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["id","adat","oszthatóság"]
[3,"adat3",1]
[6,"adat6",1]
[9,"adat9",1]
[12,"adat12",1]
[15,"adat15",1]

{"sheet":"index","index":4,"n_rows":6,"n_cols":3,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["id","adat","oszthatóság"]
[3,"adat3",1]
[6,"adat6",{"$f":"C2+1","v":2}]
[9,"adat9",{"$f":"C3+1","v":3}]
[12,"adat12",4]
[15,"adat15",5]

{"sheet":"eredmény","index":5,"n_rows":2,"n_cols":8,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["cél_index",1,2,3,4,5,6,7]
["adatok",{"$f":"IFERROR(_xlfn.XLOOKUP(B1,index!$C$2:$C$6,index!$B$2:$B$6,,,),\"nincs több adat\")","v":"adat3"},{"$f":"IFERROR(_xlfn.XLOOKUP(C1,index!$C$2:$C$6,index!$B$2:$B$6,,,),\"nincs több adat\")","v":"adat6"},{"$f":"IFERROR(_xlfn.XLOOKUP(D1,index!$C$2:$C$6,index!$B$2:$B$6,,,),\"nincs több adat\")","v":"adat9"},{"$f":"IFERROR(_xlfn.XLOOKUP(E1,index!$C$2:$C$6,index!$B$2:$B$6,,,),\"nincs több adat\")","v":"adat12"},{"$f":"IFERROR(_xlfn.XLOOKUP(F1,index!$C$2:$C$6,index!$B$2:$B$6,,,),\"nincs több adat\")","v":"adat15"},{"$f":"IFERROR(_xlfn.XLOOKUP(G1,index!$C$2:$C$6,index!$B$2:$B$6,,,),\"nincs több adat\")","v":"nincs több adat"},{"$f":"IFERROR(_xlfn.XLOOKUP(H1,index!$C$2:$C$6,index!$B$2:$B$6,,,),\"nincs több adat\")","v":"nincs több adat"}]

{"sheet":"start2","index":6,"n_rows":18,"n_cols":4,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["id","adat","oszthatóság","ctrl+shift+g"]
[1,"adat1",{"$f":"IF(A2/3=INT(A2/3),1,0)","v":0}]
[2,"adat2",{"$f":"IF(A3/3=INT(A3/3),1,0)","v":0}]
[3,"adat3",1]
[4,"adat4",0]
[5,"adat5",0]
[6,"adat6",1]
[7,"adat7",0]
[8,"adat8",0]
[9,"adat9",1]
[10,"adat10",0]
[11,"adat11",0]
[12,"adat12",1]
[13,"adat13",0]
[14,"adat14",0]
[15,"adat15",1]
[16,"adat16",0]
[17,"adat17",0]