{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Dataset","Removed Duplicates","Conditional Formatting","Advanced Filter","MATCH and INDEX","VBA Macro","Pivot Table"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"comments":0,"pivot_tables":1},"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":19,"n_cols":4,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Ordered Product Dataset"]
[]
[null,"Order Date","Category","Product"]
[null,"2021-10-22","Crackers","Whole Wheat"]
[null,"2021-10-25","Bars","Carrot"]
[null,"2021-10-28","Bars","Bran"]
[null,"2021-10-31","Snacks","Potato Chip"]
[null,"2021-11-03","Cookies","Chocolate Chip"]
[null,"2021-11-06","Bars","Bran"]
[null,"2021-11-09","Cookies","Oatmeal Raisin"]
[null,"2021-11-12","Bars","Carrot"]
[null,"2021-11-15","Cookies","Arrowroot"]
[null,"2021-11-18","Cookies","Chocolate Chip"]
[null,"2021-11-21","Bars","Carrot"]
[null,"2021-11-24","Cookies","Arrowroot"]
[null,"2021-11-27","Cookies","Chocolate Chip"]
[null,"2021-11-30","Crackers","Whole Wheat"]
[null,"2021-12-03","Bars","Bran"]

{"sheet":"Removed Duplicates","index":1,"n_rows":19,"n_cols":4,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Filter Unique Using Removed Duplicates"]
[]
[null,"OrderDate","Category","Product"]
[null,"2021-10-22","Crackers","Whole Wheat"]
[null,"2021-10-25","Bars","Carrot"]
[null,"2021-10-28","Bars","Bran"]
[null,"2021-10-31","Snacks","Potato Chip"]
[null,"2021-11-03","Cookies","Chocolate Chip"]
[null,"2021-11-06","Cookies","Oatmeal Raisin"]
[null,"2021-11-09","Cookies","Arrowroot"]
[null,"2021-11-12"]
[null,"2021-11-15"]
[null,"2021-11-18"]
[null,"2021-11-21"]
[null,"2021-11-24"]
[null,"2021-11-27"]
[null,"2021-11-30"]
[null,"2021-12-03"]

{"sheet":"Conditional Formatting","index":2,"n_rows":19,"n_cols":5,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Filter Unique Using Conditional Formatting"]
[]
[null,"OrderDate","Category","Product 1","Product 2 (Hide)"]
[null,"2021-10-22","Crackers","Whole Wheat","Whole Wheat"]
[null,"2021-10-25","Bars","Carrot","Carrot"]
[null,"2021-10-28","Bars","Bran","Bran"]
[null,"2021-10-31","Snacks","Potato Chip","Potato Chip"]
[null,"2021-11-03","Cookies","Chocolate Chip","Chocolate Chip"]
[null,"2021-11-06","Bars","Bran","Bran"]
[null,"2021-11-09","Cookies","Oatmeal Raisin","Oatmeal Raisin"]
[null,"2021-11-12","Bars","Carrot","Carrot"]
[null,"2021-11-15","Cookies","Arrowroot","Arrowroot"]
[null,"2021-11-18","Cookies","Chocolate Chip","Chocolate Chip"]
[null,"2021-11-21","Bars","Carrot","Carrot"]
[null,"2021-11-24","Cookies","Arrowroot","Arrowroot"]
[null,"2021-11-27","Cookies","Chocolate Chip","Chocolate Chip"]
[null,"2021-11-30","Crackers","Whole Wheat","Whole Wheat"]
[null,"2021-12-03","Bars","Bran","Bran"]

{"sheet":"Advanced Filter","index":3,"n_rows":19,"n_cols":6,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Filter Unique Using Advanced Filter"]
[]
[null,"Order Date","Category","Product",null,"Product"]
[null,"2021-10-22","Crackers","Whole Wheat",null,"Whole Wheat"]
[null,"2021-10-25","Bars","Carrot",null,"Carrot"]
[null,"2021-10-28","Bars","Bran",null,"Bran"]
[null,"2021-10-31","Snacks","Potato Chip",null,"Potato Chip"]
[null,"2021-11-03","Cookies","Chocolate Chip",null,"Chocolate Chip"]
[null,"2021-11-06","Bars","Bran",null,"Oatmeal Raisin"]
[null,"2021-11-09","Cookies","Oatmeal Raisin",null,"Arrowroot"]
[null,"2021-11-12","Bars","Carrot"]
[null,"2021-11-15","Cookies","Arrowroot"]
[null,"2021-11-18","Cookies","Chocolate Chip"]
[null,"2021-11-21","Bars","Carrot"]
[null,"2021-11-24","Cookies","Arrowroot"]
[null,"2021-11-27","Cookies","Chocolate Chip"]
[null,"2021-11-30","Crackers","Whole Wheat"]
[null,"2021-12-03","Bars","Bran"]

{"sheet":"MATCH and INDEX","index":4,"n_rows":19,"n_cols":9,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,1,1,8]]}
[]
[null,"Filter Unique Using UNIQUE and FILTER Function"]
[]
[null,"OrderDate","Category","Product 1","Product 2 (Blank)","Product 3 (Case Sensitive)","Unique Product 1","Unique Product 2","Unique Product 3"]
[null,"2021-10-22","Crackers","Whole Wheat","Whole Wheat","Whole Wheat",{"$f":"IFERROR(INDEX($D$5:$D$19, MATCH(0, COUNTIF($G$4:G4, $D$5:$D$19), 0)),\"\")","v":"Whole Wheat"},{"$f":"IFERROR(INDEX($E$5:$E$19, MATCH(0,IF(ISBLANK($E$5:$E$19),1,COUNTIF($H$4:H4, $E$5:$E$19)), 0)),\"\")","v":"Whole Wheat"},{"$f":"INDEX($F$5:$F$19, MATCH(0, FREQUENCY(IF(EXACT($F$5:$F$19, TRANSPOSE($I$4:I4)), MATCH(ROW($F$5:$F$19), ROW($F$5:$F$19)), \"\"), MATCH(ROW($F$5:$F$19), ROW($F$5:$F$19))), 0))","v":"Whole Wheat"}]
[null,"2021-10-25","Bars","Carrot","Carrot","Carrot",{"$f":"IFERROR(INDEX($D$5:$D$19, MATCH(0, COUNTIF($G$4:G5, $D$5:$D$19), 0)),\"\")","v":"Carrot"},{"$f":"IFERROR(INDEX($E$5:$E$19, MATCH(0,IF(ISBLANK($E$5:$E$19),1,COUNTIF($H$4:H5, $E$5:$E$19)), 0)),\"\")","v":"Carrot"},{"$f":"INDEX($F$5:$F$19, MATCH(0, FREQUENCY(IF(EXACT($F$5:$F$19, TRANSPOSE($I$4:I5)), MATCH(ROW($F$5:$F$19), ROW($F$5:$F$19)), \"\"), MATCH(ROW($F$5:$F$19), ROW($F$5:$F$19))), 0))","v":"Carrot"}]
[null,"2021-10-28","Bars","Bran","Bran","Bran",{"$f":"IFERROR(INDEX($D$5:$D$19, MATCH(0, COUNTIF($G$4:G6, $D$5:$D$19), 0)),\"\")","v":"Bran"},{"$f":"IFERROR(INDEX($E$5:$E$19, MATCH(0,IF(ISBLANK($E$5:$E$19),1,COUNTIF($H$4:H6, $E$5:$E$19)), 0)),\"\")","v":"Bran"},{"$f":"INDEX($F$5:$F$19, MATCH(0, FREQUENCY(IF(EXACT($F$5:$F$19, TRANSPOSE($I$4:I6)), MATCH(ROW($F$5:$F$19), ROW($F$5:$F$19)), \"\"), MATCH(ROW($F$5:$F$19), ROW($F$5:$F$19))), 0))","v":"Bran"}]
[null,"2021-10-31","Snacks","Potato Chip","Potato Chip","Potato Chip",{"$f":"IFERROR(INDEX($D$5:$D$19, MATCH(0, COUNTIF($G$4:G7, $D$5:$D$19), 0)),\"\")","v":"Potato Chip"},{"$f":"IFERROR(INDEX($E$5:$E$19, MATCH(0,IF(ISBLANK($E$5:$E$19),1,COUNTIF($H$4:H7, $E$5:$E$19)), 0)),\"\")","v":"Potato Chip"},{"$f":"INDEX($F$5:$F$19, MATCH(0, FREQUENCY(IF(EXACT($F$5:$F$19, TRANSPOSE($I$4:I7)), MATCH(ROW($F$5:$F$19), ROW($F$5:$F$19)), \"\"), MATCH(ROW($F$5:$F$19), ROW($F$5:$F$19))), 0))","v":"Potato Chip"}]
[null,"2021-11-03","Cookies","Chocolate Chip",null,"Chocolate Chip",{"$f":"IFERROR(INDEX($D$5:$D$19, MATCH(0, COUNTIF($G$4:G8, $D$5:$D$19), 0)),\"\")","v":"Chocolate Chip"},{"$f":"IFERROR(INDEX($E$5:$E$19, MATCH(0,IF(ISBLANK($E$5:$E$19),1,COUNTIF($H$4:H8, $E$5:$E$19)), 0)),\"\")","v":"Oatmeal Raisin"},{"$f":"INDEX($F$5:$F$19, MATCH(0, FREQUENCY(IF(EXACT($F$5:$F$19, TRANSPOSE($I$4:I8)), MATCH(ROW($F$5:$F$19), ROW($F$5:$F$19)), \"\"), MATCH(ROW($F$5:$F$19), ROW($F$5:$F$19))), 0))","v":"Chocolate Chip"}]
[null,"2021-11-06","Bars","Bran","Bran","bran",{"$f":"IFERROR(INDEX($D$5:$D$19, MATCH(0, COUNTIF($G$4:G9, $D$5:$D$19), 0)),\"\")","v":"Oatmeal Raisin"},{"$f":"IFERROR(INDEX($E$5:$E$19, MATCH(0,IF(ISBLANK($E$5:$E$19),1,COUNTIF($H$4:H9, $E$5:$E$19)), 0)),\"\")","v":"Arrowroot"},{"$f":"INDEX($F$5:$F$19, MATCH(0, FREQUENCY(IF(EXACT($F$5:$F$19, TRANSPOSE($I$4:I9)), MATCH(ROW($F$5:$F$19), ROW($F$5:$F$19)), \"\"), MATCH(ROW($F$5:$F$19), ROW($F$5:$F$19))), 0))","v":"bran"}]
[null,"2021-11-09","Cookies","Oatmeal Raisin","Oatmeal Raisin","Oatmeal Raisin",{"$f":"IFERROR(INDEX($D$5:$D$19, MATCH(0, COUNTIF($G$4:G10, $D$5:$D$19), 0)),\"\")","v":"Arrowroot"},{"$f":"IFERROR(INDEX($E$5:$E$19, MATCH(0,IF(ISBLANK($E$5:$E$19),1,COUNTIF($H$4:H10, $E$5:$E$19)), 0)),\"\")","v":"Chocolate Chip"},{"$f":"INDEX($F$5:$F$19, MATCH(0, FREQUENCY(IF(EXACT($F$5:$F$19, TRANSPOSE($I$4:I10)), MATCH(ROW($F$5:$F$19), ROW($F$5:$F$19)), \"\"), MATCH(ROW($F$5:$F$19), ROW($F$5:$F$19))), 0))","v":"Oatmeal Raisin"}]
[null,"2021-11-12","Bars","Carrot","Carrot","carrot",null,null,{"$f":"INDEX($F$5:$F$19, MATCH(0, FREQUENCY(IF(EXACT($F$5:$F$19, TRANSPOSE($I$4:I11)), MATCH(ROW($F$5:$F$19), ROW($F$5:$F$19)), \"\"), MATCH(ROW($F$5:$F$19), ROW($F$5:$F$19))), 0))","v":"carrot"}]
[null,"2021-11-15","Cookies","Arrowroot","Arrowroot","Arrowroot",null,null,{"$f":"INDEX($F$5:$F$19, MATCH(0, FREQUENCY(IF(EXACT($F$5:$F$19, TRANSPOSE($I$4:I12)), MATCH(ROW($F$5:$F$19), ROW($F$5:$F$19)), \"\"), MATCH(ROW($F$5:$F$19), ROW($F$5:$F$19))), 0))","v":"Arrowroot"}]
[null,"2021-11-18","Cookies","Chocolate Chip","Chocolate Chip","Chocolate Chip",null,null,{"$f":"INDEX($F$5:$F$19, MATCH(0, FREQUENCY(IF(EXACT($F$5:$F$19, TRANSPOSE($I$4:I13)), MATCH(ROW($F$5:$F$19), ROW($F$5:$F$19)), \"\"), MATCH(ROW($F$5:$F$19), ROW($F$5:$F$19))), 0))","v":"arrowroot"}]
[null,"2021-11-21","Bars","Carrot",null,"Carrot",null,null,{"$f":"INDEX($F$5:$F$19, MATCH(0, FREQUENCY(IF(EXACT($F$5:$F$19, TRANSPOSE($I$4:I14)), MATCH(ROW($F$5:$F$19), ROW($F$5:$F$19)), \"\"), MATCH(ROW($F$5:$F$19), ROW($F$5:$F$19))), 0))","v":"chocolate Chip"}]
[null,"2021-11-24","Cookies","Arrowroot","Arrowroot","arrowroot"]
[null,"2021-11-27","Cookies","Chocolate Chip","Chocolate Chip","chocolate Chip"]
[null,"2021-11-30","Crackers","Whole Wheat",null,"Whole Wheat"]
[null,"2021-12-03","Bars","Bran","Bran","Bran"]

{"sheet":"VBA Macro","index":5,"n_rows":19,"n_cols":4,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Filter Unique Using VBA Macro"]
[]
[null,"OrderDate","Category","Product"]
[null,"2021-10-22","Crackers","Whole Wheat"]
[null,"2021-10-25","Bars","Carrot"]
[null,"2021-10-28","Bars","Bran"]
[null,"2021-10-31","Snacks","Potato Chip"]
[null,"2021-11-03","Cookies","Chocolate Chip"]
[null,"2021-11-06","Bars","Oatmeal Raisin"]
[null,"2021-11-09","Cookies","Arrowroot"]
[null,"2021-11-12","Bars"]
[null,"2021-11-15","Cookies"]
[null,"2021-11-18","Cookies"]
[null,"2021-11-21","Bars"]
[null,"2021-11-24","Cookies"]
[null,"2021-11-27","Cookies"]
[null,"2021-11-30","Crackers"]
[null,"2021-12-03","Bars"]

{"sheet":"Pivot Table","index":6,"n_rows":19,"n_cols":6,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Filter Unique Using Pivot Table"]
[]
[null,"OrderDate","Category","Product",null,"Unique Product"]
[null,"2021-10-22","Crackers","Whole Wheat",null,"Arrowroot"]
[null,"2021-10-25","Bars","Carrot",null,"Bran"]
[null,"2021-10-28","Bars","Bran",null,"Carrot"]
[null,"2021-10-31","Snacks","Potato Chip",null,"Chocolate Chip"]
[null,"2021-11-03","Cookies","Chocolate Chip",null,"Oatmeal Raisin"]
[null,"2021-11-06","Bars","Bran",null,"Potato Chip"]
[null,"2021-11-09","Cookies","Oatmeal Raisin",null,"Whole Wheat"]
[null,"2021-11-12","Bars","Carrot"]
[null,"2021-11-15","Cookies","Arrowroot"]
[null,"2021-11-18","Cookies","Chocolate Chip"]
[null,"2021-11-21","Bars","Carrot"]
[null,"2021-11-24","Cookies","Arrowroot"]
[null,"2021-11-27","Cookies","Chocolate Chip"]
[null,"2021-11-30","Crackers","Whole Wheat"]
[null,"2021-12-03","Bars","Bran"]