{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Data Set","Dataset 2","Conditional Formatting","New Rule","Using EQUAL","Using EXACT","Using SEARCH","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 Two Strings for Similarity"]
[]
[null,"Football Team","Cricket Team"]
[null,"Don Marlo ","Hopkins Han"]
[null,"Reno Hopkins","Hayes Hill"]
[null,"Hick Johnson","Hayes Carry"]
[null,"Thomson Plat","Max Burner"]
[null,"Marlo Bobey","Charles Mills "]
[null,"Desmond Detroit","Julia Moyes"]
[null,"Hopkins Reno","Shepherd Hills"]
[null,"Hayes Hill","Hayes"]
[null,"Hayes Crate","Dan"]
[null,"Morris Johnson","Morris Johnson"]
[null,"Charles Mills","Malik"]
[null,"Robert Moyes","Robert Moyes"]
[null,"Sidney Shepherd","John"]
[null,"Hayes Hill","Rob Murrey"]
[null,"Das Gull","Shawn"]
[null,"Marlo Bobey","Jerry"]
[null,"Jem Malik","brock"]

{"sheet":"Dataset 2","index":1,"n_rows":22,"n_cols":2,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Comparing Two Strings for Similarity"]
[]
[null,"First Name"]
[null,"Don Marlo "]
[null,"Reno Hopkins"]
[null,"Hick Johnson"]
[null,"Thomson Plat"]
[null,"Marlo Bobey"]
[null,"Desmond Detroit"]
[null,"Hopkins Reno"]
[null,"Hayes Hill"]
[null,"Hayes Crate"]
[null,"Morris Johnson"]
[null,"Charles Mills"]
[null,"Robert Moyes"]
[null,"Sidney Shepherd"]
[null,"Hayes Hill"]
[null,"Das Gull"]
[null,"Marlo Bobey"]
[null,"Jem Malik"]

{"sheet":"Conditional Formatting","index":2,"n_rows":22,"n_cols":2,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Comparing Two Strings for Similarity"]
[]
[null,"First Name"]
[null,"Don Marlo "]
[null,"Reno Hopkins"]
[null,"Hick Johnson"]
[null,"Thomson Plat"]
[null,"Marlo Bobey"]
[null,"Desmond Detroit"]
[null,"Hopkins Reno"]
[null,"Hayes Hill"]
[null,"Hayes Crate"]
[null,"Morris Johnson"]
[null,"Charles Mills"]
[null,"Robert Moyes"]
[null,"Sidney Shepherd"]
[null,"Hayes Hill"]
[null,"Das Gull"]
[null,"Marlo Bobey"]
[null,"Jem Malik"]

{"sheet":"New Rule","index":3,"n_rows":22,"n_cols":3,"rows_kept":22,"cut":false,"hidden":false,"merged":[[2,1,2,2]]}
[]
[]
[null,"Comparing Two Strings for Similarity"]
[]
[null,"Football Team","Cricket Team"]
[null,"Don Marlo ","Hopkins Han"]
[null,"Reno Hopkins","Hayes Hill"]
[null,"Hick Johnson","Hayes Carry"]
[null,"Thomson Plat","Max Burner"]
[null,"Marlo Bobey","Charles Mills "]
[null,"Desmond Detroit","Julia Moyes"]
[null,"Hopkins Reno","Shepherd Hills"]
[null,"Hayes Hill","Hayes"]
[null,"Hayes Crate","Dan"]
[null,"Morris Johnson","Morris Johnson"]
[null,"Charles Mills","Malik"]
[null,"Robert Moyes","Robert Moyes"]
[null,"Sidney Shepherd","John"]
[null,"Hayes Hill","Rob Murrey"]
[null,"Das Gull","Shawn"]
[null,"Marlo Bobey","Jerry"]
[null,"Jem Malik","brock"]

{"sheet":"Using EQUAL","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,"Football Team","Cricket Team","Decision Column"]
[null,"Don Marlo ","Hopkins Han",{"$f":"B6=C6","v":false}]
[null,"Reno Hopkins","Hayes Hill",{"$f":"B7=C7","v":false}]
[null,"Hick Johnson","Hayes Carry",false]
[null,"Thomson Plat","Max Burner",false]
[null,"Marlo Bobey","Charles Mills ",false]
[null,"Desmond Detroit","Julia Moyes",false]
[null,"Hopkins Reno","Shepherd Hills",false]
[null,"Hayes Hill","Hayes",false]
[null,"Hayes Crate","Dan",false]
[null,"Morris Johnson","Morris Johnson",true]
[null,"Charles Mills","Malik",false]
[null,"Robert Moyes","Robert Moyes",true]
[null,"Sidney Shepherd","John",false]
[null,"Hayes Hill","Rob Murrey",false]
[null,"Das Gull","Shawn",false]
[null,"Marlo Bobey","Jerry",false]
[null,"Jem Malik","brock",false]

{"sheet":"Using EXACT","index":5,"n_rows":22,"n_cols":4,"rows_kept":22,"cut":false,"hidden":false,"merged":[[2,1,2,3]]}
[]
[]
[null,"Comparing Two Strings for Similarity"]
[]
[null,"Football Team","Cricket Team","Decision Column"]
[null,"Don Marlo ","Hopkins Han",{"$f":"EXACT(B6,C6)","v":false}]
[null,"Reno Hopkins","Hayes Hill",{"$f":"EXACT(B7,C7)","v":false}]
[null,"Hick Johnson","Hayes Carry",false]
[null,"Thomson Plat","Max Burner",false]
[null,"Marlo Bobey","Charles Mills ",false]
[null,"Desmond Detroit","Julia Moyes",false]
[null,"Hopkins Reno","Shepherd Hills",false]
[null,"Hayes Hill","Hayes",false]
[null,"Hayes Crate","Dan",false]
[null,"Morris Johnson","Morris Johnson",true]
[null,"Charles Mills","Malik",false]
[null,"Robert Moyes","Robert Moyes",true]
[null,"Sidney Shepherd","John",false]
[null,"Hayes Hill","Rob Murrey",false]
[null,"Das Gull","Shawn",false]
[null,"Marlo Bobey","Jerry",false]
[null,"Jem Malik","brock",false]

{"sheet":"Using SEARCH","index":6,"n_rows":22,"n_cols":4,"rows_kept":22,"cut":false,"hidden":false,"merged":[[2,1,2,3]]}
[]
[]
[null,"Comparing Two Strings for Similarity"]
[]
[null,"Football Team","Cricket Team","Decision Column"]
[null,"Don Marlo ","Hopkins Han",{"$f":"IFERROR(IF(SEARCH(C6,B6),\"Similar\"),\"Not Similar\")","v":"Not Similar"}]
[null,"Reno Hopkins","Hayes Hill",{"$f":"IFERROR(IF(SEARCH(C7,B7),\"Similar\"),\"Not Similar\")","v":"Not Similar"}]
[null,"Hick Johnson","Hayes Carry","Not Similar"]
[null,"Thomson Plat","Max Burner","Not Similar"]
[null,"Marlo Bobey","Charles Mills ","Not Similar"]
[null,"Desmond Detroit","Julia Moyes","Not Similar"]
[null,"Hopkins Reno","Shepherd Hills","Not Similar"]
[null,"Hayes Hill","Hayes","Similar"]
[null,"Hayes Crate","Dan","Not Similar"]
[null,"Morris Johnson","Morris Johnson","Similar"]
[null,"Charles Mills","Malik","Not Similar"]
[null,"Robert Moyes","Robert Moyes","Similar"]
[null,"Sidney Shepherd","John","Not Similar"]
[null,"Hayes Hill","Rob Murrey","Not Similar"]
[null,"Das Gull","Shawn","Not Similar"]
[null,"Marlo Bobey","Jerry","Not Similar"]
[null,"Jem Malik","brock","Not Similar"]

{"sheet":"Using VBA","index":7,"n_rows":22,"n_cols":3,"rows_kept":22,"cut":false,"hidden":false,"merged":[[2,1,2,2]]}
[]
[]
[null,"Comparing Two Strings for Similarity"]
[]
[null,"Football Team","Cricket Team"]
[null,"Don Marlo ","Hopkins Han"]
[null,"Reno Hopkins","Hayes Hill"]
[null,"Hick Johnson","Hayes Carry"]
[null,"Thomson Plat","Max Burner"]
[null,"Marlo Bobey","Charles Mills "]
[null,"Desmond Detroit","Julia Moyes"]
[null,"Hopkins Reno","Shepherd Hills"]
[null,"Hayes Hill","Hayes"]
[null,"Hayes Crate","Dan"]
[null,"Morris Johnson","Morris Johnson"]
[null,"Charles Mills","Malik"]
[null,"Robert Moyes","Robert Moyes"]
[null,"Sidney Shepherd","John"]
[null,"Hayes Hill","Rob Murrey"]
[null,"Das Gull","Shawn"]
[null,"Marlo Bobey","Jerry"]
[null,"Jem Malik","brock"]

{"sheet":"For Pracitce","index":8,"n_rows":22,"n_cols":3,"rows_kept":22,"cut":false,"hidden":false,"merged":[[2,1,2,2]]}
[]
[]
[null,"Comparing Two Strings for Similarity"]
[]
[null,"Football Team","Cricket Team"]
[null,"Don Marlo ","Hopkins Han"]
[null,"Reno Hopkins","Hayes Hill"]
[null,"Hick Johnson","Hayes Carry"]
[null,"Thomson Plat","Max Burner"]
[null,"Marlo Bobey","Charles Mills "]
[null,"Desmond Detroit","Julia Moyes"]
[null,"Hopkins Reno","Shepherd Hills"]
[null,"Hayes Hill","Hayes"]
[null,"Hayes Crate","Dan"]
[null,"Morris Johnson","Morris Johnson"]
[null,"Charles Mills","Malik"]
[null,"Robert Moyes","Robert Moyes"]
[null,"Sidney Shepherd","John"]
[null,"Hayes Hill","Rob Murrey"]
[null,"Das Gull","Shawn"]
[null,"Marlo Bobey","Jerry"]
[null,"Jem Malik","brock"]