{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Dataset","Helper Column","Formula","Conditional Formatting","Conditional Formatting New Rule","VBA Macro"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":4,"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":17,"n_cols":4,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Dataset for Removing Both Duplicates"]
[]
[null,"Product","Quantity","Unit Price"]
[null,"Bran",83,1.87]
[null,"Oatmeal Raisin",124,2.8400000000000003]
[null,"Ice Cream",137,1.77]
[null,"Carrot",20,1.77]
[null,"Arrowroot",139,2.1799999999999997]
[null,"Potato Chip",211,1.8699999999999999]
[null,"Whole Wheat",20,3.4899999999999998]
[null,"Bran",83,1.87]
[null,"Rice",100,2.84]
[null,"Ice Cream",137,1.7700000000000002]
[null,"Whole Wheat",20,3.49]
[null,"Juice",96,1.87]
[null,"Biscuit",34,2.1800000000000002]

{"sheet":"Helper Column","index":1,"n_rows":17,"n_cols":5,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Using a Helper Column"]
[]
[null,"Product","Quantity","Unit Price","Helper Column"]
[null,"Bran",83,1.87,{"$f":"COUNTIF($B$5:$B$17,B5)=1","v":false}]
[null,"Oatmeal Raisin",124,2.8400000000000003,{"$f":"COUNTIF($B$5:$B$17,B6)=1","v":true}]
[null,"Ice Cream",137,1.77,false]
[null,"Carrot",20,1.77,true]
[null,"Arrowroot",139,2.1799999999999997,true]
[null,"Potato Chip",211,1.8699999999999999,true]
[null,"Whole Wheat",20,3.4899999999999998,false]
[null,"Bran",83,1.87,false]
[null,"Rice",100,2.84,true]
[null,"Ice Cream",137,1.7700000000000002,false]
[null,"Whole Wheat",20,3.49,false]
[null,"Juice",96,1.87,true]
[null,"Biscuit",34,2.1800000000000002,true]

{"sheet":"Formula","index":2,"n_rows":17,"n_cols":5,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Using Formula"]
[]
[null,"Product","Quantity","Unit Price","Formula Result"]
[null,"Bran",83,1.87,{"$f":"IF(COUNTIF($B$5:$B$17,B5)=1,1,0)","v":0}]
[null,"Oatmeal Raisin",124,2.8400000000000003,{"$f":"IF(COUNTIF($B$5:$B$17,B6)=1,1,0)","v":1}]
[null,"Ice Cream",137,1.77,0]
[null,"Carrot",20,1.77,1]
[null,"Arrowroot",139,2.1799999999999997,1]
[null,"Potato Chip",211,1.8699999999999999,1]
[null,"Whole Wheat",20,3.4899999999999998,0]
[null,"Bran",83,1.87,0]
[null,"Rice",100,2.84,1]
[null,"Ice Cream",137,1.7700000000000002,0]
[null,"Whole Wheat",20,3.49,0]
[null,"Juice",96,1.87,1]
[null,"Biscuit",34,2.1800000000000002,1]

{"sheet":"Conditional Formatting","index":3,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using Conditional Formatting"]
[]
[null,"Product","Quantity","Unit Price"]
[null,"Oatmeal Raisin",124,2.8400000000000003]
[null,"Carrot",20,1.77]
[null,"Arrowroot",139,2.1799999999999997]
[null,"Potato Chip",211,1.8699999999999999]
[null,"Rice",100,2.84]
[null,"Juice",96,1.87]
[null,"Biscuit",34,2.1800000000000002]

{"sheet":"Conditional Formatting New Rule","index":4,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Using Conditional Formatting (New Rule)"]
[]
[null,null,"Product","Quantity","Unit Price"]
[null,null,"Oatmeal Raisin",124,2.8400000000000003]
[null,null,"Carrot",20,1.77]
[null,null,"Arrowroot",139,2.1799999999999997]
[null,null,"Potato Chip",211,1.8699999999999999]
[null,null,"Rice",100,2.84]
[null,null,"Juice",96,1.87]
[null,null,"Biscuit",34,2.1800000000000002]

{"sheet":"VBA Macro","index":5,"n_rows":17,"n_cols":3,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Using VBA Macro Code"]
[]
[null,"Product","Quantity"]
[]
[null,"Oatmeal Raisin",124]
[]
[null,"Carrot",25]
[null,"Arrowroot",139]
[null,"Potato Chip",211]
[]
[]
[null,"Rice",100]
[]
[]
[null,"Juice",96]
[null,"Biscuit",34]