{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Dataset","COUNTIF","Sheet1","Sheet2","SheetX","SheetY","SheetA","SheetB","SheetC","Sheet7","Sheet8"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":15,"n_cols":11,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Delete Rows Based on Another List",null,null,null,null,null,null,null,"Name","Residing State"]
[null,null,null,null,null,null,null,null,null,"Mitchel","New York"]
[null,"Name","Residing State",null,"Name to Delete",null,null,null,null,"Joanna","Arizona"]
[null,"Mitchel","New York",null,"Joanna",null,null,null,null,"Billy","Boise"]
[null,"Joanna","Arizona",null,"Jennifer",null,null,null,null,"Jennifer","Boston"]
[null,"Billy","Boise",null,"Adam",null,null,null,null,"Sophie","California"]
[null,"Jennifer","Boston",null,"Ellen",null,null,null,null,"June","Missouri"]
[null,"Sophie","California",null,null,null,null,null,null,"Michel","Maryland"]
[null,"June","Missouri",null,null,null,null,null,null,"Smith","Texas"]
[null,"Michel","Maryland",null,null,null,null,null,null,"Adam","Colorado"]
[null,"Smith","Texas",null,null,null,null,null,null,"Ellen","North Dakota"]
[null,"Adam","Colorado",null,null,null,null,null,null,"Emma","Iowa"]
[null,"Ellen","North Dakota"]
[null,"Emma","Iowa"]

{"sheet":"COUNTIF","index":1,"n_rows":15,"n_cols":15,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,11,1,14]]}
[]
[null,"Use of COUNTIF Function & Sort Option",null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Name","Residing State","Helper Column",null,"Name to Delete",null,null,null,null,null,"Name","Residing State",null,"Name to Delete"]
[null,"Mitchel","New York",{"$f":"COUNTIF($F$5:$F$8,B5)","v":0},null,"Joanna",null,null,null,null,null,"Mitchel","New York",null,"Joanna"]
[null,"Billy","Boise",0,null,"Jennifer",null,null,null,null,null,"Joanna","Arizona",null,"Jennifer"]
[null,"Sophie","California",0,null,"Adam",null,null,null,null,null,"Billy","Boise",null,"Adam"]
[null,"June","Missouri",0,null,"Ellen",null,null,null,null,null,"Jennifer","Boston",null,"Ellen"]
[null,"Michel","Maryland",0,null,null,null,null,null,null,null,"Sophie","California"]
[null,"Smith","Texas",0,null,null,null,null,null,null,null,"June","Missouri"]
[null,"Emma","Iowa",0,null,null,null,null,null,null,null,"Michel","Maryland"]
[null,null,null,null,null,null,null,null,null,null,null,"Smith","Texas"]
[null,null,null,null,null,null,null,null,null,null,null,"Adam","Colorado"]
[null,null,null,null,null,null,null,null,null,null,null,"Ellen","North Dakota"]
[null,null,null,null,null,null,null,null,null,null,null,"Emma","Iowa"]

{"sheet":"Sheet1","index":2,"n_rows":15,"n_cols":4,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"IF, ISERROR, VLOOKUP Functions & Filter Option"]
[]
[null,"Name","Residing State","Helper Column"]
[null,"Mitchel","New York",{"$f":"IF(ISERROR(VLOOKUP(B5,Sheet2!B:B,1,FALSE)),\"Keep\",\"Delete\")","v":"Keep"}]
[null,"Joanna","Arizona",{"$f":"IF(ISERROR(VLOOKUP(B6,Sheet2!B:B,1,FALSE)),\"Keep\",\"Delete\")","v":"Delete"}]
[null,"Billy","Boise",{"$f":"IF(ISERROR(VLOOKUP(B7,Sheet2!B:B,1,FALSE)),\"Keep\",\"Delete\")","v":"Keep"}]
[null,"Jennifer","Boston",{"$f":"IF(ISERROR(VLOOKUP(B8,Sheet2!B:B,1,FALSE)),\"Keep\",\"Delete\")","v":"Delete"}]
[null,"Sophie","California",{"$f":"IF(ISERROR(VLOOKUP(B9,Sheet2!B:B,1,FALSE)),\"Keep\",\"Delete\")","v":"Keep"}]
[null,"June","Missouri",{"$f":"IF(ISERROR(VLOOKUP(B10,Sheet2!B:B,1,FALSE)),\"Keep\",\"Delete\")","v":"Keep"}]
[null,"Michel","Maryland",{"$f":"IF(ISERROR(VLOOKUP(B11,Sheet2!B:B,1,FALSE)),\"Keep\",\"Delete\")","v":"Keep"}]
[null,"Smith","Texas",{"$f":"IF(ISERROR(VLOOKUP(B12,Sheet2!B:B,1,FALSE)),\"Keep\",\"Delete\")","v":"Keep"}]
[null,"Adam","Colorado",{"$f":"IF(ISERROR(VLOOKUP(B13,Sheet2!B:B,1,FALSE)),\"Keep\",\"Delete\")","v":"Delete"}]
[null,"Ellen","North Dakota",{"$f":"IF(ISERROR(VLOOKUP(B14,Sheet2!B:B,1,FALSE)),\"Keep\",\"Delete\")","v":"Delete"}]
[null,"Emma","Iowa",{"$f":"IF(ISERROR(VLOOKUP(B15,Sheet2!B:B,1,FALSE)),\"Keep\",\"Delete\")","v":"Keep"}]

{"sheet":"Sheet2","index":3,"n_rows":8,"n_cols":2,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[null,"IF, ISERROR, VLOOKUP Functions & Filter Option"]
[]
[null,"Name to Delete"]
[null,"Joanna"]
[null,"Jennifer"]
[null,"Adam"]
[null,"Ellen"]

{"sheet":"SheetX","index":4,"n_rows":15,"n_cols":4,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"IF, ISNA, MATCH Functions"]
[]
[null,"Name","Residing State","Helper Column"]
[null,"Mitchel","New York",{"$f":"IF(ISNA(MATCH(B5,SheetY!B:B, 0)),\"Keep\", \"Delete\")","v":"Keep"}]
[null,"Joanna","Arizona",{"$f":"IF(ISNA(MATCH(B6,SheetY!B:B, 0)),\"Keep\", \"Delete\")","v":"Delete"}]
[null,"Billy","Boise",{"$f":"IF(ISNA(MATCH(B7,SheetY!B:B, 0)),\"Keep\", \"Delete\")","v":"Keep"}]
[null,"Jennifer","Boston",{"$f":"IF(ISNA(MATCH(B8,SheetY!B:B, 0)),\"Keep\", \"Delete\")","v":"Delete"}]
[null,"Sophie","California",{"$f":"IF(ISNA(MATCH(B9,SheetY!B:B, 0)),\"Keep\", \"Delete\")","v":"Keep"}]
[null,"June","Missouri",{"$f":"IF(ISNA(MATCH(B10,SheetY!B:B, 0)),\"Keep\", \"Delete\")","v":"Keep"}]
[null,"Michel","Maryland",{"$f":"IF(ISNA(MATCH(B11,SheetY!B:B, 0)),\"Keep\", \"Delete\")","v":"Keep"}]
[null,"Smith","Texas",{"$f":"IF(ISNA(MATCH(B12,SheetY!B:B, 0)),\"Keep\", \"Delete\")","v":"Keep"}]
[null,"Adam","Colorado",{"$f":"IF(ISNA(MATCH(B13,SheetY!B:B, 0)),\"Keep\", \"Delete\")","v":"Delete"}]
[null,"Ellen","North Dakota",{"$f":"IF(ISNA(MATCH(B14,SheetY!B:B, 0)),\"Keep\", \"Delete\")","v":"Delete"}]
[null,"Emma","Iowa",{"$f":"IF(ISNA(MATCH(B15,SheetY!B:B, 0)),\"Keep\", \"Delete\")","v":"Keep"}]

{"sheet":"SheetY","index":5,"n_rows":8,"n_cols":2,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[null,"IF, ISNA, MATCH Functions"]
[]
[null,"Name to Delete"]
[null,"Joanna"]
[null,"Jennifer"]
[null,"Adam"]
[null,"Ellen"]

{"sheet":"SheetA","index":6,"n_rows":15,"n_cols":2,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Use of IF & COUNTIF Functions"]
[]
[null,"Name"]
[null,"Mitchel"]
[null,"Joanna"]
[null,"Billy"]
[null,"Jennifer"]
[null,"Sophie"]
[null,"June"]
[null,"Michel"]
[null,"Smith"]
[null,"Adam"]
[null,"Ellen"]
[null,"Emma"]

{"sheet":"SheetB","index":7,"n_rows":8,"n_cols":2,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Use of  IF & COUNTIF Functions"]
[]
[null,"Name to Delete"]
[null,"Joanna"]
[null,"Jennifer"]
[null,"Adam"]
[null,"Ellen"]

{"sheet":"SheetC","index":8,"n_rows":14,"n_cols":2,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[{"$f":"IF(COUNTIF(SheetA!$B:$B,SheetB!B5)>0,\"\",SheetA!B5)","v":""}]
[{"$f":"IF(COUNTIF(SheetA!$B:$B,SheetB!B6)>0,\"\",SheetA!B6)","v":""},"Use of  IF & COUNTIF Functions"]
[{"$f":"IF(COUNTIF(SheetA!$B:$B,SheetB!B7)>0,\"\",SheetA!B7)","v":""}]
[{"$f":"IF(COUNTIF(SheetA!$B:$B,SheetB!B8)>0,\"\",SheetA!B8)","v":""},{"$f":"IF(COUNTIF(SheetA!$B:$B,SheetB!B5)>0,\"\",SheetA!B5)","v":""}]
[null,{"$f":"IF(COUNTIF(SheetA!$B:$B,SheetB!B6)>0,\"\",SheetA!B6)","v":""}]
[null,{"$f":"IF(COUNTIF(SheetA!$B:$B,SheetB!B7)>0,\"\",SheetA!B7)","v":""}]
[null,{"$f":"IF(COUNTIF(SheetA!$B:$B,SheetB!B8)>0,\"\",SheetA!B8)","v":""}]
[null,{"$f":"IF(COUNTIF(SheetA!$B:$B,SheetB!B9)>0,\"\",SheetA!B9)","v":"Sophie"}]
[null,{"$f":"IF(COUNTIF(SheetA!$B:$B,SheetB!B10)>0,\"\",SheetA!B10)","v":"June"}]
[null,{"$f":"IF(COUNTIF(SheetA!$B:$B,SheetB!B11)>0,\"\",SheetA!B11)","v":"Michel"}]
[null,{"$f":"IF(COUNTIF(SheetA!$B:$B,SheetB!B12)>0,\"\",SheetA!B12)","v":"Smith"}]
[null,{"$f":"IF(COUNTIF(SheetA!$B:$B,SheetB!B13)>0,\"\",SheetA!B13)","v":"Adam"}]
[null,{"$f":"IF(COUNTIF(SheetA!$B:$B,SheetB!B14)>0,\"\",SheetA!B14)","v":"Ellen"}]
[null,{"$f":"IF(COUNTIF(SheetA!$B:$B,SheetB!B15)>0,\"\",SheetA!B15)","v":"Emma"}]

{"sheet":"Sheet7","index":9,"n_rows":8,"n_cols":2,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Name","Residing State"]
["Mitchel","New York"]
["Billy","Boise"]
["Sophie","California"]
["June","Missouri"]
["Michel","Maryland"]
["Smith","Texas"]
["Emma","Iowa"]

{"sheet":"Sheet8","index":10,"n_rows":5,"n_cols":1,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Name to Delete"]
["Joanna"]
["Jennifer"]
["Adam"]
["Ellen"]