{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Product Sales","Advanced Filter","Criteria","FILTER","Remove Duplicates","VBA"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":8,"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":"Product Sales","index":0,"n_rows":17,"n_cols":6,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Dataset for Advanced Filter Unique Records Only"]
[]
[null,"Order Date","Product","Quantity","Unit Price","Total Price"]
[null,"2022-02-02","Whole Wheat",30,3.49,{"$f":"PRODUCT(D5,E5)","v":104.7}]
[null,"2022-02-02","Carrot",35,1.77,{"$f":"PRODUCT(D6,E6)","v":61.95}]
[null,"2022-02-02","Carrot",35,1.77,61.95]
[null,"2022-02-02","Potato Chips",25,1.68,42]
[null,"2022-02-03","Chocolate Chip",24,1.87,44.88]
[null,"2022-02-03","Bran",83,1.87,155.21]
[null,"2022-02-03","Bran",83,1.87,155.21]
[null,"2022-02-03","Carrot",137,1.77,242.49]
[null,"2022-02-04","Arrowroot",146,2.1799999999999997,318.27999999999997]
[null,"2022-02-04","Chocolate Chip",34,1.8699999999999999,63.58]
[null,"2022-02-04","Chocolate Chip",34,1.8699999999999999,63.58]
[null,"2022-02-04","Arrowroot",139,2.1799999999999997,303.02]
[null,"2022-02-04","Chocolate Chip",211,1.8699999999999999,394.57]

{"sheet":"Advanced Filter","index":1,"n_rows":17,"n_cols":12,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Using Advanced Filter Feature"]
[]
[null,"Order Date","Product","Quantity","Unit Price","Total Price",null,"Order Date","Product","Quantity","Unit Price","Total Price"]
[null,"2022-02-02","Whole Wheat",30,3.49,{"$f":"PRODUCT(D5,E5)","v":104.7},null,"2022-02-02","Whole Wheat",30,3.49,104.7]
[null,"2022-02-02","Carrot",35,1.77,{"$f":"PRODUCT(D6,E6)","v":61.95},null,"2022-02-02","Carrot",35,1.77,61.95]
[null,"2022-02-02","Carrot",35,1.77,{"$f":"PRODUCT(D7,E7)","v":61.95},null,"2022-02-02","Potato Chips",25,1.68,42]
[null,"2022-02-02","Potato Chips",25,1.68,42,null,"2022-02-03","Chocolate Chip",24,1.87,44.88]
[null,"2022-02-03","Chocolate Chip",24,1.87,44.88,null,"2022-02-03","Bran",83,1.87,155.21]
[null,"2022-02-03","Bran",83,1.87,155.21,null,"2022-02-03","Carrot",137,1.77,242.49]
[null,"2022-02-03","Bran",83,1.87,{"$f":"PRODUCT(D11,E11)","v":155.21},null,"2022-02-04","Arrowroot",146,2.1799999999999997,318.27999999999997]
[null,"2022-02-03","Carrot",137,1.77,242.49,null,"2022-02-04","Chocolate Chip",34,1.8699999999999999,63.58]
[null,"2022-02-04","Arrowroot",146,2.1799999999999997,318.27999999999997,null,"2022-02-04","Arrowroot",139,2.1799999999999997,303.02]
[null,"2022-02-04","Chocolate Chip",34,1.8699999999999999,63.58,null,"2022-02-04","Chocolate Chip",211,1.8699999999999999,394.57]
[null,"2022-02-04","Chocolate Chip",34,1.8699999999999999,{"$f":"PRODUCT(D15,E15)","v":63.58}]
[null,"2022-02-04","Arrowroot",139,2.1799999999999997,303.02]
[null,"2022-02-04","Chocolate Chip",211,1.8699999999999999,394.57]

{"sheet":"Criteria","index":2,"n_rows":17,"n_cols":12,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,5],[3,7,3,9]]}
[]
[null,"Unique Records Depending on Criteria"]
[]
[null,"Order Date","Product","Quantity","Unit Price","Total Price",null,"Criteria"]
[null,"2022-02-02","Whole Wheat",30,3.49,{"$f":"PRODUCT(D5,E5)","v":104.7}]
[null,"2022-02-02","Carrot",35,1.77,{"$f":"PRODUCT(D6,E6)","v":61.95},null,"Order Date","Product","Quantity"]
[null,"2022-02-02","Carrot",35,1.77,61.95,null,"2022-02-03","Bran",">50"]
[null,"2022-02-02","Potato Chips",25,1.68,{"$f":"PRODUCT(D8,E8)","v":42}]
[null,"2022-02-03","Chocolate Chip",24,1.87,44.88,null,"Order Date","Product","Quantity","Unit Price","Total Price"]
[null,"2022-02-03","Bran",83,1.87,155.21,null,"2022-02-03","Bran",83,1.87,155.21]
[null,"2022-02-03","Bran",83,1.87,155.21]
[null,"2022-02-03","Carrot",137,1.77,242.49]
[null,"2022-02-04","Arrowroot",146,2.1799999999999997,318.27999999999997]
[null,"2022-02-04","Chocolate Chip",34,1.8699999999999999,63.58]
[null,"2022-02-04","Chocolate Chip",34,1.8699999999999999,63.58]
[null,"2022-02-04","Arrowroot",139,2.1799999999999997,303.02]
[null,"2022-02-04","Chocolate Chip",211,1.8699999999999999,394.57]

