{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Sort Command(V)","Sort Command(H)","OFFSET & ROWS Function(V)","OFFSET,COUNTA, and COLUMN","VBA(V)","VBA(H)","INDEX & ROWS Command","COUNTA & INDEX Command","ROWS & SORTBY Command"],"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":"Sort Command(V)","index":0,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using Sort Command"]
[]
[null,"Employee ","Employee ID","Sorting Column"]
[null,"Tom",108,6]
[null,"Sheldon",111,5]
[null,"Alisa",107,4]
[null,"Harry",105,3]
[null,"Jhon",101,2]
[null,"Adam",102,1]

{"sheet":"Sort Command(H)","index":1,"n_rows":6,"n_cols":6,"rows_kept":6,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Using Sort Command"]
[]
[null,"Employee","Alisa","Shelly","Jhon","Adam"]
[null,"Employee ID",104,103,105,102]
[null,"Sorting Row",4,3,2,1]

{"sheet":"OFFSET & ROWS Function(V)","index":2,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null," Applying Combination of OFFSET and ROWS Functions"]
[]
[null,"Employee ","Employee ID",null,"Paste In Reverse Order"]
[null,"Adam",102,null,{"$f":"OFFSET($B$10,-(ROW(B2)-2),0)","v":"Tom"}]
[null,"Jhon",101,null,{"$f":"OFFSET($B$10,-(ROW(B3)-2),0)","v":"Sheldon"}]
[null,"Harry",105,null,"Alisa"]
[null,"Alisa",107,null,"Harry"]
[null,"Sheldon",111,null,"Jhon"]
[null,"Tom",108,null,"Adam"]

{"sheet":"OFFSET,COUNTA, and COLUMN","index":3,"n_rows":8,"n_cols":6,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Using OFFSET, COUNTA, and COLUMN Functions Together"]
[]
[null,"Employee","Adam","Jhon","Shelly","Alisa"]
[null,"Employee ID",102,105,103,104]
[]
[]
[null,"Paste in Reverse Order",{"$f":"OFFSET($B$4,,COUNTA(4:4)-COLUMN(A1))","v":"Alisa"},{"$f":"OFFSET($B$4,,COUNTA(4:4)-COLUMN(B1))","v":"Shelly"},"Jhon","Adam"]

{"sheet":"VBA(V)","index":4,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Applying VBA Code"]
[]
[null,"Employee ","Employee ID"]
[null,"Tom",108]
[null,"Sheldon",111]
[null,"Alisa",107]
[null,"Harry",105]
[null,"Jhon",101]
[null,"Adam",102]

{"sheet":"VBA(H)","index":5,"n_rows":5,"n_cols":6,"rows_kept":5,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Applying VBA Code"]
[]
[null,"Employee","Alisa","Shelly","Jhon","Adam"]
[null,"Employee ID",104,103,105,102]

{"sheet":"INDEX & ROWS Command","index":6,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Use a Combination of INDEX and Rows Functions"]
[]
[null,"Employee ","Employee ID",null,"Paste In Reverse Order"]
[null,"Adam",102,null,{"$f":"INDEX($B$5:$B$10,ROWS(B5:$B$10))","v":"Tom"}]
[null,"Jhon",101,null,{"$f":"INDEX($B$5:$B$10,ROWS(B6:$B$10))","v":"Sheldon"}]
[null,"Harry",105,null,{"$f":"INDEX($B$5:$B$10,ROWS(B7:$B$10))","v":"Alisa"}]
[null,"Alisa",107,null,{"$f":"INDEX($B$5:$B$10,ROWS(B8:$B$10))","v":"Harry"}]
[null,"Sheldon",111,null,{"$f":"INDEX($B$5:$B$10,ROWS(B9:$B$10))","v":"Jhon"}]
[null,"Tom",108,null,{"$f":"INDEX($B$5:$B$10,ROWS(B10:$B$10))","v":"Adam"}]

{"sheet":"COUNTA & INDEX Command","index":7,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Utilizing COUNTA and INDEX Functions Together"]
[]
[null,"Employee ","Employee ID",null,"Paste In Reverse Order"]
[null,"Adam",102,null,{"$f":"INDEX($B$4:$B$10,COUNTA(B4:B$10))","v":"Tom"}]
[null,"Jhon",101,null,{"$f":"INDEX($B$4:$B$10,COUNTA(B5:B$10))","v":"Sheldon"}]
[null,"Harry",105,null,{"$f":"INDEX($B$4:$B$10,COUNTA(B6:B$10))","v":"Alisa"}]
[null,"Alisa",107,null,{"$f":"INDEX($B$4:$B$10,COUNTA(B7:B$10))","v":"Harry"}]
[null,"Sheldon",111,null,{"$f":"INDEX($B$4:$B$10,COUNTA(B8:B$10))","v":"Jhon"}]
[null,"Tom",108,null,{"$f":"INDEX($B$4:$B$10,COUNTA(B9:B$10))","v":"Adam"}]

{"sheet":"ROWS & SORTBY Command","index":8,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Combining ROWS and SORTBY Functions"]
[]
[null,"Employee ","Employee ID",null,"Paste In Reverse Order"]
[null,"Adam",102,null,{"$f":"_xlfn.SORTBY(B5:B10,ROW(B5:B10),-1)","v":"Tom"}]
[null,"Jhon",101,null,"Sheldon"]
[null,"Harry",105,null,"Alisa"]
[null,"Alisa",107,null,"Harry"]
[null,"Sheldon",111,null,"Jhon"]
[null,"Tom",108,null,"Adam"]