{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Sheet1","IF","IF&COUNTIF","VLOOKUP","ISNUMBER & MATCH","Using VBA"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":0,"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":"Sheet1","index":0,"n_rows":15,"n_cols":4,"rows_kept":15,"cut":false,"hidden":false,"merged":[[2,1,2,3],[1,1,1,3]]}
[]
[null,"Dataset"]
[null,"Employee Information1 Workbook"]
[null,"Employee Name","States","Designation"]
[null,"Robert","Ohio","CEO"]
[null,"Allen","Utah","Project Manager"]
[null,"Miller","Nevada","Web Developer"]
[null,"Emma ","Ohio","Senior HR"]
[null,"Sarah","Ohio","IT Expert"]
[null,"Linda","Nevada","Technical Writer"]
[null,"Laura","Utah","Team Leader"]
[null,"Harris","Ohio","HR Consultant"]
[null,"Gabriel","Ohio","Receptionist"]
[null,"Christ","Utah","Technical Writer"]
[null,"John","Nevada","Team Leader"]

{"sheet":"IF","index":1,"n_rows":15,"n_cols":5,"rows_kept":15,"cut":false,"hidden":false,"merged":[[2,1,2,4],[1,1,1,4]]}
[]
[null,"Using the COUNTIF Function"]
[null,"Employee Information1 Workbook"]
[null,"Employee Name","States","Designation","Count"]
[null,"Robert","Ohio","CEO",{"$f":"COUNTIF([1]Sheet1!$B$5:$B$15,B5:B15)","v":0}]
[null,"Allen","Utah","Project Manager",0]
[null,"Miller","Nevada","Web Developer",0]
[null,"Emma ","Ohio","Senior HR",1]
[null,"Sarah","Ohio","IT Expert",0]
[null,"Linda","Nevada","Technical Writer",1]
[null,"Laura","Utah","Team Leader",1]
[null,"Harris","Ohio","HR Consultant",0]
[null,"Gabriel","Ohio","Receptionist",1]
[null,"Christ","Utah","Technical Writer",0]
[null,"John","Nevada","Team Leader",1]

{"sheet":"IF&COUNTIF","index":2,"n_rows":15,"n_cols":5,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,4],[2,1,2,4]]}
[]
[null,"Using the IF & COUNTIF Function"]
[null,"Employee Information1 Workbook"]
[null,"Employee Name","States","Designation","Duplicate or Unique?"]
[null,"Robert","Ohio","CEO",{"$f":"IF(COUNTIF([1]Sheet1!$B$5:$B$15,B5:B15),\"Duplicate\",\"Unique\")","v":"Unique"}]
[null,"Allen","Utah","Project Manager","Unique"]
[null,"Miller","Nevada","Web Developer","Unique"]
[null,"Emma ","Ohio","Senior HR","Duplicate"]
[null,"Sarah","Ohio","IT Expert","Unique"]
[null,"Linda","Nevada","Technical Writer","Duplicate"]
[null,"Laura","Utah","Team Leader","Duplicate"]
[null,"Harris","Ohio","HR Consultant","Unique"]
[null,"Gabriel","Ohio","Receptionist","Duplicate"]
[null,"Christ","Utah","Technical Writer","Unique"]
[null,"John","Nevada","Team Leader","Duplicate"]

