{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Dataset","Using Advanced Filter","COUNTIF Function","Remove Duplicates Command","IF and COUNTIFS Functuions","Remove All Duplicates","Conditional Formatting","Using UNIQUE Function","Applying VBA Code"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":10,"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":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Removing Duplicates"]
[]
[null,"Customer Name","Item Sold","Price"]
[null,"Alex Harper","Keyboard",200]
[null,"Joan Harris","Motherboard",2000]
[null,"Alex Harper","Keyboard",200]
[null,"Henry Jones","RAM",1500]
[null,"Tom Jones","Hard Disk ",500]
[null,"Henry Jones","RAM",1500]
[null,"Mark Anthony","Monitor",600]
[null,"Jon Luke ","UPS",1200]
[null,"Jonny Smith","Mouse",50]
[null,"Mark Anthony","Monitor",600]

{"sheet":"Using Advanced Filter","index":1,"n_rows":14,"n_cols":16,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,7],[1,13,1,15]]}
[]
[null,"Using Advanced Filter",null,null,null,null,null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Customer Name","Item Sold","Price",null,"Customer Name","Item Sold","Price",null,null,null,null,null,"Customer Name","Item Sold","Price"]
[null,"Alex Harper","Keyboard",200,null,"Alex Harper","Keyboard",200,null,null,null,null,null,"Alex Harper","Keyboard",200]
[null,"Joan Harris","Motherboard",2000,null,"Joan Harris","Motherboard",2000,null,null,null,null,null,"Joan Harris","Motherboard",2000]
[null,"Alex Harper","Keyboard",200,null,"Henry Jones","RAM",1500,null,null,null,null,null,"Alex Harper","Keyboard",200]
[null,"Henry Jones","RAM",1500,null,"Tom Jones","Hard Disk ",500,null,null,null,null,null,"Henry Jones","RAM",1500]
[null,"Tom Jones","Hard Disk ",500,null,"Mark Anthony","Monitor",600,null,null,null,null,null,"Tom Jones","Hard Disk ",500]
[null,"Henry Jones","RAM",1500,null,"Jon Luke ","UPS",1200,null,null,null,null,null,"Henry Jones","RAM",1500]
[null,"Mark Anthony","Monitor",600,null,"Jonny Smith","Mouse",50,null,null,null,null,null,"Mark Anthony","Monitor",600]
[null,"Jon Luke ","UPS",1200,null,null,null,null,null,null,null,null,null,"Jon Luke ","UPS",1200]
[null,"Jonny Smith","Mouse",50,null,null,null,null,null,null,null,null,null,"Jonny Smith","Mouse",50]
[null,"Mark Anthony","Monitor",600,null,null,null,null,null,null,null,null,null,"Mark Anthony","Monitor",600]

{"sheet":"COUNTIF Function","index":2,"n_rows":14,"n_cols":14,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,11,1,13]]}
[]
[null,"Employing COUNTIF Function",null,null,null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Customer Name","Item Sold","Price","Combined Text","Count",null,null,null,null,null,"Customer Name","Item Sold","Price"]
[null,"Alex Harper","Keyboard",200,{"$f":"B5&C5&D5","v":"Alex HarperKeyboard200"},{"$f":"COUNTIF(E$5:E5,E5)","v":1},null,null,null,null,null,"Alex Harper","Keyboard",200]
[null,"Joan Harris","Motherboard",2000,{"$f":"B6&C6&D6","v":"Joan HarrisMotherboard2000"},{"$f":"COUNTIF(E$5:E6,E6)","v":1},null,null,null,null,null,"Joan Harris","Motherboard",2000]
[null,"Alex Harper","Keyboard",200,"Alex HarperKeyboard200",{"$f":"COUNTIF(E$5:E7,E7)","v":2},null,null,null,null,null,"Alex Harper","Keyboard",200]
[null,"Henry Jones","RAM",1500,"Henry JonesRAM1500",{"$f":"COUNTIF(E$5:E8,E8)","v":1},null,null,null,null,null,"Henry Jones","RAM",1500]
[null,"Tom Jones","Hard Disk ",500,"Tom JonesHard Disk 500",{"$f":"COUNTIF(E$5:E9,E9)","v":1},null,null,null,null,null,"Tom Jones","Hard Disk ",500]
[null,"Henry Jones","RAM",1500,"Henry JonesRAM1500",{"$f":"COUNTIF(E$5:E10,E10)","v":2},null,null,null,null,null,"Henry Jones","RAM",1500]
[null,"Mark Anthony","Monitor",600,"Mark AnthonyMonitor600",{"$f":"COUNTIF(E$5:E11,E11)","v":1},null,null,null,null,null,"Mark Anthony","Monitor",600]
[null,"Jon Luke ","UPS",1200,"Jon Luke UPS1200",{"$f":"COUNTIF(E$5:E12,E12)","v":1},null,null,null,null,null,"Jon Luke ","UPS",1200]
[null,"Jonny Smith","Mouse",50,"Jonny SmithMouse50",{"$f":"COUNTIF(E$5:E13,E13)","v":1},null,null,null,null,null,"Jonny Smith","Mouse",50]
[null,"Mark Anthony","Monitor",600,"Mark AnthonyMonitor600",{"$f":"COUNTIF(E$5:E14,E14)","v":2},null,null,null,null,null,"Mark Anthony","Monitor",600]

{"sheet":"Remove Duplicates Command","index":3,"n_rows":14,"n_cols":15,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,12,1,14]]}
[]
[null,"Applying Remove Duplicates Command",null,null,null,null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Customer Name","Item Sold","Price",null,null,null,null,null,null,null,null,"Customer Name","Item Sold","Price"]
[null,"Alex Harper","Keyboard",200,null,null,null,null,null,null,null,null,"Alex Harper","Keyboard",200]
[null,"Joan Harris","Motherboard",2000,null,null,null,null,null,null,null,null,"Joan Harris","Motherboard",2000]
[null,"Henry Jones","RAM",1500,null,null,null,null,null,null,null,null,"Alex Harper","Keyboard",200]
[null,"Tom Jones","Hard Disk ",500,null,null,null,null,null,null,null,null,"Henry Jones","RAM",1500]
[null,"Mark Anthony","Monitor",600,null,null,null,null,null,null,null,null,"Tom Jones","Hard Disk ",500]
[null,"Jon Luke ","UPS",1200,null,null,null,null,null,null,null,null,"Henry Jones","RAM",1500]
[null,"Jonny Smith","Mouse",50,null,null,null,null,null,null,null,null,"Mark Anthony","Monitor",600]
[null,null,null,null,null,null,null,null,null,null,null,null,"Jon Luke ","UPS",1200]
[null,null,null,null,null,null,null,null,null,null,null,null,"Jonny Smith","Mouse",50]
[null,null,null,null,null,null,null,null,null,null,null,null,"Mark Anthony","Monitor",600]

{"sheet":"IF and COUNTIFS Functuions","index":4,"n_rows":14,"n_cols":12,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,9,1,11]]}
[]
[null,"Utilizing IF and COUNTIFS Functions",null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Customer Name","Item Sold","Price","Status",null,null,null,null,"Customer Name","Item Sold","Price"]
[null,"Alex Harper","Keyboard",200,{"$f":"IF(COUNTIFS($B$5:$B5,$B5,$C$5:$C5,$C5,$D$5:$D5,$D5)>1,\"Duplicate Row\",\"Unique\")","v":"Unique"},null,null,null,null,"Alex Harper","Keyboard",200]
[null,"Joan Harris","Motherboard",2000,{"$f":"IF(COUNTIFS($B$5:$B6,$B6,$C$5:$C6,$C6,$D$5:$D6,$D6)>1,\"Duplicate Row\",\"Unique\")","v":"Unique"},null,null,null,null,"Joan Harris","Motherboard",2000]
[null,"Alex Harper","Keyboard",200,{"$f":"IF(COUNTIFS($B$5:$B7,$B7,$C$5:$C7,$C7,$D$5:$D7,$D7)>1,\"Duplicate Row\",\"Unique\")","v":"Duplicate Row"},null,null,null,null,"Alex Harper","Keyboard",200]
[null,"Henry Jones","RAM",1500,{"$f":"IF(COUNTIFS($B$5:$B8,$B8,$C$5:$C8,$C8,$D$5:$D8,$D8)>1,\"Duplicate Row\",\"Unique\")","v":"Unique"},null,null,null,null,"Henry Jones","RAM",1500]
[null,"Tom Jones","Hard Disk ",500,{"$f":"IF(COUNTIFS($B$5:$B9,$B9,$C$5:$C9,$C9,$D$5:$D9,$D9)>1,\"Duplicate Row\",\"Unique\")","v":"Unique"},null,null,null,null,"Tom Jones","Hard Disk ",500]
[null,"Henry Jones","RAM",1500,{"$f":"IF(COUNTIFS($B$5:$B10,$B10,$C$5:$C10,$C10,$D$5:$D10,$D10)>1,\"Duplicate Row\",\"Unique\")","v":"Duplicate Row"},null,null,null,null,"Henry Jones","RAM",1500]
[null,"Mark Anthony","Monitor",600,{"$f":"IF(COUNTIFS($B$5:$B11,$B11,$C$5:$C11,$C11,$D$5:$D11,$D11)>1,\"Duplicate Row\",\"Unique\")","v":"Unique"},null,null,null,null,"Mark Anthony","Monitor",600]
[null,"Jon Luke ","UPS",1200,{"$f":"IF(COUNTIFS($B$5:$B12,$B12,$C$5:$C12,$C12,$D$5:$D12,$D12)>1,\"Duplicate Row\",\"Unique\")","v":"Unique"},null,null,null,null,"Jon Luke ","UPS",1200]
[null,"Jonny Smith","Mouse",50,{"$f":"IF(COUNTIFS($B$5:$B13,$B13,$C$5:$C13,$C13,$D$5:$D13,$D13)>1,\"Duplicate Row\",\"Unique\")","v":"Unique"},null,null,null,null,"Jonny Smith","Mouse",50]
[null,"Mark Anthony","Monitor",600,{"$f":"IF(COUNTIFS($B$5:$B14,$B14,$C$5:$C14,$C14,$D$5:$D14,$D14)>1,\"Duplicate Row\",\"Unique\")","v":"Duplicate Row"},null,null,null,null,"Mark Anthony","Monitor",600]

{"sheet":"Remove All Duplicates","index":5,"n_rows":14,"n_cols":12,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,9,1,11]]}
[]
[null,"Utilizing IF and COUNTIFS Functions",null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Customer Name","Item Sold","Price","Status",null,null,null,null,"Customer Name","Item Sold","Price"]
[null,"Alex Harper","Keyboard",200,{"$f":"IF(COUNTIFS($B$5:$B$14,$B5,$C$5:$C$14,$C5,$D$5:$D$14,$D5)>1,\"Duplicate Row\",\"Unique\")","v":"Duplicate Row"},null,null,null,null,"Alex Harper","Keyboard",200]
[null,"Joan Harris","Motherboard",2000,{"$f":"IF(COUNTIFS($B$5:$B$14,$B6,$C$5:$C$14,$C6,$D$5:$D$14,$D6)>1,\"Duplicate Row\",\"Unique\")","v":"Unique"},null,null,null,null,"Joan Harris","Motherboard",2000]
[null,"Alex Harper","Keyboard",200,"Duplicate Row",null,null,null,null,"Alex Harper","Keyboard",200]
[null,"Henry Jones","RAM",1500,"Duplicate Row",null,null,null,null,"Henry Jones","RAM",1500]
[null,"Tom Jones","Hard Disk ",500,"Unique",null,null,null,null,"Tom Jones","Hard Disk ",500]
[null,"Henry Jones","RAM",1500,"Duplicate Row",null,null,null,null,"Henry Jones","RAM",1500]
[null,"Mark Anthony","Monitor",600,"Duplicate Row",null,null,null,null,"Mark Anthony","Monitor",600]
[null,"Jon Luke ","UPS",1200,"Unique",null,null,null,null,"Jon Luke ","UPS",1200]
[null,"Jonny Smith","Mouse",50,"Unique",null,null,null,null,"Jonny Smith","Mouse",50]
[null,"Mark Anthony","Monitor",600,"Duplicate Row",null,null,null,null,"Mark Anthony","Monitor",600]

{"sheet":"Conditional Formatting","index":6,"n_rows":14,"n_cols":13,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,10,1,12]]}
[]
[null,"Applying Conditional Formatting",null,null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Customer Name","Item Sold","Price","Combined Text",null,null,null,null,null,"Customer Name","Item Sold","Price"]
[null,"Alex Harper","Keyboard",200,{"$f":"B5&C5&D5","v":"Alex HarperKeyboard200"},null,null,null,null,null,"Alex Harper","Keyboard",200]
[null,"Joan Harris","Motherboard",2000,{"$f":"B6&C6&D6","v":"Joan HarrisMotherboard2000"},null,null,null,null,null,"Joan Harris","Motherboard",2000]
[null,"Alex Harper","Keyboard",200,"Alex HarperKeyboard200",null,null,null,null,null,"Alex Harper","Keyboard",200]
[null,"Henry Jones","RAM",1500,"Henry JonesRAM1500",null,null,null,null,null,"Henry Jones","RAM",1500]
[null,"Tom Jones","Hard Disk ",500,"Tom JonesHard Disk 500",null,null,null,null,null,"Tom Jones","Hard Disk ",500]
[null,"Henry Jones","RAM",1500,"Henry JonesRAM1500",null,null,null,null,null,"Henry Jones","RAM",1500]
[null,"Mark Anthony","Monitor",600,"Mark AnthonyMonitor600",null,null,null,null,null,"Mark Anthony","Monitor",600]
[null,"Jon Luke ","UPS",1200,"Jon Luke UPS1200",null,null,null,null,null,"Jon Luke ","UPS",1200]
[null,"Jonny Smith","Mouse",50,"Jonny SmithMouse50",null,null,null,null,null,"Jonny Smith","Mouse",50]
[null,"Mark Anthony","Monitor",600,"Mark AnthonyMonitor600",null,null,null,null,null,"Mark Anthony","Monitor",600]

{"sheet":"Using UNIQUE Function","index":7,"n_rows":14,"n_cols":15,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,7],[1,12,1,14]]}
[]
[null,"Using UNIQUE Function",null,null,null,null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Customer Name","Item Sold","Price",null,{"$f":"_xlfn.UNIQUE(B4:D14,FALSE,FALSE)","v":"Customer Name"},"Item Sold","Price",null,null,null,null,"Customer Name","Item Sold","Price"]
[null,"Alex Harper","Keyboard",200,null,"Alex Harper","Keyboard",200,null,null,null,null,"Alex Harper","Keyboard",200]
[null,"Joan Harris","Motherboard",2000,null,"Joan Harris","Motherboard",2000,null,null,null,null,"Joan Harris","Motherboard",2000]
[null,"Alex Harper","Keyboard",200,null,"Henry Jones","RAM",1500,null,null,null,null,"Alex Harper","Keyboard",200]
[null,"Henry Jones","RAM",1500,null,"Tom Jones","Hard Disk ",500,null,null,null,null,"Henry Jones","RAM",1500]
[null,"Tom Jones","Hard Disk ",500,null,"Mark Anthony","Monitor",600,null,null,null,null,"Tom Jones","Hard Disk ",500]
[null,"Henry Jones","RAM",1500,null,"Jon Luke ","UPS",1200,null,null,null,null,"Henry Jones","RAM",1500]
[null,"Mark Anthony","Monitor",600,null,"Jonny Smith","Mouse",50,null,null,null,null,"Mark Anthony","Monitor",600]
[null,"Jon Luke ","UPS",1200,null,null,null,null,null,null,null,null,"Jon Luke ","UPS",1200]
[null,"Jonny Smith","Mouse",50,null,null,null,null,null,null,null,null,"Jonny Smith","Mouse",50]
[null,"Mark Anthony","Monitor",600,null,null,null,null,null,null,null,null,"Mark Anthony","Monitor",600]

{"sheet":"Applying VBA Code","index":8,"n_rows":14,"n_cols":14,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,11,1,13]]}
[]
[null,"Use of VBA",null,null,null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Customer Name","Item Sold","Price",null,null,null,null,null,null,null,"Customer Name","Item Sold","Price"]
[null,"Alex Harper","Keyboard",200,null,null,null,null,null,null,null,"Alex Harper","Keyboard",200]
[null,"Joan Harris","Motherboard",2000,null,null,null,null,null,null,null,"Joan Harris","Motherboard",2000]
[null,"Henry Jones","RAM",1500,null,null,null,null,null,null,null,"Alex Harper","Keyboard",200]
[null,"Tom Jones","Hard Disk ",500,null,null,null,null,null,null,null,"Henry Jones","RAM",1500]
[null,"Mark Anthony","Monitor",600,null,null,null,null,null,null,null,"Tom Jones","Hard Disk ",500]
[null,"Jon Luke ","UPS",1200,null,null,null,null,null,null,null,"Henry Jones","RAM",1500]
[null,"Jonny Smith","Mouse",50,null,null,null,null,null,null,null,"Mark Anthony","Monitor",600]
[null,null,null,null,null,null,null,null,null,null,null,"Jon Luke ","UPS",1200]
[null,null,null,null,null,null,null,null,null,null,null,"Jonny Smith","Mouse",50]
[null,null,null,null,null,null,null,null,null,null,null,"Mark Anthony","Monitor",600]