{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Sample Dataset","Using Remove Duplicates Tool","Using Advanced Filter","Using UNIQUE Function","Using Power Query","Table1","Using VBA Code","Identifying Duplicates"],"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":"Sample Dataset","index":0,"n_rows":15,"n_cols":5,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Examination Record of Sunflower Kindergarten"]
[]
[null,"Student Name","Student ID","Marks","Grade"]
[null,"Frank Orwell",101,99,"A+"]
[null,"David Moyes",111,78,"A"]
[null,"Natalia Austin",121,31,"F"]
[null,"David Moyes",111,78,"A"]
[null,"Angela Hopkins",131,52,"B"]
[null,"Frank Orwell",141,91,"A+"]
[null,"Richard Kettlebrough",151,40,"C"]
[null,"Brad Milford",161,49,"C"]
[null,"Angela Hopkins",131,52,"B"]
[null,"Jennifer Marlo",171,80,"A+"]
[null,"Shane Thompson",181,94,"A+"]

{"sheet":"Using Remove Duplicates Tool","index":1,"n_rows":15,"n_cols":12,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,8,1,11]]}
[]
[null,"Using Remove Duplicates Tool",null,null,null,null,null,null,">>> Do Yourself >>>"]
[]
[null,"Student Name","Student ID","Marks","Grade",null,null,null,"Student Name","Student ID","Marks","Grade"]
[null,"Frank Orwell",101,99,"A+",null,null,null,"Frank Orwell",101,99,"A+"]
[null,"David Moyes",111,78,"A",null,null,null,"David Moyes",111,78,"A"]
[null,"Natalia Austin",121,31,"F",null,null,null,"Natalia Austin",121,31,"F"]
[null,"Angela Hopkins",131,52,"B",null,null,null,"David Moyes",111,78,"A"]
[null,"Frank Orwell",141,91,"A+",null,null,null,"Angela Hopkins",131,52,"B"]
[null,"Richard Kettlebrough",151,40,"C",null,null,null,"Frank Orwell",141,91,"A+"]
[null,"Brad Milford",161,49,"C",null,null,null,"Richard Kettlebrough",151,40,"C"]
[null,"Jennifer Marlo",171,80,"A+",null,null,null,"Brad Milford",161,49,"C"]
[null,"Shane Thompson",181,94,"A+",null,null,null,"Angela Hopkins",131,52,"B"]
[null,null,null,null,null,null,null,null,"Jennifer Marlo",171,80,"A+"]
[null,null,null,null,null,null,null,null,"Shane Thompson",181,94,"A+"]

{"sheet":"Using Advanced Filter","index":2,"n_rows":29,"n_cols":13,"rows_kept":29,"cut":false,"hidden":false,"merged":[[1,1,1,4],[15,9,15,12]]}
[]
[null,"Using Advanced Filter"]
[]
[null,"Student Name","Student ID","Marks","Grade"]
[null,"Frank Orwell",101,99,"A+"]
[null,"David Moyes",111,78,"A"]
[null,"Natalia Austin",121,31,"F"]
[null,"David Moyes",111,78,"A"]
[null,"Angela Hopkins",131,52,"B"]
[null,"Frank Orwell",141,91,"A+"]
[null,"Richard Kettlebrough",151,40,"C"]
[null,"Brad Milford",161,49,"C"]
[null,"Angela Hopkins",131,52,"B"]
[null,"Jennifer Marlo",171,80,"A+"]
[null,"Shane Thompson",181,94,"A+"]
[null,null,null,null,null,null,null,null,null,">>> Do Yourself >>>"]
[]
[null,null,null,null,null,null,null,null,null,"Student Name","Student ID","Marks","Grade"]
[null,null,null,null,null,null,null,null,null,"Frank Orwell",101,99,"A+"]
[null,null,null,null,null,null,null,null,null,"David Moyes",111,78,"A"]
[null,null,null,null,null,null,null,null,null,"Natalia Austin",121,31,"F"]
[null,null,null,null,null,null,null,null,null,"David Moyes",111,78,"A"]
[null,null,null,null,null,null,null,null,null,"Angela Hopkins",131,52,"B"]
[null,null,null,null,null,null,null,null,null,"Frank Orwell",141,91,"A+"]
[null,null,null,null,null,null,null,null,null,"Richard Kettlebrough",151,40,"C"]
[null,null,null,null,null,null,null,null,null,"Brad Milford",161,49,"C"]
[null,null,null,null,null,null,null,null,null,"Angela Hopkins",131,52,"B"]
[null,null,null,null,null,null,null,null,null,"Jennifer Marlo",171,80,"A+"]
[null,null,null,null,null,null,null,null,null,"Shane Thompson",181,94,"A+"]

