{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Dataset","M1","M2","M3","M4","Find Duplicates"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"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":12,"n_cols":7,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Dataset"]
[]
[null,"Date","Code","Sold","On Hand ","Purchase Price","Balance Value"]
[null,"2022-01-04","B05465-R",73,110,11.99,11.99]
[null,"2022-01-02","B05465-R",82,120,11.99,11.99]
[null,"2022-01-04","B05465-R",73,110,11.99,11.99]
[null,"2022-03-01","46689-PC",35,53,388,386]
[null,"2022-01-01","002661-1",82,241,1.98,1.87]
[null,"2022-01-02","002661-1",93,148,1.98,1.87]
[null,"2022-03-01","46689-PC",35,53,388,386]
[null,"2022-01-01","002661-1",82,241,1.98,1.87]

{"sheet":"M1","index":1,"n_rows":12,"n_cols":14,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,6],[1,8,1,13]]}
[]
[null,"Using Remove Duplicates Option",null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Date","Code","Sold","On Hand ","Purchase Price","Balance Value",null,"Date","Code","Sold","On Hand ","Purchase Price","Balance Value"]
[null,"2022-01-04","B05465-R",73,110,11.99,11.99,null,"2022-01-04","B05465-R",73,110,11.99,11.99]
[null,"2022-01-02","B05465-R",82,120,11.99,11.99,null,"2022-01-02","B05465-R",82,120,11.99,11.99]
[null,"2022-03-01","46689-PC",35,53,388,386,null,"2022-01-04","B05465-R",73,110,11.99,11.99]
[null,"2022-01-01","002661-1",82,241,1.98,1.87,null,"2022-03-01","46689-PC",35,53,388,386]
[null,"2022-01-02","002661-1",93,148,1.98,1.87,null,"2022-01-01","002661-1",82,241,1.98,1.87]
[null,null,null,null,null,null,null,null,"2022-01-02","002661-1",93,148,1.98,1.87]
[null,null,null,null,null,null,null,null,"2022-03-01","46689-PC",35,53,388,386]
[null,null,null,null,null,null,null,null,"2022-01-01","002661-1",82,241,1.98,1.87]

{"sheet":"M2","index":2,"n_rows":22,"n_cols":14,"rows_kept":22,"cut":false,"hidden":false,"merged":[[1,1,1,6],[14,1,14,6],[1,8,1,13]]}
[]
[null,"Applying Advaced Filter Option",null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Date","Code","Sold","On Hand ","Purchase Price","Balance Value",null,"Date","Code","Sold","On Hand ","Purchase Price","Balance Value"]
[null,"2022-01-04","B05465-R",73,110,11.99,11.99,null,"2022-01-04","B05465-R",73,110,11.99,11.99]
[null,"2022-01-02","B05465-R",82,120,11.99,11.99,null,"2022-01-02","B05465-R",82,120,11.99,11.99]
[null,"2022-01-04","B05465-R",73,110,11.99,11.99,null,"2022-01-04","B05465-R",73,110,11.99,11.99]
[null,"2022-03-01","46689-PC",35,53,388,386,null,"2022-03-01","46689-PC",35,53,388,386]
[null,"2022-01-01","002661-1",82,241,1.98,1.87,null,"2022-01-01","002661-1",82,241,1.98,1.87]
[null,"2022-01-02","002661-1",93,148,1.98,1.87,null,"2022-01-02","002661-1",93,148,1.98,1.87]
[null,"2022-03-01","46689-PC",35,53,388,386,null,"2022-03-01","46689-PC",35,53,388,386]
[null,"2022-01-01","002661-1",82,241,1.98,1.87,null,"2022-01-01","002661-1",82,241,1.98,1.87]
[]
[]
[null,"After Removing Duplicate Rows"]
[]
[null,"Date","Code","Sold","On Hand ","Purchase Price","Balance Value"]
[null,"2022-01-04","B05465-R",73,110,11.99,11.99]
[null,"2022-01-02","B05465-R",82,120,11.99,11.99]
[null,"2022-03-01","46689-PC",35,53,388,386]
[null,"2022-01-01","002661-1",82,241,1.98,1.87]
[null,"2022-01-02","002661-1",93,148,1.98,1.87]

{"sheet":"M3","index":3,"n_rows":12,"n_cols":16,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,7],[1,9,1,15]]}
[]
[null,"Inserting IF & COUNTIFS Functions",null,null,null,null,null,null,null,"Practice Yoursef"]
[]
[null,"Date","Code","Sold","On Hand ","Purchase Price","Balance Value","Status",null,"Date","Code","Sold","On Hand ","Purchase Price","Balance Value","Status"]
[null,"2022-01-04","B05465-R",73,110,11.99,11.99,{"$f":"IF(COUNTIFS($B$5:$B5, $B5, $C$5:$C5, $C5, $D$5:$D5, $D5,\n$E$5:$E5, $E5,$F$5:$F5, $F5,$G$5:$G5, $G5)>1, \"Duplicate row\", \"Unique\")","v":"Unique"},null,"2022-01-04","B05465-R",73,110,11.99,11.99]
[null,"2022-01-02","B05465-R",82,120,11.99,11.99,{"$f":"IF(COUNTIFS($B$5:$B6, $B6, $C$5:$C6, $C6, $D$5:$D6, $D6,$E$5:$E6, $E6,$F$5:$F6, $F6,$G$5:$G6, $G6)>1, \"Duplicate row\", \"Unique\")","v":"Unique"},null,"2022-01-02","B05465-R",82,120,11.99,11.99]
[null,"2022-03-01","46689-PC",35,53,388,386,{"$f":"IF(COUNTIFS($B$5:$B7, $B7, $C$5:$C7, $C7, $D$5:$D7, $D7,$E$5:$E7, $E7,$F$5:$F7, $F7,$G$5:$G7, $G7)>1, \"Duplicate row\", \"Unique\")","v":"Unique"},null,"2022-01-04","B05465-R",73,110,11.99,11.99]
[null,"2022-01-01","002661-1",82,241,1.98,1.87,{"$f":"IF(COUNTIFS($B$5:$B8, $B8, $C$5:$C8, $C8, $D$5:$D8, $D8,$E$5:$E8, $E8,$F$5:$F8, $F8,$G$5:$G8, $G8)>1, \"Duplicate row\", \"Unique\")","v":"Unique"},null,"2022-03-01","46689-PC",35,53,388,386]
[null,"2022-01-02","002661-1",93,148,1.98,1.87,{"$f":"IF(COUNTIFS($B$5:$B9, $B9, $C$5:$C9, $C9, $D$5:$D9, $D9,$E$5:$E9, $E9,$F$5:$F9, $F9,$G$5:$G9, $G9)>1, \"Duplicate row\", \"Unique\")","v":"Unique"},null,"2022-01-01","002661-1",82,241,1.98,1.87]
[null,null,null,null,null,null,null,null,null,"2022-01-02","002661-1",93,148,1.98,1.87]
[null,null,null,null,null,null,null,null,null,"2022-03-01","46689-PC",35,53,388,386]
[null,null,null,null,null,null,null,null,null,"2022-01-01","002661-1",82,241,1.98,1.87]

