{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Overview","Ascending","Descending","Multiple Columns","SORTBY","VLOOKUP","LARGE","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":"Overview","index":0,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Overview"]
[]
[null,"Sales Rep","Sales Region","Salary"]
[null,"Emma","Chicago",69738]
[null,"Ava","Ohio",54039]
[null,"Sophia","Boston",55274]
[null,"Isabella","California",52422]
[null,"Harry","Texas",51664]
[null,"Michael","Florida",63782]
[null,"Carlos","New York",65208]
[null,"John","California",63457]
[null,"Dalton","Washington DC",54805]
[null,"Ben","Los Angeles",62708]

{"sheet":"Ascending","index":1,"n_rows":14,"n_cols":8,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,"Auto Sort Table in Ascending Order"]
[]
[null,"Sales Rep","Sales Region","Salary",null,"Sales Rep","Sales Region","Salary"]
[null,"Emma","Chicago",69738,null,{"$f":"_xlfn._xlws.SORT(B5:D14,3,1)","v":"Harry"},"Texas",51664]
[null,"Ava","Ohio",54039,null,"Isabella","California",52422]
[null,"Sophia","Boston",55274,null,"Ava","Ohio",54039]
[null,"Isabella","California",52422,null,"Dalton","Washington DC",54805]
[null,"Harry","Texas",51664,null,"Sophia","Boston",55274]
[null,"Michael","Florida",63782,null,"Ben","Los Angeles",62708]
[null,"Carlos","New York",65208,null,"John","California",63457]
[null,"John","California",63457,null,"Michael","Florida",63782]
[null,"Dalton","Washington DC",54805,null,"Carlos","New York",65208]
[null,"Ben","Los Angeles",62708,null,"Emma","Chicago",69738]

{"sheet":"Descending","index":2,"n_rows":14,"n_cols":8,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,"Auto Sort Table in Descending Order"]
[]
[null,"Sales Rep","Sales Region","Salary",null,"Sales Rep","Sales Region","Salary"]
[null,"Emma","Chicago",69738,null,{"$f":"_xlfn._xlws.SORT(B5:D14,3,-1)","v":"Emma"},"Chicago",69738]
[null,"Ava","Ohio",54039,null,"Carlos","New York",65208]
[null,"Sophia","Boston",55274,null,"Michael","Florida",63782]
[null,"Isabella","California",52422,null,"John","California",63457]
[null,"Harry","Texas",51664,null,"Ben","Los Angeles",62708]
[null,"Michael","Florida",63782,null,"Sophia","Boston",55274]
[null,"Carlos","New York",65208,null,"Dalton","Washington DC",54805]
[null,"John","California",63457,null,"Ava","Ohio",54039]
[null,"Dalton","Washington DC",54805,null,"Isabella","California",52422]
[null,"Ben","Los Angeles",62708,null,"Harry","Texas",51664]

{"sheet":"Multiple Columns","index":3,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Auto Sort Table in Multiple Columns"]
[]
[null,"Sales Rep","Salary",null,"Sales Rep","Salary"]
[null,"Emma",69738,null,{"$f":"_xlfn._xlws.SORT(B5:C14, {1,2}, {1,1})","v":"Ava"},54039]
[null,"Ava",54039,null,"Ben",62708]
[null,"Sophia",55274,null,"Carlos",65208]
[null,"Isabella",52422,null,"Dalton",54805]
[null,"Harry",51664,null,"Emma",69738]
[null,"Michael",63782,null,"Harry",51664]
[null,"Carlos",65208,null,"Isabella",52422]
[null,"John",63457,null,"John",63457]
[null,"Dalton",54805,null,"Michael",63782]
[null,"Ben",62708,null,"Sophia",55274]

{"sheet":"SORTBY","index":4,"n_rows":14,"n_cols":8,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,"Use the SORTBY Function  to Auto Sort Table"]
[]
[null,"Sales Rep","Sales Region","Salary",null,"Sales Rep","Sales Region","Salary"]
[null,"Emma","Chicago",69738,null,{"$f":"_xlfn.SORTBY(B5:D14, D5:D14)","v":"Harry"},"Texas",51664]
[null,"Ava","Ohio",54039,null,"Isabella","California",52422]
[null,"Sophia","Boston",55274,null,"Ava","Ohio",54039]
[null,"Isabella","California",52422,null,"Dalton","Washington DC",54805]
[null,"Harry","Texas",51664,null,"Sophia","Boston",55274]
[null,"Michael","Florida",63782,null,"Ben","Los Angeles",62708]
[null,"Carlos","New York",70000,null,"John","California",63457]
[null,"John","California",63457,null,"Michael","Florida",63782]
[null,"Dalton","Washington DC",54805,null,"Emma","Chicago",69738]
[null,"Ben","Los Angeles",62708,null,"Carlos","New York",70000]

{"sheet":"VLOOKUP","index":5,"n_rows":14,"n_cols":8,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,"VLOOKUP Function to Auto Sort Table"]
[]
[null,"Rank","Sales Rep","Salary",null,"Rank","Sales Rep","Salary"]
[null,{"$f":"_xlfn.RANK.EQ(D5,D$5:D$14,1)","v":10},"Emma",69738,null,1,{"$f":"VLOOKUP(F5,$B$5:$D$14,2, FALSE)","v":"Harry"},{"$f":"VLOOKUP(G5,$C$5:$E$14,2, FALSE)","v":51664}]
[null,{"$f":"_xlfn.RANK.EQ(D6,D$5:D$14,1)","v":3},"Ava",54039,null,2,{"$f":"VLOOKUP(F6,$B$5:$D$14,2, FALSE)","v":"Isabella"},{"$f":"VLOOKUP(G6,$C$5:$E$14,2, FALSE)","v":52422}]
[null,5,"Sophia",55274,null,3,"Ava",54039]
[null,2,"Isabella",52422,null,4,"Dalton",54805]
[null,1,"Harry",51664,null,5,"Sophia",55274]
[null,8,"Michael",63782,null,6,"Ben",62708]
[null,9,"Carlos",65208,null,7,"John",63457]
[null,7,"John",63457,null,8,"Michael",63782]
[null,4,"Dalton",54805,null,9,"Carlos",65208]
[null,6,"Ben",62708,null,10,"Emma",69738]

{"sheet":"LARGE","index":6,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Apply the LARGE Function to Auto Sort Table"]
[]
[null,"Sales Rep","Sales ID","Salary","Remarks"]
[null,"Emma",1,69738,{"$f":"LARGE(B$5:D$14,C5)","v":69738}]
[null,"Ava",2,54039,{"$f":"LARGE(B$5:D$14,C6)","v":65208}]
[null,"Sophia",3,55274,63782]
[null,"Isabella",4,52422,63457]
[null,"Harry",5,51664,62708]
[null,"Michael",6,63782,55274]
[null,"Carlos",7,65208,54805]
[null,"John",8,63457,54039]
[null,"Dalton",9,54805,52422]
[null,"Ben",10,62708,51664]

{"sheet":"VBA","index":7,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Sales Rep","Salary"]
[null,"Ava",54039]
[null,"Ben",62708]
[null,"Carlos",65208]
[null,"Dalton",54805]
[null,"Emma",69738]
[null,"Harry",51664]
[null,"Isabella",52422]
[null,"John",63457]
[null,"Michael",63782]
[null,"Sophia",55274]