{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Contents","MOD","ROW","ROW_MOD","With-FIlter","OFFSET","GET-ROW","GET-Value","VB","Sheet1"],"not_rendered":{"charts":0,"images":2,"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":"Contents","index":0,"n_rows":47,"n_cols":6,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
["SELECT EVERY NTH ROW"]
[null,"automateexcel.com/formulas/select-every-nth-row/"]
[]
[null,"Table of Contents",null,null,null,"Other Resources"]
[null,"MOD",null,null,null,"Excel Formulas w/Examples"]
[null,"ROW",null,null,null,"Excel Boot Camp - Learn Excel inside Excel"]
[null,"ROW_MOD",null,null,null,"Excel Functions & Formulas Tutorial"]
[null,"With-FIlter"]
[null,"OFFSET"]
[null,"GET-ROW"]
[null,"GET-Value"]
[null,"VB"]
[null,"Sheet1"]
[null,"  Learn Excel Inside Excel"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"           Learn Excel inside Excel with our Interactive Tutorial"]
[null,"           Automatically Graded Exercises"]
[null,"           Shortcuts & Best Practices \"Work Smarter, not Harder\""]
[]
[]
[]
[]
[]
[]
[]
[null,"Course Contents"]

{"sheet":"MOD","index":1,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[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,"automateexcel.com/formulas/select-every-nth-row/"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"ROW","index":2,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[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,"automateexcel.com/formulas/select-every-nth-row/"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"ROW_MOD","index":3,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[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,"automateexcel.com/formulas/select-every-nth-row/"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"With-FIlter","index":4,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[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,"automateexcel.com/formulas/select-every-nth-row/"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"OFFSET","index":5,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[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,"automateexcel.com/formulas/select-every-nth-row/"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"GET-ROW","index":6,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[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,"automateexcel.com/formulas/select-every-nth-row/"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"GET-Value","index":7,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[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,"automateexcel.com/formulas/select-every-nth-row/"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"VB","index":8,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Number","Number"]
[null,500,500]
[null,600]
[null,700,700]
[null,800]
[null,900,900]
[null,1000]
[null,1100,1100]
[null,1200]
[]
[null,"automateexcel.com/formulas/select-every-nth-row/"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Sheet1","index":9,"n_rows":15,"n_cols":3,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Number","Number"]
[null,500]
[null,600]
[null,700]
[null,800]
[null,900]
[null,1000]
[null,1100]
[null,1200]
[]
[null,"automateexcel.com/formulas/select-every-nth-row/"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]