{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Data Set","For Loop","User Input","Selection","VBA CountIfs","Highlight Duplicates from Row","Highlight Duplicates from Col","Highlight Duplicate of Select","Count Duplicates"],"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":"Data Set","index":0,"n_rows":11,"n_cols":8,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,"Find Duplicate Values in Range"]
[]
[null,"Month","Jan","Feb","Mar","Apr","May","Jun"]
[null,"Day 1",510,564,341,510,504,661]
[null,"Day 2",800,671,159,727,293,953]
[null,"Day 3",300,389,168,660,277,708]
[null,"Day 4",250,518,638,596,564,789]
[null,"Day 5",180,564,588,168,713,357]
[null,"Day 6",220,186,457,697,220,341]
[null,"Day 7",550,341,551,789,507,164]

{"sheet":"For Loop","index":1,"n_rows":11,"n_cols":9,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,"Find Duplicate Values with For Loop"]
[]
[null,"Month","Jan","Feb","Mar","Apr","May","Jun","Status"]
[null,"Day 1",510,564,341,510,504,661,true]
[null,"Day 2",800,671,159,727,293,953,false]
[null,"Day 3",300,389,168,660,277,708,false]
[null,"Day 4",250,518,638,596,564,789,false]
[null,"Day 5",180,564,588,168,713,357,false]
[null,"Day 6",220,186,457,697,220,341,false]
[null,"Day 7",510,341,551,789,507,164,true]

{"sheet":"User Input","index":2,"n_rows":11,"n_cols":8,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,"Test If Range Contains Duplicate"]
[]
[null,"Month","Jan","Feb","Mar","Apr","May","Jun"]
[null,"Day 1",510,564,341,510,504,661]
[null,"Day 2",800,671,159,727,293,953]
[null,"Day 3",300,389,168,660,277,708]
[null,"Day 4",250,518,638,596,564,789]
[null,"Day 5",180,564,588,168,713,357]
[null,"Day 6",220,186,457,697,220,341]
[null,"Day 7",550,341,551,789,507,164]

{"sheet":"Selection","index":3,"n_rows":11,"n_cols":8,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,"Use Selection Method to Test Duplicates"]
[]
[null,"Month","Jan","Feb","Mar","Apr","May","Jun"]
[null,"Day 1",510,564,341,510,504,661]
[null,"Day 2",800,671,159,727,293,953]
[null,"Day 3",300,389,168,660,277,708]
[null,"Day 4",250,518,638,596,564,789]
[null,"Day 5",180,564,588,168,713,357]
[null,"Day 6",220,186,457,697,220,341]
[null,"Day 7",550,341,551,789,507,164]

{"sheet":"VBA CountIfs","index":4,"n_rows":11,"n_cols":8,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,"VBA CountIfs Function to Test Duplicates"]
[]
[null,"Month","Jan","Feb","Mar","Apr","May","Jun"]
[null,"Day 1",510,564,341,510,504,661]
[null,"Day 2",800,671,159,727,293,953]
[null,"Day 3",300,389,168,660,277,708]
[null,"Day 4",250,518,638,596,564,789]
[null,"Day 5",180,564,588,168,713,357]
[null,"Day 6",510,186,457,697,220,341]
[null,"Day 7",550,341,551,789,507,164]

{"sheet":"Highlight Duplicates from Row","index":5,"n_rows":11,"n_cols":8,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,"Find Duplicate Values from a Row"]
[]
[null,"Month","Jan","Feb","Mar","Apr","May","Jun"]
[null,"Day 1",510,564,341,510,504,661]
[null,"Day 2",800,671,159,727,800,953]
[null,"Day 3",300,389,168,660,277,708]
[null,"Day 4",250,518,638,596,250,789]
[null,"Day 5",180,564,588,168,180,180]
[null,"Day 6",510,186,457,697,510,341]
[null,"Day 7",550,341,550,789,507,164]

{"sheet":"Highlight Duplicates from Col","index":6,"n_rows":11,"n_cols":8,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,"Find Duplicate Values from a Column"]
[]
[null,"Month","Jan","Feb","Mar","Apr","May","Jun"]
[null,"Day 1",510,564,341,510,504,614]
[null,"Day 2",620,671,159,727,800,953]
[null,"Day 3",510,564,168,660,277,708]
[null,"Day 4",250,518,638,596,250,789]
[null,"Day 5",180,564,588,168,180,180]
[null,"Day 6",510,186,457,510,510,341]
[null,"Day 7",640,341,550,789,507,614]

{"sheet":"Highlight Duplicate of Select","index":7,"n_rows":11,"n_cols":8,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,"Find Duplicate Values from Selection"]
[]
[null,"Month","Jan","Feb","Mar","Apr","May","Jun"]
[null,"Day 1",510,564,341,510,504,614]
[null,"Day 2",620,671,159,727,800,953]
[null,"Day 3",510,564,168,660,277,708]
[null,"Day 4",250,518,638,596,250,789]
[null,"Day 5",180,564,588,168,180,180]
[null,"Day 6",510,186,457,510,510,341]
[null,"Day 7",640,341,550,789,507,614]

{"sheet":"Count Duplicates","index":8,"n_rows":11,"n_cols":8,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,"Count Number of Duplicates"]
[]
[null,"Month","Jan","Feb","Mar","Apr","May","Jun"]
[null,"Day 1",510,564,341,510,504,661]
[null,"Day 2",800,671,159,727,293,953]
[null,"Day 3",300,389,168,660,277,708]
[null,"Day 4",250,518,638,596,564,789]
[null,"Day 5",180,564,588,168,713,357]
[null,"Day 6",510,186,457,697,220,341]
[null,"Day 7",550,341,551,789,507,164]