{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Data Set","Conditional Formatting","Using EQUAL","Using If Function","Using VLOOKUP","Using IF and COUNTIF","New Rule","New Rule 2","Duplicates in Same Column","Highlighting in Same Column","Using VBA","For Pracitce"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"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":"Data Set","index":0,"n_rows":22,"n_cols":3,"rows_kept":22,"cut":false,"hidden":false,"merged":[[2,1,2,2]]}
[]
[]
[null,"Comparing Rows in Excel For Duplicates"]
[]
[null,"Starting Salary","Present Salary"]
[null,20000,30000]
[null,20000,20000]
[null,18000,20000]
[null,20000,25000]
[null,15000,15000]
[null,30000,35000]
[null,25000,35000]
[null,22000,25000]
[null,28000,30000]
[null,15000,15000]
[null,20000,20000]
[null,18000,20000]
[null,22000,25000]
[null,28000,28000]
[null,28000,30000]
[null,25000,25000]
[null,25000,28000]

{"sheet":"Conditional Formatting","index":1,"n_rows":22,"n_cols":2,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Comparing Rows in Excel For Duplicates"]
[]
[null,"First Name"]
[null,"Marlo"]
[null,"Hopkins"]
[null,"Hick"]
[null,"Thomson"]
[null,"Orwell"]
[null,"Desmond"]
[null,"Hopkins"]
[null,"Hayes"]
[null,"Hayes"]
[null,"Morris"]
[null,"Mills"]
[null,"Moyes"]
[null,"Shepherd"]
[null,"Hayes"]
[null,"Desmond"]
[null,"Marlo"]
[null,"Malik"]

{"sheet":"Using EQUAL","index":2,"n_rows":22,"n_cols":4,"rows_kept":22,"cut":false,"hidden":false,"merged":[[2,1,2,3]]}
[]
[]
[null,"Comparing Rows in Excel For Duplicates"]
[]
[null,"Starting Salary","Present Salary","Decision Column"]
[null,20000,30000,{"$f":"B6=C6","v":false}]
[null,20000,20000,{"$f":"B7=C7","v":true}]
[null,18000,20000,false]
[null,20000,25000,false]
[null,15000,15000,true]
[null,30000,35000,false]
[null,25000,35000,false]
[null,22000,25000,false]
[null,28000,30000,false]
[null,15000,15000,true]
[null,20000,20000,true]
[null,18000,20000,false]
[null,22000,25000,false]
[null,28000,28000,true]
[null,28000,30000,false]
[null,25000,25000,true]
[null,25000,28000,false]

{"sheet":"Using If Function","index":3,"n_rows":22,"n_cols":4,"rows_kept":22,"cut":false,"hidden":false,"merged":[[2,1,2,3]]}
[]
[]
[null,"Comparing Rows in Excel For Duplicates"]
[]
[null,"Starting Salary","Present Salary","Decision Column"]
[null,20000,30000,{"$f":"IF(B6=C6,\"Same\",\"Not Same\")","v":"Not Same"}]
[null,20000,20000,{"$f":"IF(B7=C7,\"Same\",\"Not Same\")","v":"Same"}]
[null,18000,20000,"Not Same"]
[null,20000,25000,"Not Same"]
[null,15000,15000,"Same"]
[null,30000,35000,"Not Same"]
[null,25000,35000,"Not Same"]
[null,22000,25000,"Not Same"]
[null,28000,30000,"Not Same"]
[null,15000,15000,"Same"]
[null,20000,20000,"Same"]
[null,18000,20000,"Not Same"]
[null,22000,25000,"Not Same"]
[null,28000,28000,"Same"]
[null,28000,30000,"Not Same"]
[null,25000,25000,"Same"]
[null,25000,28000,"Not Same"]

{"sheet":"Using VLOOKUP","index":4,"n_rows":22,"n_cols":4,"rows_kept":22,"cut":false,"hidden":false,"merged":[[2,1,2,3]]}
[]
[]
[null,"Comparing Rows in Excel For Duplicates"]
[]
[null,"Starting Salary","Present Salary","Decision Column"]
[null,20000,30000,{"$f":"IFERROR(VLOOKUP(B6,$C$6:$C$22,1,0),\"Not Found\")","v":20000}]
[null,20000,20000,{"$f":"IFERROR(VLOOKUP(B7,$C$6:$C$22,1,0),\"Not Found\")","v":20000}]
[null,18000,20000,"Not Found"]
[null,20000,25000,20000]
[null,15000,15000,15000]
[null,30000,35000,30000]
[null,25000,35000,25000]
[null,22000,25000,"Not Found"]
[null,28000,30000,28000]
[null,15000,15000,15000]
[null,20000,20000,20000]
[null,18000,20000,"Not Found"]
[null,22000,25000,"Not Found"]
[null,28000,28000,28000]
[null,28000,30000,28000]
[null,25000,25000,25000]
[null,25000,28000,25000]

{"sheet":"Using IF and COUNTIF","index":5,"n_rows":22,"n_cols":4,"rows_kept":22,"cut":false,"hidden":false,"merged":[[2,1,2,3]]}
[]
[]
[null,"Comparing Rows in Excel For Duplicates"]
[]
[null,"Starting Salary","Decision Column","Present Salary"]
[null,20000,{"$f":"IF(COUNTIF($D$6:$D$22,B6)>0,\"Match\",\"Don't Match\")","v":"Match"},30000]
[null,20000,{"$f":"IF(COUNTIF($D$6:$D$22,B7)>0,\"Match\",\"Don't Match\")","v":"Match"},20000]
[null,18000,"Don't Match",20000]
[null,20000,"Match",25000]
[null,15000,"Match",15000]
[null,30000,"Match",35000]
[null,25000,"Match",35000]
[null,22000,"Don't Match",25000]
[null,28000,"Match",30000]
[null,15000,"Match",15000]
[null,20000,"Match",20000]
[null,18000,"Don't Match",20000]
[null,22000,"Don't Match",25000]
[null,28000,"Match",28000]
[null,28000,"Match",30000]
[null,25000,"Match",25000]
[null,25000,"Match",28000]

{"sheet":"New Rule","index":6,"n_rows":22,"n_cols":3,"rows_kept":22,"cut":false,"hidden":false,"merged":[[2,1,2,2]]}
[]
[]
[null,"Comparing Rows in Excel For Duplicates"]
[]
[null,"Starting Salary","Present Salary"]
[null,20000,30000]
[null,20000,20000]
[null,18000,20000]
[null,20000,25000]
[null,15000,15000]
[null,30000,35000]
[null,25000,35000]
[null,22000,25000]
[null,28000,30000]
[null,15000,15000]
[null,20000,20000]
[null,18000,20000]
[null,22000,25000]
[null,28000,28000]
[null,28000,30000]
[null,25000,25000]
[null,25000,28000]

{"sheet":"New Rule 2","index":7,"n_rows":22,"n_cols":3,"rows_kept":22,"cut":false,"hidden":false,"merged":[[2,1,2,2]]}
[]
[]
[null,"Comparing Rows in Excel For Duplicates"]
[]
[null,"Starting Salary","Present Salary"]
[null,20000,30000]
[null,20000,20000]
[null,18000,20000]
[null,20000,25000]
[null,15000,15000]
[null,30000,35000]
[null,25000,35000]
[null,22000,25000]
[null,28000,30000]
[null,15000,15000]
[null,20000,20000]
[null,18000,20000]
[null,22000,25000]
[null,28000,28000]
[null,28000,30000]
[null,25000,25000]
[null,25000,28000]

{"sheet":"Duplicates in Same Column","index":8,"n_rows":22,"n_cols":3,"rows_kept":22,"cut":false,"hidden":false,"merged":[[2,1,2,2]]}
[]
[]
[null,"Comparing Rows in Excel For Duplicates"]
[]
[null,"First Name","Decision for First Name"]
[null,"Marlo",{"$f":"IF(COUNTIF(B$6:B$22,B6)>1,\n\"Have Duplicates\",\"Don't Have Duplicates\")","v":"Have Duplicates"}]
[null,"Hopkins",{"$f":"IF(COUNTIF(B$6:B$22,B7)>1,\n\"Have Duplicates\",\"Don't Have Duplicates\")","v":"Have Duplicates"}]
[null,"Hick",{"$f":"IF(COUNTIF(B$6:B$22,B8)>1,\n\"Have Duplicates\",\"Don't Have Duplicates\")","v":"Don't Have Duplicates"}]
[null,"Thomson",{"$f":"IF(COUNTIF(B$6:B$22,B9)>1,\n\"Have Duplicates\",\"Don't Have Duplicates\")","v":"Don't Have Duplicates"}]
[null,"Orwell",{"$f":"IF(COUNTIF(B$6:B$22,B10)>1,\n\"Have Duplicates\",\"Don't Have Duplicates\")","v":"Don't Have Duplicates"}]
[null,"Desmond",{"$f":"IF(COUNTIF(B$6:B$22,B11)>1,\n\"Have Duplicates\",\"Don't Have Duplicates\")","v":"Have Duplicates"}]
[null,"Hopkins",{"$f":"IF(COUNTIF(B$6:B$22,B12)>1,\n\"Have Duplicates\",\"Don't Have Duplicates\")","v":"Have Duplicates"}]
[null,"Hayes",{"$f":"IF(COUNTIF(B$6:B$22,B13)>1,\n\"Have Duplicates\",\"Don't Have Duplicates\")","v":"Have Duplicates"}]
[null,"Hayes",{"$f":"IF(COUNTIF(B$6:B$22,B14)>1,\n\"Have Duplicates\",\"Don't Have Duplicates\")","v":"Have Duplicates"}]
[null,"Morris",{"$f":"IF(COUNTIF(B$6:B$22,B15)>1,\n\"Have Duplicates\",\"Don't Have Duplicates\")","v":"Don't Have Duplicates"}]
[null,"Mills",{"$f":"IF(COUNTIF(B$6:B$22,B16)>1,\n\"Have Duplicates\",\"Don't Have Duplicates\")","v":"Don't Have Duplicates"}]
[null,"Moyes",{"$f":"IF(COUNTIF(B$6:B$22,B17)>1,\n\"Have Duplicates\",\"Don't Have Duplicates\")","v":"Don't Have Duplicates"}]
[null,"Shepherd",{"$f":"IF(COUNTIF(B$6:B$22,B18)>1,\n\"Have Duplicates\",\"Don't Have Duplicates\")","v":"Don't Have Duplicates"}]
[null,"Hayes",{"$f":"IF(COUNTIF(B$6:B$22,B19)>1,\n\"Have Duplicates\",\"Don't Have Duplicates\")","v":"Have Duplicates"}]
[null,"Desmond",{"$f":"IF(COUNTIF(B$6:B$22,B20)>1,\n\"Have Duplicates\",\"Don't Have Duplicates\")","v":"Have Duplicates"}]
[null,"Marlo",{"$f":"IF(COUNTIF(B$6:B$22,B21)>1,\n\"Have Duplicates\",\"Don't Have Duplicates\")","v":"Have Duplicates"}]
[null,"Malik",{"$f":"IF(COUNTIF(B$6:B$22,B22)>1,\n\"Have Duplicates\",\"Don't Have Duplicates\")","v":"Don't Have Duplicates"}]

{"sheet":"Highlighting in Same Column","index":9,"n_rows":22,"n_cols":2,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Comparing Rows in Excel For Duplicates"]
[]
[null,"First Name"]
[null,"Marlo"]
[null,"Hopkins"]
[null,"Hick"]
[null,"Thomson"]
[null,"Orwell"]
[null,"Desmond"]
[null,"Hopkins"]
[null,"Hayes"]
[null,"Hayes"]
[null,"Morris"]
[null,"Mills"]
[null,"Moyes"]
[null,"Shepherd"]
[null,"Hayes"]
[null,"Desmond"]
[null,"Marlo"]
[null,"Malik"]

{"sheet":"Using VBA","index":10,"n_rows":22,"n_cols":3,"rows_kept":22,"cut":false,"hidden":false,"merged":[[2,1,2,2]]}
[]
[]
[null,"Comparing Rows in Excel For Duplicates"]
[]
[null,"Starting Salary","Present Salary"]
[null,20000,30000]
[null,20000,20000]
[null,18000,20000]
[null,20000,25000]
[null,15000,15000]
[null,30000,35000]
[null,25000,35000]
[null,22000,25000]
[null,28000,30000]
[null,15000,15000]
[null,20000,20000]
[null,18000,20000]
[null,22000,25000]
[null,28000,28000]
[null,28000,30000]
[null,25000,25000]
[null,25000,28000]

{"sheet":"For Pracitce","index":11,"n_rows":22,"n_cols":6,"rows_kept":22,"cut":false,"hidden":false,"merged":[[2,1,2,5]]}
[]
[]
[null,"Comparing Rows in Excel For Duplicates"]
[]
[null,"First Name","Last Name",null,"Starting Salary","Present Salary"]
[null,"Marlo","Mills",null,20000,30000]
[null,"Hopkins","Shane",null,20000,20000]
[null,"Hick","Graham",null,18000,20000]
[null,"Thomson","Gregory",null,20000,25000]
[null,"Orwell","Frank",null,15000,15000]
[null,"Desmond","Mike",null,30000,35000]
[null,"Hopkins","Jennifer",null,25000,35000]
[null,"Hayes","James",null,22000,25000]
[null,"Hayes","Nathan",null,28000,30000]
[null,"Morris","Steve",null,15000,15000]
[null,"Mills","Rojer",null,20000,20000]
[null,"Moyes","Alfred",null,18000,20000]
[null,"Shepherd","David",null,22000,25000]
[null,"Hayes","Simon",null,28000,28000]
[null,"Desmond","James",null,28000,30000]
[null,"Marlo","Jennifer",null,25000,25000]
[null,"Malik","Usman",null,25000,28000]