{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Sample Dataset","Remove Duplicates","Advanced Filter","IF & COUNTERIFS Functions","VBA Code","Conditional Formatting","Power Query","Power Query Result"],"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":"Sample Dataset","index":0,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[[2,1,2,4]]}
[]
[]
[null,"Finding Duplicates in Column and Deleting Row"]
[]
[null,"Movie","Year","Director","Rating"]
[null,"The Shawshank Redemption",1994,"Frank Darabont",9.3000000000000007]
[null,"The Godfather",1972,"Francis Ford Coppola",9.1999999999999993]
[null,"The Dark Knight",2008,"Christopher Nolan",9]
[null,"The Shawshank Redemption",1994,"Frank Darabont",9.3000000000000007]
[null,"The Godfather Part II",1974,"Francis Ford Coppola",9]
[null,"Schindler's List",1993,"Steven Spielberg",9]
[null,"12 Angry Men",1957,"Sidney Lumet",9]
[null,"Schindler's List",1993,"Steven Spielberg",9]

{"sheet":"Remove Duplicates","index":1,"n_rows":13,"n_cols":10,"rows_kept":13,"cut":false,"hidden":false,"merged":[[2,1,2,4],[2,6,2,9]]}
[]
[]
[null,"Finding Duplicates in Column and Deleting Row",null,null,null,null,"Practice"]
[]
[null,"Movie","Year","Director","Rating",null,"Movie","Year","Director","Rating"]
[null,"The Shawshank Redemption",1994,"Frank Darabont",9.3000000000000007,null,"The Shawshank Redemption",1994,"Frank Darabont",9.3000000000000007]
[null,"The Godfather",1972,"Francis Ford Coppola",9.1999999999999993,null,"The Godfather",1972,"Francis Ford Coppola",9.1999999999999993]
[null,"The Dark Knight",2008,"Christopher Nolan",9,null,"The Dark Knight",2008,"Christopher Nolan",9]
[null,"The Godfather Part II",1974,"Francis Ford Coppola",9,null,"The Shawshank Redemption",1994,"Frank Darabont",9.3000000000000007]
[null,"Schindler's List",1993,"Steven Spielberg",9,null,"The Godfather Part II",1974,"Francis Ford Coppola",9]
[null,"12 Angry Men",1957,"Sidney Lumet",9,null,"Schindler's List",1993,"Steven Spielberg",9]
[null,null,null,null,null,null,"12 Angry Men",1957,"Sidney Lumet",9]
[null,null,null,null,null,null,"Schindler's List",1993,"Steven Spielberg",9]

{"sheet":"Advanced Filter","index":2,"n_rows":13,"n_cols":15,"rows_kept":13,"cut":false,"hidden":false,"merged":[[2,1,2,9],[2,11,2,14]]}
[]
[]
[null,"Finding Duplicates in Column and Deleting Row",null,null,null,null,null,null,null,null,null,"Practice"]
[]
[null,"Movie","Year","Director","Rating",null,"Movie","Year","Director","Rating",null,"Movie","Year","Director","Rating"]
[null,"The Shawshank Redemption",1994,"Frank Darabont",9.3000000000000007,null,"The Shawshank Redemption",1994,"Frank Darabont",9.3000000000000007,null,"The Shawshank Redemption",1994,"Frank Darabont",9.3000000000000007]
[null,"The Godfather",1972,"Francis Ford Coppola",9.1999999999999993,null,"The Godfather",1972,"Francis Ford Coppola",9.1999999999999993,null,"The Godfather",1972,"Francis Ford Coppola",9.1999999999999993]
[null,"The Dark Knight",2008,"Christopher Nolan",9,null,"The Dark Knight",2008,"Christopher Nolan",9,null,"The Dark Knight",2008,"Christopher Nolan",9]
[null,"The Shawshank Redemption",1994,"Frank Darabont",9.3000000000000007,null,"The Godfather Part II",1974,"Francis Ford Coppola",9,null,"The Shawshank Redemption",1994,"Frank Darabont",9.3000000000000007]
[null,"The Godfather Part II",1974,"Francis Ford Coppola",9,null,"Schindler's List",1993,"Steven Spielberg",9,null,"The Godfather Part II",1974,"Francis Ford Coppola",9]
[null,"Schindler's List",1993,"Steven Spielberg",9,null,"12 Angry Men",1957,"Sidney Lumet",9,null,"Schindler's List",1993,"Steven Spielberg",9]
[null,"12 Angry Men",1957,"Sidney Lumet",9,null,null,null,null,null,null,"12 Angry Men",1957,"Sidney Lumet",9]
[null,"Schindler's List",1993,"Steven Spielberg",9,null,null,null,null,null,null,"Schindler's List",1993,"Steven Spielberg",9]

{"sheet":"IF & COUNTERIFS Functions","index":3,"n_rows":13,"n_cols":11,"rows_kept":13,"cut":false,"hidden":false,"merged":[[2,1,2,5],[2,7,2,10]]}
[]
[]
[null,"Finding Duplicates in Column and Deleting Row",null,null,null,null,null,"Practice"]
[]
[null,"Movie","Year","Director","Rating","Unique",null,"Movie","Year","Director","Rating"]
[null,"The Shawshank Redemption",1994,"Frank Darabont",9.3000000000000007,{"$f":"IF(COUNTIFS($B$6:$B6,$B6,$C$6:$C6, $C6,$D$6:$D6,$D6,$E$6:$E6, $E6)=1, \"Yes\", \"No\")","v":"Yes"},null,"The Shawshank Redemption",1994,"Frank Darabont",9.3000000000000007]
[null,"The Godfather",1972,"Francis Ford Coppola",9.1999999999999993,{"$f":"IF(COUNTIFS($B$6:$B7,$B7,$C$6:$C7, $C7,$D$6:$D7,$D7,$E$6:$E7, $E7)=1, \"Yes\", \"No\")","v":"Yes"},null,"The Godfather",1972,"Francis Ford Coppola",9.1999999999999993]
[null,"The Dark Knight",2008,"Christopher Nolan",9,{"$f":"IF(COUNTIFS($B$6:$B8,$B8,$C$6:$C8, $C8,$D$6:$D8,$D8,$E$6:$E8, $E8)=1, \"Yes\", \"No\")","v":"Yes"},null,"The Dark Knight",2008,"Christopher Nolan",9]
[null,"The Godfather Part II",1974,"Francis Ford Coppola",9,{"$f":"IF(COUNTIFS($B$6:$B9,$B9,$C$6:$C9, $C9,$D$6:$D9,$D9,$E$6:$E9, $E9)=1, \"Yes\", \"No\")","v":"Yes"},null,"The Shawshank Redemption",1994,"Frank Darabont",9.3000000000000007]
[null,"Schindler's List",1993,"Steven Spielberg",9,{"$f":"IF(COUNTIFS($B$6:$B10,$B10,$C$6:$C10, $C10,$D$6:$D10,$D10,$E$6:$E10, $E10)=1, \"Yes\", \"No\")","v":"Yes"},null,"The Godfather Part II",1974,"Francis Ford Coppola",9]
[null,"12 Angry Men",1957,"Sidney Lumet",9,{"$f":"IF(COUNTIFS($B$6:$B11,$B11,$C$6:$C11, $C11,$D$6:$D11,$D11,$E$6:$E11, $E11)=1, \"Yes\", \"No\")","v":"Yes"},null,"Schindler's List",1993,"Steven Spielberg",9]
[null,null,null,null,null,null,null,"12 Angry Men",1957,"Sidney Lumet",9]
[null,null,null,null,null,null,null,"Schindler's List",1993,"Steven Spielberg",9]

{"sheet":"VBA Code","index":4,"n_rows":13,"n_cols":10,"rows_kept":13,"cut":false,"hidden":false,"merged":[[2,1,2,4],[2,6,2,9]]}
[]
[]
[null,"Finding Duplicates in Column and Deleting Row",null,null,null,null,"Practice"]
[]
[null,"Movie","Year","Director","Rating",null,"Movie","Year","Director","Rating"]
[null,"The Shawshank Redemption",1994,"Frank Darabont",9.3000000000000007,null,"The Shawshank Redemption",1994,"Frank Darabont",9.3000000000000007]
[null,"The Godfather",1972,"Francis Ford Coppola",9.1999999999999993,null,"The Godfather",1972,"Francis Ford Coppola",9.1999999999999993]
[null,"The Dark Knight",2008,"Christopher Nolan",9,null,"The Dark Knight",2008,"Christopher Nolan",9]
[null,"The Godfather Part II",1974,"Francis Ford Coppola",9,null,"The Shawshank Redemption",1994,"Frank Darabont",9.3000000000000007]
[null,"Schindler's List",1993,"Steven Spielberg",9,null,"The Godfather Part II",1974,"Francis Ford Coppola",9]
[null,"12 Angry Men",1957,"Sidney Lumet",9,null,"Schindler's List",1993,"Steven Spielberg",9]
[null,null,null,null,null,null,"12 Angry Men",1957,"Sidney Lumet",9]
[null,null,null,null,null,null,"Schindler's List",1993,"Steven Spielberg",9]

{"sheet":"Conditional Formatting","index":5,"n_rows":13,"n_cols":10,"rows_kept":13,"cut":false,"hidden":false,"merged":[[2,1,2,4],[2,6,2,9]]}
[]
[]
[null,"Finding Duplicates in Column and Deleting Row",null,null,null,null,"Practice"]
[]
[null,"Movie","Year","Director","Rating",null,"Movie","Year","Director","Rating"]
[null,"The Shawshank Redemption",1994,"Frank Darabont",9.3000000000000007,null,"The Shawshank Redemption",1994,"Frank Darabont",9.3000000000000007]
[null,"The Godfather",1972,"Francis Ford Coppola",9.1999999999999993,null,"The Godfather",1972,"Francis Ford Coppola",9.1999999999999993]
[null,"The Dark Knight",2008,"Christopher Nolan",9,null,"The Dark Knight",2008,"Christopher Nolan",9]
[null,"The Godfather Part II",1974,"Francis Ford Coppola",9,null,"The Shawshank Redemption",1994,"Frank Darabont",9.3000000000000007]
[null,"12 Angry Men",1957,"Sidney Lumet",9,null,"The Godfather Part II",1974,"Francis Ford Coppola",9]
[null,"Schindler's List",1993,"Steven Spielberg",9,null,"Schindler's List",1993,"Steven Spielberg",9]
[null,null,null,null,null,null,"12 Angry Men",1957,"Sidney Lumet",9]
[null,null,null,null,null,null,"Schindler's List",1993,"Steven Spielberg",9]

{"sheet":"Power Query","index":6,"n_rows":13,"n_cols":10,"rows_kept":13,"cut":false,"hidden":false,"merged":[[2,1,2,4],[2,6,2,9]]}
[]
[]
[null,"Removing Duplicates But Keeping First Instance",null,null,null,null,"Practice"]
[]
[null,"Movie","Year","Director","Rating",null,"Movie","Year","Director","Rating"]
[null,"The Shawshank Redemption",1994,"Frank Darabont",9.3000000000000007,null,"The Shawshank Redemption",1994,"Frank Darabont",9.3000000000000007]
[null,"The Godfather",1972,"Francis Ford Coppola",9.1999999999999993,null,"The Godfather",1972,"Francis Ford Coppola",9.1999999999999993]
[null,"The Dark Knight",2008,"Christopher Nolan",9,null,"The Dark Knight",2008,"Christopher Nolan",9]
[null,"The Shawshank Redemption",1994,"Frank Darabont",9.3000000000000007,null,"The Shawshank Redemption",1994,"Frank Darabont",9.3000000000000007]
[null,"The Godfather Part II",1974,"Francis Ford Coppola",9,null,"The Godfather Part II",1974,"Francis Ford Coppola",9]
[null,"Schindler's List",1993,"Steven Spielberg",9,null,"Schindler's List",1993,"Steven Spielberg",9]
[null,"12 Angry Men",1957,"Sidney Lumet",9,null,"12 Angry Men",1957,"Sidney Lumet",9]
[null,"Schindler's List",1993,"Steven Spielberg",9,null,"Schindler's List",1993,"Steven Spielberg",9]

{"sheet":"Power Query Result","index":7,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Movie","Year","Director","Rating"]
[null,"The Shawshank Redemption",1994,"Frank Darabont",9.3000000000000007]
[null,"The Godfather",1972,"Francis Ford Coppola",9.1999999999999993]
[null,"The Dark Knight",2008,"Christopher Nolan",9]
[null,"The Godfather Part II",1974,"Francis Ford Coppola",9]
[null,"Schindler's List",1993,"Steven Spielberg",9]
[null,"12 Angry Men",1957,"Sidney Lumet",9]