{"sheet":"M4","index":4,"n_rows":12,"n_cols":14,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,6],[1,8,1,13]]}
[]
[null,"Applying VBA",null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Date","Code","Sold","On Hand ","Purchase Price","Balance Value",null,"Date","Code","Sold","On Hand ","Purchase Price","Balance Value"]
[null,"2022-01-04","B05465-R",73,110,11.99,11.99,null,"2022-01-04","B05465-R",73,110,11.99,11.99]
[null,"2022-01-02","B05465-R",82,120,11.99,11.99,null,"2022-01-02","B05465-R",82,120,11.99,11.99]
[null,"2022-03-01","46689-PC",35,53,388,386,null,"2022-01-04","B05465-R",73,110,11.99,11.99]
[null,"2022-01-01","002661-1",82,241,1.98,1.87,null,"2022-03-01","46689-PC",35,53,388,386]
[null,"2022-01-02","002661-1",93,148,1.98,1.87,null,"2022-01-01","002661-1",82,241,1.98,1.87]
[null,null,null,null,null,null,null,null,"2022-01-02","002661-1",93,148,1.98,1.87]
[null,null,null,null,null,null,null,null,"2022-03-01","46689-PC",35,53,388,386]
[null,null,null,null,null,null,null,null,"2022-01-01","002661-1",82,241,1.98,1.87]

{"sheet":"Find Duplicates","index":5,"n_rows":12,"n_cols":16,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,7],[1,9,1,15]]}
[]
[null,"Finding Duplicates",null,null,null,null,null,null,null,"Practice Yoursef"]
[]
[null,"Date","Code","Sold","On Hand ","Purchase Price","Balance Value","Status",null,"Date","Code","Sold","On Hand ","Purchase Price","Balance Value","Status"]
[null,"2022-01-04","B05465-R",73,110,11.99,11.99,{"$f":"IF(COUNTIFS($B$5:$B5, $B5, $C$5:$C5, $C5, $D$5:$D5,\n $D5,$E$5:$E5, $E5,$F$5:$F5, $F5,$G$5:$G5, $G5)>1, \"Duplicate row\", \"Unique\")","v":"Unique"},null,"2022-01-04","B05465-R",73,110,11.99,11.99]
[null,"2022-01-02","B05465-R",82,120,11.99,11.99,{"$f":"IF(COUNTIFS($B$5:$B6, $B6, $C$5:$C6, $C6, $D$5:$D6, $D6,$E$5:$E6, $E6,$F$5:$F6, $F6,$G$5:$G6, $G6)>1, \"Duplicate row\", \"Unique\")","v":"Unique"},null,"2022-01-02","B05465-R",82,120,11.99,11.99]
[null,"2022-01-04","B05465-R",73,110,11.99,11.99,{"$f":"IF(COUNTIFS($B$5:$B7, $B7, $C$5:$C7, $C7, $D$5:$D7, $D7,$E$5:$E7, $E7,$F$5:$F7, $F7,$G$5:$G7, $G7)>1, \"Duplicate row\", \"Unique\")","v":"Duplicate row"},null,"2022-01-04","B05465-R",73,110,11.99,11.99]
[null,"2022-03-01","46689-PC",35,53,388,386,{"$f":"IF(COUNTIFS($B$5:$B8, $B8, $C$5:$C8, $C8, $D$5:$D8, $D8,$E$5:$E8, $E8,$F$5:$F8, $F8,$G$5:$G8, $G8)>1, \"Duplicate row\", \"Unique\")","v":"Unique"},null,"2022-03-01","46689-PC",35,53,388,386]
[null,"2022-01-01","002661-1",82,241,1.98,1.87,{"$f":"IF(COUNTIFS($B$5:$B9, $B9, $C$5:$C9, $C9, $D$5:$D9, $D9,$E$5:$E9, $E9,$F$5:$F9, $F9,$G$5:$G9, $G9)>1, \"Duplicate row\", \"Unique\")","v":"Unique"},null,"2022-01-01","002661-1",82,241,1.98,1.87]
[null,"2022-01-02","002661-1",93,148,1.98,1.87,{"$f":"IF(COUNTIFS($B$5:$B10, $B10, $C$5:$C10, $C10, $D$5:$D10, $D10,$E$5:$E10, $E10,$F$5:$F10, $F10,$G$5:$G10, $G10)>1, \"Duplicate row\", \"Unique\")","v":"Unique"},null,"2022-01-02","002661-1",93,148,1.98,1.87]
[null,"2022-03-01","46689-PC",35,53,388,386,{"$f":"IF(COUNTIFS($B$5:$B11, $B11, $C$5:$C11, $C11, $D$5:$D11, $D11,$E$5:$E11, $E11,$F$5:$F11, $F11,$G$5:$G11, $G11)>1, \"Duplicate row\", \"Unique\")","v":"Duplicate row"},null,"2022-03-01","46689-PC",35,53,388,386]
[null,"2022-01-01","002661-1",82,241,1.98,1.87,{"$f":"IF(COUNTIFS($B$5:$B12, $B12, $C$5:$C12, $C12, $D$5:$D12, $D12,$E$5:$E12, $E12,$F$5:$F12, $F12,$G$5:$G12, $G12)>1, \"Duplicate row\", \"Unique\")","v":"Duplicate row"},null,"2022-01-01","002661-1",82,241,1.98,1.87]