{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["main","Sort","INDEX","SORTBY","VBA"],"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":"main","index":0,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Flip Data in Excel Upside Down"]
[]
[null,"Name","State","City"]
[null,"Ben Van Lier","Colorado","Pueblo"]
[null,"Adam King","Washington","Tacoma"]
[null,"Rowan Bettjeman","Texas","Bryan"]
[null,"Ellie Harwood","California","San Diego"]
[null,"Britt Scott Clark","Illinois","Chicago"]
[null,"Alan Morrison","Ohio","Cleveland"]

{"sheet":"Sort","index":1,"n_rows":10,"n_cols":8,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,5,1,7]]}
[]
[null,"Using Sort Feature",null,null,null,"Practice"]
[]
[null,"Name","State","No.",null,"Name","State","No."]
[null,"Alan Morrison","Ohio",5,null,"Ben Van Lier","Colorado",0]
[null,"Britt Scott Clark","Illinois",4,null,"Adam King","Washington",1]
[null,"Ellie Harwood","California",3,null,"Rowan Bettjeman","Texas",2]
[null,"Rowan Bettjeman","Texas",2,null,"Ellie Harwood","California",3]
[null,"Adam King","Washington",1,null,"Britt Scott Clark","Illinois",4]
[null,"Ben Van Lier","Colorado",0,null,"Alan Morrison","Ohio",5]

{"sheet":"INDEX","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,"Combining INDEX and ROWS Functions",null,null,null,null,null,"Practice"]
[]
[null,"Name","State",null,"Name","State",null,"Name","State",null,"Name","State"]
[null,"Ben Van Lier","Colorado",null,{"$f":"INDEX(B$5:B$10,ROWS(B5:B$10))","v":"Alan Morrison"},{"$f":"INDEX(C$5:C$10,ROWS(C5:C$10))","v":"Ohio"},null,"Ben Van Lier","Colorado"]
[null,"Adam King","Washington",null,{"$f":"INDEX(B$5:B$10,ROWS(B6:B$10))","v":"Britt Scott Clark"},{"$f":"INDEX(C$5:C$10,ROWS(C6:C$10))","v":"Illinois"},null,"Adam King","Washington"]
[null,"Rowan Bettjeman","Texas",null,{"$f":"INDEX(B$5:B$10,ROWS(B7:B$10))","v":"Ellie Harwood"},{"$f":"INDEX(C$5:C$10,ROWS(C7:C$10))","v":"California"},null,"Rowan Bettjeman","Texas"]
[null,"Ellie Harwood","California",null,{"$f":"INDEX(B$5:B$10,ROWS(B8:B$10))","v":"Rowan Bettjeman"},{"$f":"INDEX(C$5:C$10,ROWS(C8:C$10))","v":"Texas"},null,"Ellie Harwood","California"]
[null,"Britt Scott Clark","Illinois",null,{"$f":"INDEX(B$5:B$10,ROWS(B9:B$10))","v":"Adam King"},{"$f":"INDEX(C$5:C$10,ROWS(C9:C$10))","v":"Washington"},null,"Britt Scott Clark","Illinois"]
[null,"Alan Morrison","Ohio",null,{"$f":"INDEX(B$5:B$10,ROWS(B10:B$10))","v":"Ben Van Lier"},{"$f":"INDEX(C$5:C$10,ROWS(C10:C$10))","v":"Colorado"},null,"Alan Morrison","Ohio"]

{"sheet":"SORTBY","index":3,"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,"Name","State",null,"Name","State",null,"Name","State",null,"Name","State"]
[null,"Ben Van Lier","Colorado",null,{"$f":"_xlfn.SORTBY($B$5:$C$10,ROW(B5:B10),-1)","v":"Alan Morrison"},"Ohio",null,"Ben Van Lier","Colorado"]
[null,"Adam King","Washington",null,"Britt Scott Clark","Illinois",null,"Adam King","Washington"]
[null,"Rowan Bettjeman","Texas",null,"Ellie Harwood","California",null,"Rowan Bettjeman","Texas"]
[null,"Ellie Harwood","California",null,"Rowan Bettjeman","Texas",null,"Ellie Harwood","California"]
[null,"Britt Scott Clark","Illinois",null,"Adam King","Washington",null,"Britt Scott Clark","Illinois"]
[null,"Alan Morrison","Ohio",null,"Ben Van Lier","Colorado",null,"Alan Morrison","Ohio"]

{"sheet":"VBA","index":4,"n_rows":11,"n_cols":8,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,5,1,7]]}
[]
[null,"Applying VBA",null,null,null,"Practice"]
[]
[null,"Name","State","City",null,"Name","State","City"]
[null,"Alan Morrison","Ohio","Cleveland",null,"Ben Van Lier","Colorado","Pueblo"]
[null,"Britt Scott Clark","Illinois","Chicago",null,"Adam King","Washington","Tacoma"]
[null,"Ellie Harwood","California","San Diego",null,"Rowan Bettjeman","Texas","Bryan"]
[null,"Rowan Bettjeman","Texas","Bryan",null,"Ellie Harwood","California","San Diego"]
[null,"Adam King","Washington","Tacoma",null,"Britt Scott Clark","Illinois","Chicago"]
[null,"Ben Van Lier","Colorado","Pueblo",null,"Alan Morrison","Ohio","Cleveland"]
[null,null,null,"`"]