{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["SORTBY & LEN","VBA","Single Column Sorting"],"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":"SORTBY & LEN","index":0,"n_rows":18,"n_cols":13,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,8,1,12]]}
[]
[null,"Using SORTBY and LEN Functions",null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Name","Quantity","Delivery Date","Status","Price",null,null,"Name","Quantity","Delivery Date","Status","Price"]
[null,"Apples",5,"2021-09-05","Pending ",2500]
[null,"Eggplant",10,"2021-10-06","Processing",150]
[null,"White potato ",11,"2021-07-07","Completed",500]
[null,"Grapes ",25,"2021-12-08","Processing",4000]
[null,"Mango",15,"2021-01-09","Completed",2700]
[null,"Butter ",6,"2021-08-10","Processing",600]
[]
[null,"Name","Quantity","Delivery Date","Status","Price"]
[null,{"$f":"_xlfn.SORTBY(B5:B10,LEN(B5:B10),1)","v":"Mango"},{"$f":"_xlfn.SORTBY(C5:C10,LEN(C5:C10),1)","v":5},{"$f":"_xlfn.SORTBY(D5:D10,LEN(D5:D10),1)","v":"2021-09-05"},{"$f":"_xlfn.SORTBY(E5:E10,LEN(E5:E10),1)","v":"Pending "},{"$f":"_xlfn.SORTBY(F5:F10,LEN(F5:F10),1)","v":150}]
[null,"Apples",6,"2021-10-06","Completed",500]
[null,"Grapes ",10,"2021-07-07","Completed",600]
[null,"Butter ",11,"2021-12-08","Processing",2500]
[null,"Eggplant",25,"2021-01-09","Processing",4000]
[null,"White potato ",15,"2021-08-10","Processing",2700]

{"sheet":"VBA","index":1,"n_rows":15,"n_cols":6,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Using VBA Code"]
[]
[null,"Name","Quantity","Delivery Date","Status","Price"]
[null,"Apples",5,"2021-01-09","Completed",150]
[null,"Butter ",6,"2021-05-12","Completed",500]
[null,"Cauliflower",8,"2021-07-07","Completed",600]
[null,"Cheese",9,"2021-08-10","Pending",1200]
[null,"Eggplant",10,"2021-09-05","Pending",2200]
[null,"Grapes ",10,"2021-09-11","Pending",2500]
[null,"Mango",11,"2021-09-13","Pending ",2600]
[null,"Milk",15,"2021-10-06","Processing",2700]
[null,"Orange",20,"2021-10-16","Processing",3500]
[null,"Pineapple",25,"2021-12-08","Processing",4000]
[null,"White potato ",81,"2021-12-15","Processing",5000]

{"sheet":"Single Column Sorting","index":2,"n_rows":15,"n_cols":6,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Sorting Based on Single Column"]
[]
[null,"Name","Quantity","Delivery Date","Status","Price"]
[null,"Eggplant",10,"2021-10-06","Processing",150]
[null,"White potato ",11,"2021-07-07","Completed",500]
[null,"Butter ",6,"2021-08-10","Processing",600]
[null,"Cauliflower",81,"2021-12-15","Pending",1200]
[null,"Pineapple",20,"2021-10-16","Pending",2200]
[null,"Apples",5,"2021-09-05","Pending ",2500]
[null,"Orange",10,"2021-09-13","Pending",2600]
[null,"Mango",15,"2021-01-09","Completed",2700]
[null,"Cheese",9,"2021-05-12","Completed",3500]
[null,"Grapes ",25,"2021-12-08","Processing",4000]
[null,"Milk",8,"2021-09-11","Processing",5000]