{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Dataset","ROW","ROW with Reference","Combined Function","VBA","ROWS"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"Dataset","index":0,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Getting ROW Number"]
[]
[null,"Month","Sales"]
[null,"January",1000]
[null,"February",1500]
[null,"March",1200]
[null,"April",600]
[null,"May",1900]
[null,"June",1300]
[null,"July",1700]

{"sheet":"ROW","index":1,"n_rows":11,"n_cols":12,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,9,1,11]]}
[]
[null,"Use of ROW Function",null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Month","Sales","Row Number",null,null,null,null,null,"Month","Sales","Row Number"]
[null,"January",1000,{"$f":"ROW()","v":5},null,null,null,null,null,"January",1000]
[null,"February",1500,{"$f":"ROW()","v":6},null,null,null,null,null,"February",1500]
[null,"March",1200,{"$f":"ROW()","v":7},null,null,null,null,null,"March",1200]
[null,"April",600,{"$f":"ROW()","v":8},null,null,null,null,null,"April",600]
[null,"May",1900,{"$f":"ROW()","v":9},null,null,null,null,null,"May",1900]
[null,"June",1300,{"$f":"ROW()","v":10},null,null,null,null,null,"June",1300]
[null,"July",1700,{"$f":"ROW()","v":11},null,null,null,null,null,"July",1700]

{"sheet":"ROW with Reference","index":2,"n_rows":11,"n_cols":12,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,9,1,11]]}
[]
[null,"Using ROW Function with Cell Reference",null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Month","Sales","Row Number",null,null,null,null,null,"Month","Sales","Row Number"]
[null,"January",1000,{"$f":"ROW(C5)","v":5},null,null,null,null,null,"January",1000]
[null,"February",1500,{"$f":"ROW(C6)","v":6},null,null,null,null,null,"February",1500]
[null,"March",1200,7,null,null,null,null,null,"March",1200]
[null,"April",600,8,null,null,null,null,null,"April",600]
[null,"May",1900,9,null,null,null,null,null,"May",1900]
[null,"June",1300,10,null,null,null,null,null,"June",1300]
[null,"July",1700,11,null,null,null,null,null,"July",1700]

{"sheet":"Combined Function","index":3,"n_rows":11,"n_cols":12,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,9,1,11]]}
[]
[null,"Using Combination of Functions",null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Month","Sales","Row Number",null,null,null,null,null,"Month","Sales","Row Number"]
[null,"January",1000,{"$f":"ROW(INDEX($B$5:$B$11, MATCH(\"January\", $B$5:$B$11, 0)))","v":5},null,null,null,null,null,"January",1000]
[null,"February",1500,{"$f":"ROW(INDEX($B$5:$B$11, MATCH(\"February\", $B$5:$B$11, 0)))","v":6},null,null,null,null,null,"February",1500]
[null,"March",1200,{"$f":"ROW(INDEX($B$5:$B$11, MATCH(\"March\", $B$5:$B$11, 0)))","v":7},null,null,null,null,null,"March",1200]
[null,"April",600,{"$f":"ROW(INDEX($B$5:$B$11, MATCH(\"April\", $B$5:$B$11, 0)))","v":8},null,null,null,null,null,"April",600]
[null,"May",1900,{"$f":"ROW(INDEX($B$5:$B$11, MATCH(\"May\", $B$5:$B$11, 0)))","v":9},null,null,null,null,null,"May",1900]
[null,"June",1300,{"$f":"ROW(INDEX($B$5:$B$11, MATCH(\"June\", $B$5:$B$11, 0)))","v":10},null,null,null,null,null,"June",1300]
[null,"July",1700,{"$f":"ROW(INDEX($B$5:$B$11, MATCH(\"July\", $B$5:$B$11, 0)))","v":11},null,null,null,null,null,"July",1700]

{"sheet":"VBA","index":4,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Applying VBA Code"]
[]
[null,"Month","Sales"]
[null,"January",1000]
[null,"February",1500]
[null,"March",1200]
[null,"April",600]
[null,"May",1900]
[null,"June",1300]
[null,"July",1700]

{"sheet":"ROWS","index":5,"n_rows":11,"n_cols":12,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,9,1,11],[4,11,10,11],[4,3,10,3]]}
[]
[null,"Employing ROWS Function",null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Month","Sales","Total Row ",null,null,null,null,null,"Month","Sales","Total Row "]
[null,"January",1000,{"$f":"ROWS(B5:B11)","v":7},null,null,null,null,null,"January",1000]
[null,"February",1500,null,null,null,null,null,null,"February",1500]
[null,"March",1200,null,null,null,null,null,null,"March",1200]
[null,"April",600,null,null,null,null,null,null,"April",600]
[null,"May",1900,null,null,null,null,null,null,"May",1900]
[null,"June",1300,null,null,null,null,null,null,"June",1300]
[null,"July",1700,null,null,null,null,null,null,"July",1700]