{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Data Set","INDEX+ROWS","SORTBY+ROW","Helper Column","Helper Row","VBA-V","VBA-H"],"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":"Data Set","index":0,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Sample Data Set"]
[]
[null,"States","Capitals"]
[null,"Washington","Olympia"]
[null,"Oregon","Salem"]
[null,"California","Sacramento"]
[null,"Arizona","Phoenix"]
[null,"Colorado","Denver"]
[null,"Kansas","Topeka"]

{"sheet":"INDEX+ROWS","index":1,"n_rows":10,"n_cols":12,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,7,1,11]]}
[]
[null,"Combining INDEX and ROWS Functions",null,null,null,null,null,"Practice"]
[]
[null,"States","Capitals",null,"States","Capitals",null,"States","Capitals",null,"States","Capitals"]
[null,"Washington","Olympia",null,{"$f":"INDEX($B$5:$B$10,ROWS(B5:$B$10))","v":"Kansas"},{"$f":"INDEX($C$5:$C$10,ROWS(C5:$C$10))","v":"Topeka"},null,"Washington","Olympia"]
[null,"Oregon","Salem",null,{"$f":"INDEX($B$5:$B$10,ROWS(B6:$B$10))","v":"Colorado"},{"$f":"INDEX($C$5:$C$10,ROWS(C6:$C$10))","v":"Denver"},null,"Oregon","Salem"]
[null,"California","Sacramento",null,{"$f":"INDEX($B$5:$B$10,ROWS(B7:$B$10))","v":"Arizona"},{"$f":"INDEX($C$5:$C$10,ROWS(C7:$C$10))","v":"Phoenix"},null,"California","Sacramento"]
[null,"Arizona","Phoenix",null,{"$f":"INDEX($B$5:$B$10,ROWS(B8:$B$10))","v":"California"},{"$f":"INDEX($C$5:$C$10,ROWS(C8:$C$10))","v":"Sacramento"},null,"Arizona","Phoenix"]
[null,"Colorado","Denver",null,{"$f":"INDEX($B$5:$B$10,ROWS(B9:$B$10))","v":"Oregon"},{"$f":"INDEX($C$5:$C$10,ROWS(C9:$C$10))","v":"Salem"},null,"Colorado","Denver"]
[null,"Kansas","Topeka",null,{"$f":"INDEX($B$5:$B$10,ROWS(B10:$B$10))","v":"Washington"},{"$f":"INDEX($C$5:$C$10,ROWS(C10:$C$10))","v":"Olympia"},null,"Kansas","Topeka"]

{"sheet":"SORTBY+ROW","index":2,"n_rows":10,"n_cols":12,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,7,1,11]]}
[]
[null,"Merging SORTBY and ROW Functions",null,null,null,null,null,"Practice"]
[]
[null,"States","Capitals",null,"States","Capitals",null,"States","Capitals",null,"States","Capitals"]
[null,"Washington","Olympia",null,{"$f":"_xlfn.SORTBY($B$5:$C$10,ROW(B5:B10),-1)","v":"Kansas"},"Topeka",null,"Washington","Olympia"]
[null,"Oregon","Salem",null,"Colorado","Denver",null,"Oregon","Salem"]
[null,"California","Sacramento",null,"Arizona","Phoenix",null,"California","Sacramento"]
[null,"Arizona","Phoenix",null,"California","Sacramento",null,"Arizona","Phoenix"]
[null,"Colorado","Denver",null,"Oregon","Salem",null,"Colorado","Denver"]
[null,"Kansas","Topeka",null,"Washington","Olympia",null,"Kansas","Topeka"]

{"sheet":"Helper Column","index":3,"n_rows":10,"n_cols":8,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,5,1,7]]}
[]
[null,"Inserting Helper Column",null,null,null,"Practice"]
[]
[null,"States","Capitals","Helper Column",null,"States","Capitals","Helper Column"]
[null,"Washington","Olympia",1,null,"Kansas","Topeka",6]
[null,"Oregon","Salem",2,null,"Colorado","Denver",5]
[null,"California","Sacramento",3,null,"Arizona","Phoenix",4]
[null,"Arizona","Phoenix",4,null,"California","Sacramento",3]
[null,"Colorado","Denver",5,null,"Oregon","Salem",2]
[null,"Kansas","Topeka",6,null,"Washington","Olympia",1]

{"sheet":"Helper Row","index":4,"n_rows":6,"n_cols":16,"rows_kept":6,"cut":false,"hidden":false,"merged":[[1,1,1,7],[1,9,1,15]]}
[]
[null,"Inserting Helper Row",null,null,null,null,null,null,null,"Practice"]
[]
[null,"States","Kansas","Colorado","Arizona","California","Oregon","Washington",null,"States","Kansas","Colorado","Arizona","California","Oregon","Washington"]
[null,"Capitals","Topeka","Denver","Phoneix","Sacramento","Salem","Olympia",null,"Capitals","Topeka","Denver","Phoenix","Sacramento","Salem","Olympia"]
[null,"Helper Row",6,5,4,3,2,1,null,"Helper Row",6,5,4,3,2,1]

{"sheet":"VBA-V","index":5,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,4,1,5]]}
[]
[null,"Applying VBA to Reverse Data Vertically",null,null,"Practice"]
[]
[null,"States","Colorado",null,"States","Colorado"]
[null,"Kansas","Topeka",null,"Kansas","Topeka"]
[null,"Colorado","Denver",null,"Colorado","Denver"]
[null,"Arizona","Phoenix",null,"Arizona","Phoenix"]
[null,"California","Sacramento",null,"California","Sacramento"]
[null,"Oregon","Salem",null,"Oregon","Salem"]
[null,"Washington","Olympia",null,"Washington","Olympia"]

{"sheet":"VBA-H","index":6,"n_rows":5,"n_cols":16,"rows_kept":5,"cut":false,"hidden":false,"merged":[[1,1,1,7],[1,9,1,15]]}
[]
[null,"Using VBA to Reverse Data Horizontally",null,null,null,null,null,null,null,"Practice"]
[]
[null,"States","Kansas","Colorado","Arizona","California","Oregon","Washington",null,"States","Washington","Oregon","California","Arizona","Colorado","Kansas"]
[null,"Capitals","Topeka","Denver","Phoneix","Sacramento","Salem","Olympia",null,"Capitals","Olympia","Salem","Sacramento","Phoneix","Denver","Topeka"]