{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Advanced","FIlter","remove duplicates","IF and COUNTIF","INDEX-MATCH","UNIQUE(Ex1)","UNIQUE(Ex2)","UNIQUE(Ex3)","UNIQUE(Ex4)","UNIQUE(Ex5)","VBA"],"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":"Advanced","index":0,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Using Advanced Filter"]
[]
[null,"Data",null,"Data"]
[null,"Aaron",null,"Aaron"]
[null,"James",null,"James"]
[null,"Aaron",null,"Max"]
[null,"Max",null,"Jason"]
[null,"Jason",null,"Robert"]
[null,"James",null,"Stacy"]
[null,"Robert"]
[null,"Stacy"]
[null,"Max"]

{"sheet":"FIlter","index":1,"n_rows":13,"n_cols":2,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Using Advanced Filter"]
[]
[null,"Data"]
[null,"Aaron"]
[null,"James"]
[null,"Aaron"]
[null,"Max"]
[null,"Jason"]
[null,"James"]
[null,"Robert"]
[null,"Stacy"]
[null,"Max"]

{"sheet":"remove duplicates","index":2,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Remove Duplicates ",null,"Practice"]
[]
[null,"Data",null,"Data"]
[null,"Aaron",null,"Aaron"]
[null,"James",null,"James"]
[null,"Max",null,"Aaron"]
[null,"Jason",null,"Max"]
[null,"Robert",null,"Jason"]
[null,"Stacy",null,"James"]
[null,null,null,"Robert"]
[null,null,null,"Stacy"]
[null,null,null,"Max"]

{"sheet":"IF and COUNTIF","index":3,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using IF and COUNTIF Functions"]
[]
[null,"Data",null,"Unique Data"]
[null,"Aaron",null,{"$f":"IF(COUNTIF(B$5:B5,B5)=1,B5,\"\")","v":"Aaron"}]
[null,"James",null,{"$f":"IF(COUNTIF(B$5:B6,B6)=1,B6,\"\")","v":"James"}]
[null,"Aaron",null,{"$f":"IF(COUNTIF(B$5:B7,B7)=1,B7,\"\")","v":""}]
[null,"Max",null,{"$f":"IF(COUNTIF(B$5:B8,B8)=1,B8,\"\")","v":"Max"}]
[null,"Jason",null,{"$f":"IF(COUNTIF(B$5:B9,B9)=1,B9,\"\")","v":"Jason"}]
[null,"James",null,{"$f":"IF(COUNTIF(B$5:B10,B10)=1,B10,\"\")","v":""}]
[null,"Robert",null,{"$f":"IF(COUNTIF(B$5:B11,B11)=1,B11,\"\")","v":"Robert"}]
[null,"Stacy",null,{"$f":"IF(COUNTIF(B$5:B12,B12)=1,B12,\"\")","v":"Stacy"}]
[null,"Max",null,{"$f":"IF(COUNTIF(B$5:B13,B13)=1,B13,\"\")","v":""}]

{"sheet":"INDEX-MATCH","index":4,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using INDEX-MATCH Function"]
[]
[null,"Data",null,"Unique Data"]
[null,"Aaron",null,{"$f":"IFERROR(INDEX($B$5:$B$13,\nMATCH(0,COUNTIF($D$4:D4, $B$5:$B$13), 0)),\"\")","v":"Aaron"}]
[null,"James",null,{"$f":"IFERROR(INDEX($B$5:$B$13,\nMATCH(0,COUNTIF($D$4:D5, $B$5:$B$13), 0)),\"\")","v":"James"}]
[null,"Aaron",null,{"$f":"IFERROR(INDEX($B$5:$B$13,\nMATCH(0,COUNTIF($D$4:D6, $B$5:$B$13), 0)),\"\")","v":"Max"}]
[null,"Max",null,{"$f":"IFERROR(INDEX($B$5:$B$13,\nMATCH(0,COUNTIF($D$4:D7, $B$5:$B$13), 0)),\"\")","v":"Jason"}]
[null,"Jason",null,{"$f":"IFERROR(INDEX($B$5:$B$13,\nMATCH(0,COUNTIF($D$4:D8, $B$5:$B$13), 0)),\"\")","v":"Robert"}]
[null,"James",null,{"$f":"IFERROR(INDEX($B$5:$B$13,\nMATCH(0,COUNTIF($D$4:D9, $B$5:$B$13), 0)),\"\")","v":"Stacy"}]
[null,"Robert",null,{"$f":"IFERROR(INDEX($B$5:$B$13,\nMATCH(0,COUNTIF($D$4:D10, $B$5:$B$13), 0)),\"\")","v":""}]
[null,"Stacy",null,{"$f":"IFERROR(INDEX($B$5:$B$13,\nMATCH(0,COUNTIF($D$4:D11, $B$5:$B$13), 0)),\"\")","v":""}]
[null,"Max",null,{"$f":"IFERROR(INDEX($B$5:$B$13,\nMATCH(0,COUNTIF($D$4:D12, $B$5:$B$13), 0)),\"\")","v":""}]

{"sheet":"UNIQUE(Ex1)","index":5,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using UNIQUE Function"]
[]
[null,"Data",null,"Unique Data"]
[null,"Aaron",null,{"$f":"_xlfn.UNIQUE(B5:B13)","v":"Aaron"}]
[null,"James",null,"James"]
[null,"Aaron",null,"Max"]
[null,"Max",null,"Jason"]
[null,"Jason",null,"Robert"]
[null,"James",null,"Stacy"]
[null,"Robert"]
[null,"Stacy"]
[null,"Max"]

{"sheet":"UNIQUE(Ex2)","index":6,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using UNIQUE Function"]
[]
[null,"Data",null,"Unique Data"]
[null,"Aaron",null,{"$f":"_xlfn.UNIQUE(B5:B13,,TRUE)","v":"Jason"}]
[null,"James",null,"Robert"]
[null,"Aaron",null,"Stacy"]
[null,"Max"]
[null,"Jason"]
[null,"James"]
[null,"Robert"]
[null,"Stacy"]
[null,"Max"]

{"sheet":"UNIQUE(Ex3)","index":7,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Using UNIQUE Function"]
[]
[null,"First Name","Last Name"]
[null,"Aaron","Johnson",null,{"$f":"_xlfn.UNIQUE(B5:C13)","v":"Aaron"},"Johnson"]
[null,"James","Anderson",null,"James","Anderson"]
[null,"Aaron","Tylor",null,"Aaron","Tylor"]
[null,"Max","Westen",null,"Max","Westen"]
[null,"Jason","Mamoa",null,"Jason","Mamoa"]
[null,"James","Robert",null,"James","Robert"]
[null,"Robert","Pattinson",null,"Robert","Pattinson"]
[null,"Stacy","Anderson",null,"Stacy","Anderson"]
[null,"Max","Westen"]

{"sheet":"UNIQUE(Ex4)","index":8,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using UNIQUE ans SORT Function"]
[]
[null,"Data",null,"Unique Data"]
[null,"Aaron",null,{"$f":"_xlfn._xlws.SORT(_xlfn.UNIQUE(B5:B13))","v":"Aaron"}]
[null,"James",null,"James"]
[null,"Aaron",null,"Jason"]
[null,"Max",null,"Max"]
[null,"Jason",null,"Robert"]
[null,"James",null,"Stacy"]
[null,"Robert"]
[null,"Stacy"]
[null,"Max"]

{"sheet":"UNIQUE(Ex5)","index":9,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[[3,4,3,5],[1,1,1,5]]}
[]
[null,"Using UNIQUE Function"]
[]
[null,"Name","Age",null,"Unique Data"]
[null,"Aaron",20,null,{"$f":"_xlfn.UNIQUE(_xlfn._xlws.FILTER(B5:C13,C5:C13<30))","v":"Aaron"},20]
[null,"James",23,null,"James",23]
[null,"Aaron",30,null,"Jason",29]
[null,"Max",32,null,"Stacy",22]
[null,"Jason",29]
[null,"James",34]
[null,"Robert",40]
[null,"Stacy",22]
[null,"Max",31]

{"sheet":"VBA","index":10,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Using VBA Macros",null,"Using VBA Macros"]
[]
[null,"Data",null,"Data"]
[null,"Aaron",null,"Aaron"]
[null,"James",null,"James"]
[null,"Aaron",null,"Max"]
[null,"Max",null,"Jason"]
[null,"Jason",null,"Robert"]
[null,"James",null,"Stacy"]
[null,"Robert"]
[null,"Stacy"]
[null,"Max"]