{"sheet":"Using UNIQUE Function","index":3,"n_rows":15,"n_cols":13,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,9,1,12]]}
[]
[null,"Using the UNIQUE Function",null,null,null,null,null,null,null,">>> Do Yourself >>>"]
[]
[null,"Student Name","Student ID","Marks","Grade",null,null,null,null,"Student Name","Student ID","Marks","Grade"]
[null,{"$f":"_xlfn.UNIQUE('Sample Dataset'!B5:E15,FALSE,FALSE)","v":"Frank Orwell"},101,99,"A+",null,null,null,null,"Frank Orwell",101,99,"A+"]
[null,"David Moyes",111,78,"A",null,null,null,null,"David Moyes",111,78,"A"]
[null,"Natalia Austin",121,31,"F",null,null,null,null,"Natalia Austin",121,31,"F"]
[null,"Angela Hopkins",131,52,"B",null,null,null,null,"David Moyes",111,78,"A"]
[null,"Frank Orwell",141,91,"A+",null,null,null,null,"Angela Hopkins",131,52,"B"]
[null,"Richard Kettlebrough",151,40,"C",null,null,null,null,"Frank Orwell",141,91,"A+"]
[null,"Brad Milford",161,49,"C",null,null,null,null,"Richard Kettlebrough",151,40,"C"]
[null,"Jennifer Marlo",171,80,"A+",null,null,null,null,"Brad Milford",161,49,"C"]
[null,"Shane Thompson",181,94,"A+",null,null,null,null,"Angela Hopkins",131,52,"B"]
[null,null,null,null,null,null,null,null,null,"Jennifer Marlo",171,80,"A+"]
[null,null,null,null,null,null,null,null,null,"Shane Thompson",181,94,"A+"]

{"sheet":"Using Power Query","index":4,"n_rows":15,"n_cols":13,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,9,1,12]]}
[]
[null,"Using Power Query",null,null,null,null,null,null,null,">>> Do Yourself >>>"]
[]
[null,"Student Name","Student ID","Marks","Grade",null,null,null,null,"Student Name","Student ID","Marks","Grade"]
[null,"Frank Orwell",101,99,"A+",null,null,null,null,"Frank Orwell",101,99,"A+"]
[null,"David Moyes",111,78,"A",null,null,null,null,"David Moyes",111,78,"A"]
[null,"Natalia Austin",121,31,"F",null,null,null,null,"Natalia Austin",121,31,"F"]
[null,"David Moyes",111,78,"A",null,null,null,null,"David Moyes",111,78,"A"]
[null,"Angela Hopkins",131,52,"B",null,null,null,null,"Angela Hopkins",131,52,"B"]
[null,"Frank Orwell",141,91,"A+",null,null,null,null,"Frank Orwell",141,91,"A+"]
[null,"Richard Kettlebrough",151,40,"C",null,null,null,null,"Richard Kettlebrough",151,40,"C"]
[null,"Brad Milford",161,49,"C",null,null,null,null,"Brad Milford",161,49,"C"]
[null,"Angela Hopkins",131,52,"B",null,null,null,null,"Angela Hopkins",131,52,"B"]
[null,"Jennifer Marlo",171,80,"A+",null,null,null,null,"Jennifer Marlo",171,80,"A+"]
[null,"Shane Thompson",181,94,"A+",null,null,null,null,"Shane Thompson",181,94,"A+"]

