{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["dataset 1","Using AND + COUNTIF Functions","usinf COUNTIF function","Using VBA","Dataset 2","Using SUMPRODUCT AND COUNTIF"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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 1","index":0,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Highlight Duplicates in Two Columns"]
[]
[null,"First Batch","Second Batch"]
[null,"Alfred Moyes","Nathan Mills"]
[null,"Natalia Austin","Marcus North"]
[null,"Frank Orwell","Ricky Ben"]
[null,"David Simpson","Steve Smith"]
[null,"Marcus North","Natalia Austin"]
[null,"Richard Johnson","Frank Orwell"]
[null,"JenniferMorlo","Mathhew Heyden"]
[null,"John Criss","Steve Balmer"]

{"sheet":"Using AND + COUNTIF Functions","index":1,"n_rows":12,"n_cols":7,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Using AND, COUNTIF Functions"]
[]
[null,"First Batch","Second Batch"]
[null,"Alfred Moyes","Nathan Mills"]
[null,"Natalia Austin","Marcus North",null,null,null,{"$f":"AND(COUNTIF($B$5:$B$12, E6),COUNTIF($C$5:$C$12, E6))","v":false}]
[null,"Frank Orwell","Ricky Ben"]
[null,"David Simpson","Steve Smith"]
[null,"Marcus North","Natalia Austin"]
[null,"Richard Johnson","Frank Orwell"]
[null,"JenniferMorlo","Mathhew Heyden"]
[null,"John Criss","Steve Balmer"]

{"sheet":"usinf COUNTIF function","index":2,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Using COUNTIF Functions"]
[]
[null,"First Batch","Second Batch"]
[null,"Alfred Moyes","Nathan Mills"]
[null,"Natalia Austin","Marcus North"]
[null,"Frank Orwell","Ricky Ben"]
[null,"David Simpson","Steve Smith"]
[null,"Marcus North","Natalia Austin"]
[null,"Richard Johnson","Frank Orwell"]
[null,"JenniferMorlo","Mathhew Heyden"]
[null,"John Criss","Steve Balmer"]

{"sheet":"Using VBA","index":3,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Using VBA"]
[]
[null,"First Batch","Second Batch"]
[null,"Alfred Moyes","Nathan Mills"]
[null,"Natalia Austin","Marcus North"]
[null,"Frank Orwell","Ricky Ben"]
[null,"David Simpson","Steve Smith"]
[null,"Marcus North","Natalia Austin"]
[null,"Richard Johnson","Frank Orwell"]
[null,"JenniferMorlo","Mathhew Heyden"]
[null,"John Criss","Steve Balmer"]

{"sheet":"Dataset 2","index":4,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Highlight Duplicates in Two Columns"]
[]
[null,"Date","Amount"]
[null,"20/01/2017",20]
[null,"20/01/2017",20]
[null,"20/01/2017",30]
[null,"22/01/2017",15]
[null,"23/01/2017",15]
[null,"24/01/2017",40]
[null,"24/01/2017",50]
[null,"24/01/2017",50]

{"sheet":"Using SUMPRODUCT AND COUNTIF","index":5,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Using SUMPRODUCT and COUNTIF Functions"]
[]
[null,"Date","Amount"]
[null,"20/01/2017",20]
[null,"20/01/2017",20]
[null,"20/01/2017",30]
[null,"22/01/2017",15]
[null,"23/01/2017",15]
[null,"24/01/2017",40]
[null,"24/01/2017",50]
[null,"24/01/2017",50]