{"sheet":"FILTER","index":3,"n_rows":17,"n_cols":12,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Using UNIQUE Function"]
[]
[null,"Order Date","Product","Quantity","Unit Price","Total Price",null,{"$f":"_xlfn.UNIQUE(B4:F17)","v":"Order Date"},"Product","Quantity","Unit Price","Total Price"]
[null,"2022-02-02","Whole Wheat",30,3.49,{"$f":"PRODUCT(D5,E5)","v":104.7},null,"2022-02-02","Whole Wheat",30,3.49,104.7]
[null,"2022-02-02","Carrot",35,1.77,{"$f":"PRODUCT(D6,E6)","v":61.95},null,"2022-02-02","Carrot",35,1.77,61.95]
[null,"2022-02-02","Carrot",35,1.77,61.95,null,"2022-02-02","Potato Chips",25,1.68,42]
[null,"2022-02-02","Potato Chips",25,1.68,{"$f":"PRODUCT(D8,E8)","v":42},null,"2022-02-03","Chocolate Chip",24,1.87,44.88]
[null,"2022-02-03","Chocolate Chip",24,1.87,44.88,null,"2022-02-03","Bran",83,1.87,155.21]
[null,"2022-02-03","Bran",83,1.87,155.21,null,"2022-02-03","Carrot",137,1.77,242.49]
[null,"2022-02-03","Bran",83,1.87,155.21,null,"2022-02-04","Arrowroot",146,2.1799999999999997,318.27999999999997]
[null,"2022-02-03","Carrot",137,1.77,242.49,null,"2022-02-04","Chocolate Chip",34,1.8699999999999999,63.58]
[null,"2022-02-04","Arrowroot",146,2.1799999999999997,318.27999999999997,null,"2022-02-04","Arrowroot",139,2.1799999999999997,303.02]
[null,"2022-02-04","Chocolate Chip",34,1.8699999999999999,63.58,null,"2022-02-04","Chocolate Chip",211,1.8699999999999999,394.57]
[null,"2022-02-04","Chocolate Chip",34,1.8699999999999999,63.58]
[null,"2022-02-04","Arrowroot",139,2.1799999999999997,303.02]
[null,"2022-02-04","Chocolate Chip",211,1.8699999999999999,394.57]

{"sheet":"Remove Duplicates","index":4,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Using Remove Duplicates Feature"]
[]
[null,"Order Date","Product","Quantity","Unit Price","Total Price"]
[null,"2022-02-02","Whole Wheat",30,3.49,{"$f":"PRODUCT(D5,E5)","v":104.7}]
[null,"2022-02-02","Carrot",35,1.77,{"$f":"PRODUCT(D6,E6)","v":61.95}]
[null,"2022-02-02","Potato Chips",25,1.68,{"$f":"PRODUCT(D7,E7)","v":42}]
[null,"2022-02-03","Chocolate Chip",24,1.87,{"$f":"PRODUCT(D8,E8)","v":44.88}]
[null,"2022-02-03","Bran",83,1.87,{"$f":"PRODUCT(D9,E9)","v":155.21}]
[null,"2022-02-03","Carrot",137,1.77,{"$f":"PRODUCT(D10,E10)","v":242.49}]
[null,"2022-02-04","Arrowroot",146,2.1799999999999997,{"$f":"PRODUCT(D11,E11)","v":318.27999999999997}]
[null,"2022-02-04","Chocolate Chip",34,1.8699999999999999,{"$f":"PRODUCT(D12,E12)","v":63.58}]
[null,"2022-02-04","Arrowroot",139,2.1799999999999997,{"$f":"PRODUCT(D13,E13)","v":303.02}]
[null,"2022-02-04","Chocolate Chip",211,1.8699999999999999,{"$f":"PRODUCT(D14,E14)","v":394.57}]

{"sheet":"VBA","index":5,"n_rows":17,"n_cols":12,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Using VBA to Advanced Filter Unique"]
[]
[null,"Order Date","Product","Quantity","Unit Price","Total Price",null,"Order Date","Product","Quantity","Unit Price","Total Price"]
[null,"2022-02-02","Whole Wheat",30,3.49,{"$f":"PRODUCT(D5,E5)","v":104.7},null,"2022-02-02","Whole Wheat",30,3.49,104.7]
[null,"2022-02-02","Carrot",35,1.77,{"$f":"PRODUCT(D6,E6)","v":61.95},null,"2022-02-02","Carrot",35,1.77,61.95]
[null,"2022-02-02","Carrot",35,1.77,61.95,null,"2022-02-02","Potato Chips",25,1.68,42]
[null,"2022-02-02","Potato Chips",25,1.68,{"$f":"PRODUCT(D8,E8)","v":42},null,"2022-02-03","Chocolate Chip",24,1.87,44.88]
[null,"2022-02-03","Chocolate Chip",24,1.87,44.88,null,"2022-02-03","Bran",83,1.87,155.21]
[null,"2022-02-03","Bran",83,1.87,155.21,null,"2022-02-03","Carrot",137,1.77,242.49]
[null,"2022-02-03","Bran",83,1.87,155.21,null,"2022-02-04","Arrowroot",146,2.1799999999999997,318.27999999999997]
[null,"2022-02-03","Carrot",137,1.77,242.49,null,"2022-02-04","Chocolate Chip",34,1.8699999999999999,63.58]
[null,"2022-02-04","Arrowroot",146,2.1799999999999997,318.27999999999997,null,"2022-02-04","Arrowroot",139,2.1799999999999997,303.02]
[null,"2022-02-04","Chocolate Chip",34,1.8699999999999999,63.58,null,"2022-02-04","Chocolate Chip",211,1.8699999999999999,394.57]
[null,"2022-02-04","Chocolate Chip",34,1.8699999999999999,63.58]
[null,"2022-02-04","Arrowroot",139,2.1799999999999997,303.02]
[null,"2022-02-04","Chocolate Chip",211,1.8699999999999999,394.57]