{"text_format":"3","workbook":"xlsx","n_sheets":10,"sheets":["Contents","MOD","ROW","ROW_MOD","With-FIlter","OFFSET","GET-ROW","GET-Value","VB","Sheet1"],"not_rendered":{"macros":1,"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"Contents","index":0,"n_rows":47,"n_cols":2,"rows_kept":47,"merged":[[0,0,0,1]]}
["SELECT EVERY NTH ROW"]
[null,"formulas/select-every-nth-row/"]
[]
[null,"Table of Contents"]
[null,"MOD"]
[null,"ROW"]
[null,"ROW_MOD"]
[null,"With-FIlter"]
[null,"OFFSET"]
[null,"GET-ROW"]
[null,"GET-Value"]
[null,"VB"]
[null,"Sheet1"]
[null,"  Learn Excel Inside Excel"]
{"$rows_empty":22}
[null,"           Learn Excel inside Excel with our Interactive Tutorial"]
[null,"           Automatically Graded Exercises"]
[null,"           Shortcuts & Best Practices \"Work Smarter, not Harder\""]
{"$rows_empty":7}
[null,"Course Contents"]

{"sheet":"MOD","index":1,"n_rows":12,"n_cols":3,"rows_kept":12}
[]
[null,"Number","Mod"]
[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,"formulas/select-every-nth-row/"]

{"sheet":"ROW","index":2,"n_rows":12,"n_cols":3,"rows_kept":12}
[]
[null,"Number","Row"]
[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,"formulas/select-every-nth-row/"]

{"sheet":"ROW_MOD","index":3,"n_rows":12,"n_cols":4,"rows_kept":12}
[]
[null,"Number","Row","Mod"]
[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,"formulas/select-every-nth-row/"]

{"sheet":"With-FIlter","index":4,"n_rows":12,"n_cols":4,"rows_kept":12}
[]
[null,"Number","Row","Mod"]
[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,"formulas/select-every-nth-row/"]

{"sheet":"OFFSET","index":5,"n_rows":12,"n_cols":4,"rows_kept":12}
[]
[null,"Number",null,"Every 2nd Row"]
[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,"formulas/select-every-nth-row/"]

{"sheet":"GET-ROW","index":6,"n_rows":12,"n_cols":4,"rows_kept":12}
[]
[null,"Number",null,"Get the Row"]
[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,"formulas/select-every-nth-row/"]

{"sheet":"GET-Value","index":7,"n_rows":12,"n_cols":5,"rows_kept":12}
[]
[null,"Number",null,"Get the Row","Get the Value"]
[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,"formulas/select-every-nth-row/"]

{"sheet":"VB","index":8,"n_rows":12,"n_cols":3,"rows_kept":12}
[]
[null,"Number","Number"]
[null,500,500]
[null,600]
[null,700,700]
[null,800]
[null,900,900]
[null,1000]
[null,1100,1100]
[null,1200]
[]
[null,"formulas/select-every-nth-row/"]

{"sheet":"Sheet1","index":9,"n_rows":13,"n_cols":3,"rows_kept":13}
[]
[]
[null,"Number","Number"]
[null,500]
[null,600]
[null,700]
[null,800]
[null,900]
[null,1000]
[null,1100]
[null,1200]
[]
[null,"formulas/select-every-nth-row/"]