{"sheet":"Table1","index":5,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Student Name","Student ID","Marks","Grade"]
["Frank Orwell",101,99,"A+"]
["David Moyes",111,78,"A"]
["Natalia Austin",121,31,"F"]
["Angela Hopkins",131,52,"B"]
["Frank Orwell",141,91,"A+"]
["Richard Kettlebrough",151,40,"C"]
["Brad Milford",161,49,"C"]
["Jennifer Marlo",171,80,"A+"]
["Shane Thompson",181,94,"A+"]

{"sheet":"Using VBA Code","index":6,"n_rows":15,"n_cols":13,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,9,1,12]]}
[]
[null,"Using VBA Code",null,null,null,null,null,null,null,">>> Do Yourself >>>"]
[]
[null,"Student Name","Student ID","Marks","Grade",null,null,null,null,"Student Name","Student ID","Marks","Grade"]
[null,"Frank Orwell",101,99,"A+",null,null,null,null,"Frank Orwell",101,99,"A+"]
[null,"David Moyes",111,78,"A",null,null,null,null,"David Moyes",111,78,"A"]
[null,"Natalia Austin",121,31,"F",null,null,null,null,"Natalia Austin",121,31,"F"]
[null,"Angela Hopkins",131,52,"B",null,null,null,null,"David Moyes",111,78,"A"]
[null,"Frank Orwell",141,91,"A+",null,null,null,null,"Angela Hopkins",131,52,"B"]
[null,"Richard Kettlebrough",151,40,"C",null,null,null,null,"Frank Orwell",141,91,"A+"]
[null,"Brad Milford",161,49,"C",null,null,null,null,"Richard Kettlebrough",151,40,"C"]
[null,"Jennifer Marlo",171,80,"A+",null,null,null,null,"Brad Milford",161,49,"C"]
[null,"Shane Thompson",181,94,"A+",null,null,null,null,"Angela Hopkins",131,52,"B"]
[null,null,null,null,null,null,null,null,null,"Jennifer Marlo",171,80,"A+"]
[null,null,null,null,null,null,null,null,null,"Shane Thompson",181,94,"A+"]

{"sheet":"Identifying Duplicates","index":7,"n_rows":15,"n_cols":13,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,9,1,12]]}
[]
[null,"Identifying Duplicates without Deleting",null,null,null,null,null,null,null,">>> Do Yourself >>>"]
[]
[null,"Student Name","Student ID","Marks","Grade",null,null,null,null,"Student Name","Student ID","Marks","Grade"]
[null,"Frank Orwell",101,99,"A+",null,null,null,null,"Frank Orwell",101,99,"A+"]
[null,"David Moyes",111,78,"A",null,null,null,null,"David Moyes",111,78,"A"]
[null,"Natalia Austin",121,31,"F",null,null,null,null,"Natalia Austin",121,31,"F"]
[null,"David Moyes",111,78,"A",null,null,null,null,"David Moyes",111,78,"A"]
[null,"Angela Hopkins",131,52,"B",null,null,null,null,"Angela Hopkins",131,52,"B"]
[null,"Frank Orwell",141,91,"A+",null,null,null,null,"Frank Orwell",141,91,"A+"]
[null,"Richard Kettlebrough",151,40,"C",null,null,null,null,"Richard Kettlebrough",151,40,"C"]
[null,"Brad Milford",161,49,"C",null,null,null,null,"Brad Milford",161,49,"C"]
[null,"Angela Hopkins",131,52,"B",null,null,null,null,"Angela Hopkins",131,52,"B"]
[null,"Jennifer Marlo",171,80,"A+",null,null,null,null,"Jennifer Marlo",171,80,"A+"]
[null,"Shane Thompson",181,94,"A+",null,null,null,null,"Shane Thompson",181,94,"A+"]