{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Dataset","SUMPRODUCT COUNTIF","COUNTIF","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":5,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Dataset for Counting Duplicates Ignoring Blanks"]
[]
[null,"Order Date","Category","Product","Sold Quantity"]
[null,"2022-02-02","Crackers","Whole Wheat",30]
[null,"2022-02-03",null,"Carrot"]
[null,"2022-02-04","Bars","Bran",57]
[null,"2022-02-05",null,"Potato Chips",85]
[null,"2022-02-06","Cookies","Chocolate Chip",30]
[null,"2022-02-07","Bars","Bran",85]
[null,"2022-02-08","Cookies","Arrowroot",124]
[null,"2022-02-09","Bars"]
[null,"2022-02-10","Cookies","Chocolate Chip",146]
[null,"2022-02-11"]
[null,"2022-02-12",null,"Carrot",20]
[null,"2022-02-13","Cookies","Arrowroot",124]

{"sheet":"SUMPRODUCT COUNTIF","index":1,"n_rows":16,"n_cols":7,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Using SUMPRODUCT and COUNTIF Function"]
[]
[null,"Order Date","Category","Product","Sold Quantity",null,"Duplicates' Count"]
[null,"2022-02-02","Crackers","Whole Wheat",30,null,{"$f":"SUMPRODUCT(--(COUNTIF(B5:E16,B5:E16)>1))","v":21}]
[null,"2022-02-03",null,"Carrot"]
[null,"2022-02-04","Bars","Bran",57]
[null,"2022-02-05",null,"Potato Chips",85]
[null,"2022-02-06","Cookies","Chocolate Chip",30]
[null,"2022-02-07","Bars","Bran",85]
[null,"2022-02-08","Cookies","Arrowroot",124]
[null,"2022-02-09","Bars"]
[null,"2022-02-10","Cookies","Chocolate Chip",146]
[null,"2022-02-11"]
[null,"2022-02-12",null,"Carrot",20]
[null,"2022-02-13","Cookies","Arrowroot",124]

{"sheet":"COUNTIF","index":2,"n_rows":16,"n_cols":8,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Using COUNTIF Function"]
[]
[null,"Order Date","Category","Product","Sold Quantity","Status",null,"Duplicates' Count"]
[null,"2022-02-02","Crackers","Whole Wheat",30,{"$f":"COUNTIF(Product,D5)>1","v":false},null,{"$f":"COUNTIF(Status,TRUE)","v":8}]
[null,"2022-02-03",null,"Carrot",null,true]
[null,"2022-02-04","Bars","Bran",57,true]
[null,"2022-02-05",null,"Potato Chips",85,false]
[null,"2022-02-06","Cookies","Chocolate Chip",30,true]
[null,"2022-02-07","Bars","Bran",85,true]
[null,"2022-02-08","Cookies","Arrowroot",124,true]
[null,"2022-02-09","Bars",null,null,false]
[null,"2022-02-10","Cookies","Chocolate Chip",146,true]
[null,"2022-02-11",null,null,null,false]
[null,"2022-02-12",null,"Carrot",20,true]
[null,"2022-02-13","Cookies","Arrowroot",124,true]

{"sheet":"VBA","index":3,"n_rows":16,"n_cols":7,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Using VBA Macro"]
[]
[null,"Order Date","Category","Product","Sold Quantity",null,"Duplicates' Count"]
[null,"2022-02-02","Crackers","Whole Wheat",30,null,{"$f":"SUMPRODUCT(--(COUNTIF(B5:E16,B5:E16)>1))","v":21}]
[null,"2022-02-03",null,"Carrot"]
[null,"2022-02-04","Bars","Bran",57]
[null,"2022-02-05",null,"Potato Chips",85]
[null,"2022-02-06","Cookies","Chocolate Chip",30]
[null,"2022-02-07","Bars","Bran",85]
[null,"2022-02-08","Cookies","Arrowroot",124]
[null,"2022-02-09","Bars"]
[null,"2022-02-10","Cookies","Chocolate Chip",146]
[null,"2022-02-11"]
[null,"2022-02-12",null,"Carrot",20]
[null,"2022-02-13","Cookies","Arrowroot",124]