{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Inhalt","Jede Andere Zeile Auswählen...","REST-Funktion","ZEILE-Funktion","Jede N-te Zeile Auswählen","Mit Filter","Wert aus Jeder n-ten Zeile","N-te Zeile Zurückgeben","Wert Erhalten","VBA"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":"Inhalt","index":0,"n_rows":13,"n_cols":2,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["JEDE N-TE ZEILE AUSWAEHLEN"]
[null,"https://www.automateexcel.com/de/formulas/jede-n-te-zeile-auswaehlen/"]
[]
[null,"Inhaltsverzeichnis"]
[null,"Jede Andere Zeile Auswählen - Hauptfunktion"]
[null,"REST-Funktion"]
[null,"ZEILE-Funktion"]
[null,"Jede N-te Zeile Auswählen"]
[null,"Mit Filter"]
[null,"Wert aus Jeder n-ten Zeile"]
[null,"N-te Zeile Zurückgeben"]
[null,"Wert Erhalten"]
[null,"VBA"]

{"sheet":"Jede Andere Zeile Auswählen...","index":1,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Zahl",null,"Jede 3. Zeile"]
[null,500,null,{"$f":"OFFSET($B$3,(ROW(D1)*3)-1,0)","v":700}]
[null,600,null,{"$f":"OFFSET($B$3,(ROW(D2)*3)-1,0)","v":1000}]
[null,700]
[null,800]
[null,900]
[null,1000]
[null,1100]
[null,1200]
[]
[null,"https://www.automateexcel.com/de/formulas/jede-n-te-zeile-auswaehlen/"]

{"sheet":"REST-Funktion","index":2,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Zahl","REST"]
[null,500,{"$f":"MOD(ROW(B3),2)","v":1}]
[null,600,{"$f":"MOD(ROW(B4),2)","v":0}]
[null,700,1]
[null,800,0]
[null,900,1]
[null,1000,0]
[null,1100,1]
[null,1200,0]
[]
[null,"https://www.automateexcel.com/de/formulas/jede-n-te-zeile-auswaehlen/"]

{"sheet":"ZEILE-Funktion","index":3,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Zahl","Zeile"]
[null,500,{"$f":"ROW(B3)","v":3}]
[null,600,{"$f":"ROW(B4)","v":4}]
[null,700,5]
[null,800,6]
[null,900,7]
[null,1000,8]
[null,1100,9]
[null,1200,10]
[]
[null,"https://www.automateexcel.com/de/formulas/jede-n-te-zeile-auswaehlen/"]

{"sheet":"Jede N-te Zeile Auswählen","index":4,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Zahl","Zeile","REST"]
[null,500,{"$f":"ROW(B3)","v":3},{"$f":"MOD(C3,2)","v":1}]
[null,600,{"$f":"ROW(B4)","v":4},{"$f":"MOD(C4,2)","v":0}]
[null,700,5,1]
[null,800,6,0]
[null,900,7,1]
[null,1000,8,0]
[null,1100,9,1]
[null,1200,10,0]
[]
[null,"https://www.automateexcel.com/de/formulas/jede-n-te-zeile-auswaehlen/"]

{"sheet":"Mit Filter","index":5,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Zahl","Zeile","REST"]
[null,500,{"$f":"ROW(B3)","v":3},{"$f":"MOD(C3,3)","v":0}]
[null,600,{"$f":"ROW(B4)","v":4},{"$f":"MOD(C4,3)","v":1}]
[null,700,5,2]
[null,800,6,0]
[null,900,7,1]
[null,1000,8,2]
[null,1100,9,0]
[null,1200,10,1]
[]
[null,"https://www.automateexcel.com/de/formulas/jede-n-te-zeile-auswaehlen/"]

{"sheet":"Wert aus Jeder n-ten Zeile","index":6,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Zahl",null,"Jede 2. Zeile"]
[null,500,null,{"$f":"OFFSET($B$3,(ROW(D1)*2)-1,0)","v":600}]
[null,600,null,{"$f":"OFFSET($B$3,(ROW(D2)*2)-1,0)","v":800}]
[null,700,null,{"$f":"OFFSET($B$3,(ROW(D3)*2)-1,0)","v":1000}]
[null,800,null,{"$f":"OFFSET($B$3,(ROW(D4)*2)-1,0)","v":1200}]
[null,900]
[null,1000]
[null,1100]
[null,1200]
[]
[null,"https://www.automateexcel.com/de/formulas/jede-n-te-zeile-auswaehlen/"]

{"sheet":"N-te Zeile Zurückgeben","index":7,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Zahl",null,"Zeile erhalten"]
[null,500,null,{"$f":"ROW(D1)","v":1}]
[null,600,null,{"$f":"ROW(D2)","v":2}]
[null,700,null,{"$f":"ROW(D3)","v":3}]
[null,800,null,{"$f":"ROW(D4)","v":4}]
[null,900,null,{"$f":"ROW(D5)","v":5}]
[null,1000]
[null,1100]
[null,1200]
[]
[null,"https://www.automateexcel.com/de/formulas/jede-n-te-zeile-auswaehlen/"]

{"sheet":"Wert Erhalten","index":8,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Zahl",null,"Zeile erhalten","Wert erhalten"]
[null,500,null,{"$f":"ROW(D1)","v":1},{"$f":"OFFSET($B$3,(D3*2)-1,0)","v":600}]
[null,600,null,{"$f":"ROW(D2)","v":2},{"$f":"OFFSET($B$3,(D4*2)-1,0)","v":800}]
[null,700,null,{"$f":"ROW(D3)","v":3},{"$f":"OFFSET($B$3,(D5*2)-1,0)","v":1000}]
[null,800,null,{"$f":"ROW(D4)","v":4},{"$f":"OFFSET($B$3,(D6*2)-1,0)","v":1200}]
[null,900]
[null,1000]
[null,1100]
[null,1200]
[]
[null,"https://www.automateexcel.com/de/formulas/jede-n-te-zeile-auswaehlen/"]

{"sheet":"VBA","index":9,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Zahl","Zahl"]
[null,500,500]
[null,600]
[null,700,700]
[null,800]
[null,900,900]
[null,1000]
[null,1100,1100]
[null,1200]
[]
[null,"https://www.automateexcel.com/de/formulas/jede-n-te-zeile-auswaehlen/"]