{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["콘텐츠","n번째 행마다 선택 - 메인","MOD 함수","ROW 함수","모든 n번째 행 선택","필터설정","n번째 행마다 값 추출","n번째 행 번호 추출","값 추출","VBA"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"콘텐츠","index":0,"n_rows":13,"n_cols":2,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["모든 n번째 행 선택"]
[null,"https://www.automateexcel.com/formulas/select-every-nth-row-ko/"]
[]
[null,"콘텐츠"]
[null,"n번째 행마다 선택 - 메인"]
[null,"MOD 함수"]
[null,"ROW 함수"]
[null,"모든 n번째 행 선택"]
[null,"필터설정"]
[null,"n번째 행마다 값 추출"]
[null,"n번째 행 번호 추출"]
[null,"값 추출"]
[null,"VBA"]

{"sheet":"n번째 행마다 선택 - 메인","index":1,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[null,"숫자",null,"세번째 행마다"]
[null,500.0,null,{"$f":"OFFSET($B$3,(ROW(D1)*3)-1,0)","v":700}]
[null,600.0,null,1000]
[null,700.0]
[null,800.0]
[null,900.0]
[null,1000.0]
[null,1100.0]
[null,1200.0]

{"sheet":"MOD 함수","index":2,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[null,"숫자","Mod"]
[null,500.0,{"$f":"MOD(ROW(B3),2)","v":1}]
[null,600.0,0]
[null,700.0,1]
[null,800.0,0]
[null,900.0,1]
[null,1000.0,0]
[null,1100.0,1]
[null,1200.0,0]

{"sheet":"ROW 함수","index":3,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[null,"숫자","행"]
[null,500.0,{"$f":"ROW(B3)","v":3}]
[null,600.0,4]
[null,700.0,5]
[null,800.0,6]
[null,900.0,7]
[null,1000.0,8]
[null,1100.0,9]
[null,1200.0,10]

{"sheet":"모든 n번째 행 선택","index":4,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[null,"숫자","행","Mod"]
[null,500.0,{"$f":"ROW(B3)","v":3},{"$f":"MOD(C3,2)","v":1}]
[null,600.0,4,0]
[null,700.0,5,1]
[null,800.0,6,0]
[null,900.0,7,1]
[null,1000.0,8,0]
[null,1100.0,9,1]
[null,1200.0,10,0]

{"sheet":"필터설정","index":5,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[null,"숫자","행","Mod"]
[null,500.0,{"$f":"ROW(B3)","v":3},{"$f":"MOD(C3,3)","v":0}]
[null,600.0,4,1]
[null,700.0,5,2]
[null,800.0,6,0]
[null,900.0,7,1]
[null,1000.0,8,2]
[null,1100.0,9,0]
[null,1200.0,10,1]

{"sheet":"n번째 행마다 값 추출","index":6,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[null,"숫자",null,"2번째 행마다"]
[null,500.0,null,{"$f":"OFFSET($B$3,(ROW(D1)*2)-1,0)","v":600}]
[null,600.0,null,800]
[null,700.0,null,1000]
[null,800.0,null,1200]
[null,900.0]
[null,1000.0]
[null,1100.0]
[null,1200.0]

{"sheet":"n번째 행 번호 추출","index":7,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[null,"숫자",null,"행 번호 추출"]
[null,500.0,null,{"$f":"ROW(D1)","v":1}]
[null,600.0,null,2]
[null,700.0,null,3]
[null,800.0,null,4]
[null,900.0,null,5]
[null,1000.0]
[null,1100.0]
[null,1200.0]

{"sheet":"값 추출","index":8,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[null,"숫자",null,"행 번호 추출","값 추출"]
[null,500.0,null,{"$f":"ROW(D1)","v":1},{"$f":"OFFSET($B$3,(D3*2)-1,0)","v":600}]
[null,600.0,null,2,800]
[null,700.0,null,3,1000]
[null,800.0,null,4,1200]
[null,900.0]
[null,1000.0]
[null,1100.0]
[null,1200.0]

{"sheet":"VBA","index":9,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[null,"숫자","숫자"]
[null,500.0,500.0]
[null,600.0]
[null,700.0,700.0]
[null,800.0]
[null,900.0,900.0]
[null,1000.0]
[null,1100.0,1100.0]
[null,1200.0]