{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Dataset","Home or Data","Context Menu","Filter","Custom Sort","Month Function","SORT Function"," Auto Sorting 2","Auto Sorting","VBA"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":16,"n_cols":6,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Product Sales"]
[]
[null,"Order Date","Product","Quantity","Unit Price","Total Cost"]
[null,"2022-03-09","Chocolate Chip",24,1.87,{"$f":"PRODUCT(D5,E5)","v":44.88}]
[null,"2022-03-03","Bran",83,1.87,155.21]
[null,"2022-03-04","Oatmeal Raisin",124,2.8400000000000003,352.16]
[null,"2022-03-10","Carrot",137,1.77,242.49]
[null,"2022-03-15","Arrowroot",146,2.1799999999999997,318.27999999999997]
[null,"2022-03-11","Chocolate Chip",34,1.8699999999999999,63.58]
[null,"2022-03-13","Carrot",20,1.77,35.4]
[null,"2022-03-12","Arrowroot",139,2.1799999999999997,303.02]
[null,"2022-03-14","Whole Wheat",30,3.49,104.7]
[null,"2022-03-05","Carrot",35,1.77,61.95]
[null,"2022-03-06","Bran",57,1.87,106.59]
[null,"2022-03-07","Potato Chips",25,1.68,42]

{"sheet":"Home or Data","index":1,"n_rows":16,"n_cols":6,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Product Sales"]
[]
[null,"Order Date","Product","Quantity","Unit Price","Total Cost"]
[null,"2022-03-15","Arrowroot",146,2.1799999999999997,{"$f":"PRODUCT(D5,E5)","v":318.27999999999997}]
[null,"2022-03-14","Whole Wheat",30,3.49,104.7]
[null,"2022-03-13","Carrot",20,1.77,35.4]
[null,"2022-03-12","Arrowroot",139,2.1799999999999997,303.02]
[null,"2022-03-11","Chocolate Chip",34,1.8699999999999999,63.58]
[null,"2022-03-10","Carrot",137,1.77,242.49]
[null,"2022-03-09","Chocolate Chip",24,1.87,44.88]
[null,"2022-03-07","Potato Chips",25,1.68,42]
[null,"2022-03-06","Bran",57,1.87,106.59]
[null,"2022-03-05","Carrot",35,1.77,61.95]
[null,"2022-03-04","Oatmeal Raisin",124,2.8400000000000003,352.16]
[null,"2022-03-03","Bran",83,1.87,155.21]

{"sheet":"Context Menu","index":2,"n_rows":16,"n_cols":6,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Product Sales"]
[]
[null,"Order Date","Product","Quantity","Unit Price","Total Cost"]
[null,"2022-03-03","Bran",83,1.87,{"$f":"PRODUCT(D5,E5)","v":155.21}]
[null,"2022-03-04","Oatmeal Raisin",124,2.8400000000000003,352.16]
[null,"2022-03-05","Carrot",35,1.77,61.95]
[null,"2022-03-06","Bran",57,1.87,106.59]
[null,"2022-03-07","Potato Chips",25,1.68,42]
[null,"2022-03-09","Chocolate Chip",24,1.87,44.88]
[null,"2022-03-10","Carrot",137,1.77,242.49]
[null,"2022-03-11","Chocolate Chip",34,1.8699999999999999,63.58]
[null,"2022-03-12","Arrowroot",139,2.1799999999999997,303.02]
[null,"2022-03-13","Carrot",20,1.77,35.4]
[null,"2022-03-14","Whole Wheat",30,3.49,104.7]
[null,"2022-03-15","Arrowroot",146,2.1799999999999997,318.27999999999997]

{"sheet":"Filter","index":3,"n_rows":16,"n_cols":6,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Product Sales"]
[]
[null,"Order Date","Product","Quantity","Unit Price","Total Cost"]
[null,"2022-03-03","Bran",83,1.87,{"$f":"PRODUCT(D5,E5)","v":155.21}]
[null,"2022-03-04","Oatmeal Raisin",124,2.8400000000000003,352.16]
[null,"2022-03-05","Carrot",35,1.77,61.95]
[null,"2022-03-06","Bran",57,1.87,106.59]
[null,"2022-03-07","Potato Chips",25,1.68,42]
[null,"2022-03-09","Chocolate Chip",24,1.87,44.88]
[null,"2022-03-10","Carrot",137,1.77,242.49]
[null,"2022-03-11","Chocolate Chip",34,1.8699999999999999,63.58]
[null,"2022-03-12","Arrowroot",139,2.1799999999999997,303.02]
[null,"2022-03-13","Carrot",20,1.77,35.4]
[null,"2022-03-14","Whole Wheat",30,3.49,104.7]
[null,"2022-03-15","Arrowroot",146,2.1799999999999997,318.27999999999997]

{"sheet":"Custom Sort","index":4,"n_rows":16,"n_cols":6,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Product Sales"]
[]
[null,"Order Date","Product","Quantity","Unit Price","Total Cost"]
[null,"2022-03-03","Bran",83,1.87,{"$f":"PRODUCT(D5,E5)","v":155.21}]
[null,"2022-03-04","Oatmeal Raisin",124,2.8400000000000003,352.16]
[null,"2022-03-05","Carrot",35,1.77,61.95]
[null,"2022-03-06","Bran",57,1.87,106.59]
[null,"2022-03-07","Potato Chips",25,1.68,42]
[null,"2022-03-09","Chocolate Chip",24,1.87,44.88]
[null,"2022-03-10","Carrot",137,1.77,242.49]
[null,"2022-03-11","Chocolate Chip",34,1.8699999999999999,63.58]
[null,"2022-03-12","Arrowroot",139,2.1799999999999997,303.02]
[null,"2022-03-13","Carrot",20,1.77,35.4]
[null,"2022-03-14","Whole Wheat",30,3.49,104.7]
[null,"2022-03-15","Arrowroot",146,2.1799999999999997,318.27999999999997]

{"sheet":"Month Function","index":5,"n_rows":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Product Sales"]
[]
[null,"Order Date","Product","Quantity","Helper Column"]
[null,"2022-01-11","Chocolate Chip",24,{"$f":"MONTH(B5)","v":1}]
[null,"2022-02-15","Arrowroot",25,2]
[null,"2022-03-09","Chocolate Chip",83,3]
[null,"2022-03-03","Bran",124,3]
[null,"2022-03-05","Carrot",20,3]
[null,"2022-04-04","Oatmeal Raisin",35,4]
[null,"2022-04-14","Whole Wheat",139,4]
[null,"2022-05-06","Bran",30,5]
[null,"2022-06-10","Carrot",57,6]
[null,"2022-06-12","Arrowroot",34,6]
[null,"2022-07-13","Carrot",137,7]
[null,"2022-07-07","Potato Chips",146,7]

{"sheet":"SORT Function","index":6,"n_rows":16,"n_cols":12,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Product Sales"]
[]
[null,"Order Date","Product","Quantity","Unit Price","Total Cost"]
[null,"2022-03-09","Chocolate Chip",24,1.87,{"$f":"PRODUCT(D5,E5)","v":44.88},null,{"$f":"_xlfn.SORTBY(B5:F16,B5:B16,1)","v":"2022-03-03"},"Bran",83,1.87,155.21]
[null,"2022-03-03","Bran",83,1.87,155.21,null,"2022-03-04","Oatmeal Raisin",124,2.8400000000000003,352.16]
[null,"2022-03-04","Oatmeal Raisin",124,2.8400000000000003,352.16,null,"2022-03-05","Carrot",35,1.77,61.95]
[null,"2022-03-10","Carrot",137,1.77,242.49,null,"2022-03-06","Bran",57,1.87,106.59]
[null,"2022-03-15","Arrowroot",146,2.1799999999999997,318.27999999999997,null,"2022-03-07","Potato Chips",25,1.68,42]
[null,"2022-03-11","Chocolate Chip",34,1.8699999999999999,63.58,null,"2022-03-09","Chocolate Chip",24,1.87,44.88]
[null,"2022-03-13","Carrot",20,1.77,35.4,null,"2022-03-10","Carrot",137,1.77,242.49]
[null,"2022-03-12","Arrowroot",139,2.1799999999999997,303.02,null,"2022-03-11","Chocolate Chip",34,1.8699999999999999,63.58]
[null,"2022-03-14","Whole Wheat",30,3.49,104.7,null,"2022-03-12","Arrowroot",139,2.1799999999999997,303.02]
[null,"2022-03-05","Carrot",35,1.77,61.95,null,"2022-03-13","Carrot",20,1.77,35.4]
[null,"2022-03-06","Bran",57,1.87,106.59,null,"2022-03-14","Whole Wheat",30,3.49,104.7]
[null,"2022-03-07","Potato Chips",25,1.68,42,null,"2022-03-15","Arrowroot",146,2.1799999999999997,318.27999999999997]

{"sheet":" Auto Sorting 2","index":7,"n_rows":16,"n_cols":10,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Product Sales"]
[]
[null,"Order Date","Product","Quantity","Unit Price","Total Cost"]
[null,"2022-03-09","Chocolate Chip",24,1.87,{"$f":"PRODUCT(D5,E5)","v":44.88},null,{"$f":"INDEX(B5:F16,MATCH(ROW(A1:A12),RANK(B5:B16,B5:B16,1),0),{1,2,5})","v":"2022-03-03"},"Bran",155.21]
[null,"2022-03-03","Bran",83,1.87,155.21,null,"2022-03-04","Oatmeal Raisin",352.16]
[null,"2022-03-04","Oatmeal Raisin",124,2.8400000000000003,352.16,null,"2022-03-05","Carrot",61.95]
[null,"2022-03-10","Carrot",137,1.77,242.49,null,"2022-03-06","Bran",106.59]
[null,"2022-03-15","Arrowroot",146,2.1799999999999997,318.27999999999997,null,"2022-03-07","Potato Chips",42]
[null,"2022-03-11","Chocolate Chip",34,1.8699999999999999,63.58,null,"2022-03-09","Chocolate Chip",44.88]
[null,"2022-03-13","Carrot",20,1.77,35.4,null,"2022-03-10","Carrot",242.49]
[null,"2022-03-12","Arrowroot",139,2.1799999999999997,303.02,null,"2022-03-11","Chocolate Chip",63.58]
[null,"2022-03-14","Whole Wheat",30,3.49,104.7,null,"2022-03-12","Arrowroot",303.02]
[null,"2022-03-05","Carrot",35,1.77,61.95,null,"2022-03-13","Carrot",35.4]
[null,"2022-03-06","Bran",57,1.87,106.59,null,"2022-03-14","Whole Wheat",104.7]
[null,"2022-03-07","Potato Chips",25,1.68,42,null,"2022-03-15","Arrowroot",318.27999999999997]

{"sheet":"Auto Sorting","index":8,"n_rows":16,"n_cols":3,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Date Sorting"]
[]
[null,"Order Date","Sorted Date"]
[null,"2022-03-09",{"$f":"IFERROR(INDEX($B$5:$B$16, MATCH(ROWS($B$5:B5),\nCOUNTIF($B$5:$B$16, \"<=\"&$B$5:$B$16), 0)), \"\")","v":"2022-03-03"}]
[null,"2022-03-03",{"$f":"IFERROR(INDEX($B$5:$B$16, MATCH(ROWS($B$5:B6),\nCOUNTIF($B$5:$B$16, \"<=\"&$B$5:$B$16), 0)), \"\")","v":"2022-03-04"}]
[null,"2022-03-04",{"$f":"IFERROR(INDEX($B$5:$B$16, MATCH(ROWS($B$5:B7),\nCOUNTIF($B$5:$B$16, \"<=\"&$B$5:$B$16), 0)), \"\")","v":"2022-03-05"}]
[null,"2022-03-10",{"$f":"IFERROR(INDEX($B$5:$B$16, MATCH(ROWS($B$5:B8),\nCOUNTIF($B$5:$B$16, \"<=\"&$B$5:$B$16), 0)), \"\")","v":"2022-03-06"}]
[null,"2022-03-15",{"$f":"IFERROR(INDEX($B$5:$B$16, MATCH(ROWS($B$5:B9),\nCOUNTIF($B$5:$B$16, \"<=\"&$B$5:$B$16), 0)), \"\")","v":"2022-03-07"}]
[null,"2022-03-11",{"$f":"IFERROR(INDEX($B$5:$B$16, MATCH(ROWS($B$5:B10),\nCOUNTIF($B$5:$B$16, \"<=\"&$B$5:$B$16), 0)), \"\")","v":"2022-03-09"}]
[null,"2022-03-13",{"$f":"IFERROR(INDEX($B$5:$B$16, MATCH(ROWS($B$5:B11),\nCOUNTIF($B$5:$B$16, \"<=\"&$B$5:$B$16), 0)), \"\")","v":"2022-03-10"}]
[null,"2022-03-12",{"$f":"IFERROR(INDEX($B$5:$B$16, MATCH(ROWS($B$5:B12),\nCOUNTIF($B$5:$B$16, \"<=\"&$B$5:$B$16), 0)), \"\")","v":"2022-03-11"}]
[null,"2022-03-14",{"$f":"IFERROR(INDEX($B$5:$B$16, MATCH(ROWS($B$5:B13),\nCOUNTIF($B$5:$B$16, \"<=\"&$B$5:$B$16), 0)), \"\")","v":"2022-03-12"}]
[null,"2022-03-05",{"$f":"IFERROR(INDEX($B$5:$B$16, MATCH(ROWS($B$5:B14),\nCOUNTIF($B$5:$B$16, \"<=\"&$B$5:$B$16), 0)), \"\")","v":"2022-03-13"}]
[null,"2022-03-06",{"$f":"IFERROR(INDEX($B$5:$B$16, MATCH(ROWS($B$5:B15),\nCOUNTIF($B$5:$B$16, \"<=\"&$B$5:$B$16), 0)), \"\")","v":"2022-03-14"}]
[null,"2022-03-07",{"$f":"IFERROR(INDEX($B$5:$B$16, MATCH(ROWS($B$5:B16),\nCOUNTIF($B$5:$B$16, \"<=\"&$B$5:$B$16), 0)), \"\")","v":"2022-03-15"}]

{"sheet":"VBA","index":9,"n_rows":16,"n_cols":6,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Product Sales"]
[]
[null,"Order Date","Product","Quantity","Unit Price","Total Cost"]
[null,"2022-03-03","Bran",83,1.87,{"$f":"PRODUCT(D5,E5)","v":155.21}]
[null,"2022-03-04","Oatmeal Raisin",124,2.8400000000000003,352.16]
[null,"2022-03-05","Carrot",35,1.77,61.95]
[null,"2022-03-06","Bran",57,1.87,106.59]
[null,"2022-03-07","Potato Chips",25,1.68,42]
[null,"2022-03-09","Chocolate Chip",24,1.87,44.88]
[null,"2022-03-10","Carrot",137,1.77,242.49]
[null,"2022-03-11","Chocolate Chip",34,1.8699999999999999,63.58]
[null,"2022-03-12","Arrowroot",139,2.1799999999999997,303.02]
[null,"2022-03-13","Carrot",20,1.77,35.4]
[null,"2022-03-14","Whole Wheat",30,3.49,104.7]
[null,"2022-03-15","Arrowroot",146,2.1799999999999997,318.27999999999997]