{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["dataset","index & rows","sortby","sort feature","vba","diy"],"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":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Flip Data Vertically"]
[]
[null,"Serial","Name","Profession"]
[null,1,"Ingmar","Senior Financial Analyst"]
[null,2,"Rocky","Recruiter"]
[null,3,"Zane","Geologist III"]
[null,4,"Carl","GIS Technical Architect"]
[null,5,"Johannah","Librarian"]
[null,6,"Anna-diane","Tax Accountant"]
[null,7,"Lenna","Account Coordinator"]
[null,8,"Samantha","Software Test Engineer I"]
[null,9,"Lothario","Mechanical Systems Engineer"]

{"sheet":"index & rows","index":1,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Using INDEX and ROWS Functions"]
[]
[null,"Name","Profession",null,"Name","Profession"]
[null,"Ingmar","Senior Financial Analyst",null,{"$f":"INDEX(B$5:B$10,ROWS(B5:B$10))","v":"Anna-diane"},{"$f":"INDEX(C$5:C$10,ROWS(C5:C$10))","v":"Tax Accountant"}]
[null,"Rocky","Recruiter",null,{"$f":"INDEX(B$5:B$10,ROWS(B6:B$10))","v":"Johannah"},{"$f":"INDEX(C$5:C$10,ROWS(C6:C$10))","v":"Librarian"}]
[null,"Zane","Geologist III",null,{"$f":"INDEX(B$5:B$10,ROWS(B7:B$10))","v":"Carl"},{"$f":"INDEX(C$5:C$10,ROWS(C7:C$10))","v":"GIS Technical Architect"}]
[null,"Carl","GIS Technical Architect",null,{"$f":"INDEX(B$5:B$10,ROWS(B8:B$10))","v":"Zane"},{"$f":"INDEX(C$5:C$10,ROWS(C8:C$10))","v":"Geologist III"}]
[null,"Johannah","Librarian",null,{"$f":"INDEX(B$5:B$10,ROWS(B9:B$10))","v":"Rocky"},{"$f":"INDEX(C$5:C$10,ROWS(C9:C$10))","v":"Recruiter"}]
[null,"Anna-diane","Tax Accountant",null,{"$f":"INDEX(B$5:B$10,ROWS(B10:B$10))","v":"Ingmar"},{"$f":"INDEX(C$5:C$10,ROWS(C10:C$10))","v":"Senior Financial Analyst"}]

{"sheet":"sortby","index":2,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Using SORTBY and ROW Functions"]
[]
[null,"Name","Profession",null,"Name","Profession"]
[null,"Ingmar","Senior Financial Analyst",null,{"$f":"_xlfn.SORTBY($B$5:$C$10,ROW(B5:B10),-1)","v":"Anna-diane"},"Tax Accountant"]
[null,"Rocky","Recruiter",null,"Johannah","Librarian"]
[null,"Zane","Geologist III",null,"Carl","GIS Technical Architect"]
[null,"Carl","GIS Technical Architect",null,"Zane","Geologist III"]
[null,"Johannah","Librarian",null,"Rocky","Recruiter"]
[null,"Anna-diane","Tax Accountant",null,"Ingmar","Senior Financial Analyst"]

{"sheet":"sort feature","index":3,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using Sort Feature"]
[]
[null,"Serial","Name","Profession"]
[null,9,"Lothario","Mechanical Systems Engineer"]
[null,8,"Samantha","Software Test Engineer I"]
[null,7,"Lenna","Account Coordinator"]
[null,6,"Anna-diane","Tax Accountant"]
[null,5,"Johannah","Librarian"]
[null,4,"Carl","GIS Technical Architect"]
[null,3,"Zane","Geologist III"]
[null,2,"Rocky","Recruiter"]
[null,1,"Ingmar","Senior Financial Analyst"]

{"sheet":"vba","index":4,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using VBA"]
[]
[null,"Serial","Name","Profession"]
[null,9,"Lothario","Mechanical Systems Engineer"]
[null,8,"Samantha","Software Test Engineer I"]
[null,7,"Lenna","Account Coordinator"]
[null,6,"Anna-diane","Tax Accountant"]
[null,5,"Johannah","Librarian"]
[null,4,"Carl","GIS Technical Architect"]
[null,3,"Zane","Geologist III"]
[null,2,"Rocky","Recruiter"]
[null,1,"Ingmar","Senior Financial Analyst"]

{"sheet":"diy","index":5,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Do It Yourself"]
[]
[null,"Serial","Name","Profession"]
[null,1,"Ingmar","Senior Financial Analyst"]
[null,2,"Rocky","Recruiter"]
[null,3,"Zane","Geologist III"]
[null,4,"Carl","GIS Technical Architect"]
[null,5,"Johannah","Librarian"]
[null,6,"Anna-diane","Tax Accountant"]
[null,7,"Lenna","Account Coordinator"]
[null,8,"Samantha","Software Test Engineer I"]
[null,9,"Lothario","Mechanical Systems Engineer"]