{"sheet":"VLOOKUP","index":3,"n_rows":15,"n_cols":5,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,4],[2,1,2,4]]}
[]
[null,"Applying the VLOOKUP Function"]
[null,"Employee Information1 Workbook"]
[null,"Employee Name","States","Designation","Duplicate or Unique?"]
[null,"Robert","Ohio","CEO",{"$f":"IF(ISERROR(VLOOKUP(B5,[1]Sheet1!$B$5:$B$15,1,0)),\"Unique\", \"Duplicate\")","v":"Unique"}]
[null,"Allen","Utah","Project Manager",{"$f":"IF(ISERROR(VLOOKUP(B6,[1]Sheet1!$B$5:$B$15,1,0)),\"Unique\", \"Duplicate\")","v":"Unique"}]
[null,"Miller","Nevada","Web Developer",{"$f":"IF(ISERROR(VLOOKUP(B7,[1]Sheet1!$B$5:$B$15,1,0)),\"Unique\", \"Duplicate\")","v":"Unique"}]
[null,"Emma ","Ohio","Senior HR",{"$f":"IF(ISERROR(VLOOKUP(B8,[1]Sheet1!$B$5:$B$15,1,0)),\"Unique\", \"Duplicate\")","v":"Duplicate"}]
[null,"Sarah","Ohio","IT Expert",{"$f":"IF(ISERROR(VLOOKUP(B9,[1]Sheet1!$B$5:$B$15,1,0)),\"Unique\", \"Duplicate\")","v":"Unique"}]
[null,"Linda","Nevada","Technical Writer",{"$f":"IF(ISERROR(VLOOKUP(B10,[1]Sheet1!$B$5:$B$15,1,0)),\"Unique\", \"Duplicate\")","v":"Duplicate"}]
[null,"Laura","Utah","Team Leader",{"$f":"IF(ISERROR(VLOOKUP(B11,[1]Sheet1!$B$5:$B$15,1,0)),\"Unique\", \"Duplicate\")","v":"Duplicate"}]
[null,"Harris","Ohio","HR Consultant",{"$f":"IF(ISERROR(VLOOKUP(B12,[1]Sheet1!$B$5:$B$15,1,0)),\"Unique\", \"Duplicate\")","v":"Unique"}]
[null,"Gabriel","Ohio","Receptionist",{"$f":"IF(ISERROR(VLOOKUP(B13,[1]Sheet1!$B$5:$B$15,1,0)),\"Unique\", \"Duplicate\")","v":"Duplicate"}]
[null,"Christ","Utah","Technical Writer",{"$f":"IF(ISERROR(VLOOKUP(B14,[1]Sheet1!$B$5:$B$15,1,0)),\"Unique\", \"Duplicate\")","v":"Unique"}]
[null,"John","Nevada","Team Leader",{"$f":"IF(ISERROR(VLOOKUP(B15,[1]Sheet1!$B$5:$B$15,1,0)),\"Unique\", \"Duplicate\")","v":"Duplicate"}]

{"sheet":"ISNUMBER & MATCH","index":4,"n_rows":15,"n_cols":5,"rows_kept":15,"cut":false,"hidden":false,"merged":[[2,1,2,3],[1,1,1,4]]}
[]
[null,"Utilizing ISNUMBER & MATCH Functions"]
[null,"Employee Information1 Workbook"]
[null,"Employee Name","States","Designation","Duplicate?"]
[null,"Robert","Ohio","CEO",{"$f":"ISNUMBER(MATCH(B5,[1]Sheet1!$B$5:$B$15,0))","v":false}]
[null,"Allen","Utah","Project Manager",{"$f":"ISNUMBER(MATCH(B6,[1]Sheet1!$B$5:$B$15,0))","v":false}]
[null,"Miller","Nevada","Web Developer",{"$f":"ISNUMBER(MATCH(B7,[1]Sheet1!$B$5:$B$15,0))","v":false}]
[null,"Emma ","Ohio","Senior HR",{"$f":"ISNUMBER(MATCH(B8,[1]Sheet1!$B$5:$B$15,0))","v":true}]
[null,"Sarah","Ohio","IT Expert",{"$f":"ISNUMBER(MATCH(B9,[1]Sheet1!$B$5:$B$15,0))","v":false}]
[null,"Linda","Nevada","Technical Writer",{"$f":"ISNUMBER(MATCH(B10,[1]Sheet1!$B$5:$B$15,0))","v":true}]
[null,"Laura","Utah","Team Leader",{"$f":"ISNUMBER(MATCH(B11,[1]Sheet1!$B$5:$B$15,0))","v":true}]
[null,"Harris","Ohio","HR Consultant",{"$f":"ISNUMBER(MATCH(B12,[1]Sheet1!$B$5:$B$15,0))","v":false}]
[null,"Gabriel","Ohio","Receptionist",{"$f":"ISNUMBER(MATCH(B13,[1]Sheet1!$B$5:$B$15,0))","v":true}]
[null,"Christ","Utah","Technical Writer",{"$f":"ISNUMBER(MATCH(B14,[1]Sheet1!$B$5:$B$15,0))","v":false}]
[null,"John","Nevada","Team Leader",{"$f":"ISNUMBER(MATCH(B15,[1]Sheet1!$B$5:$B$15,0))","v":true}]

{"sheet":"Using VBA","index":5,"n_rows":15,"n_cols":4,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,3],[2,1,2,3]]}
[]
[null,"Using the VBA Code"]
[null,"Employee Information1 Workbook"]
[null,"Employee Name","States","Designation"]
[null,"Robert","Ohio","CEO"]
[null,"Allen","Utah","Project Manager"]
[null,"Miller","Nevada","Web Developer"]
[null,"Emma ","Ohio","Senior HR"]
[null,"Sarah","Ohio","IT Expert"]
[null,"Linda","Nevada","Technical Writer"]
[null,"Laura","Utah","Team Leader"]
[null,"Harris","Ohio","HR Consultant"]
[null,"Gabriel","Ohio","Receptionist"]
[null,"Christ","Utah","Technical Writer"]
[null,"John","Nevada","Team Leader"]