{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["Dataset","Using (=) Operator","Using IF function","Using IF function (2)","Using COUNTIF","Conditional Formatting With For","Using VBA","Using LEFT","Using SUBSTITUTE","ISNUMBER and MATCH","ISNUMBER and XMATCH","ISTEXT and VLOOKUP","Conditional formatting"],"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":"Dataset","index":0,"n_rows":16,"n_cols":10,"rows_kept":16,"cut":false,"hidden":false,"merged":[[3,1,3,3],[3,5,3,7],[1,1,1,7]]}
[]
[null,"Dataset"]
[]
[null,"Bank Of America",null,null,null,"JPMorgan Chase"]
[null,"Full Name","Email_ID","Address",null,"Full Name","Email_ID","Address"]
[null,"Adam Smith","adamsmith@gmail.com","2101, Waverley ",null,"Adam Smith","adamsmith@gmail.com","2101, Waverley "]
[null,"Scott Murdock","scotmdock@gmail.com","1835, Medina",null,"Scott Murdock","scotmdock@gmail.com","1835, Medina"]
[null,"Rachel Ross","rachelross@gmail.com","105, New York",null,"Jim Carry","jimcarry@gmail.com","104 , Miami"]
[null,"Victor Rosario","victorosari@gmail.com","321, Waverley",null,"Nick Branson","nickbran@gmail.com","208 , LA"]
[null,"Kristin Moran","kristmoran@gmail.com","675, East Buena ",null,"Kristin Moran","kristmoran@gmail.com","675, East Buena "]
[null,"Julia Johnson","juliajohn@gmail.com","3500, Deer ",null,"Julia Johnson","juliajohn@gmail.com","3500, Deer "]
[null,"Elaine Gardner","elainegard@gmail.com","104 , Miami",null,"Mary Smith","marysmith@gmail.com","3201, Bahamas "]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"TRIM(E16)","v":""}]

{"sheet":"Using (=) Operator","index":1,"n_rows":16,"n_cols":10,"rows_kept":16,"cut":false,"hidden":false,"merged":[[3,4,3,5],[1,1,1,7],[3,1,3,2]]}
[]
[null,"Use of Equal Operator (=) to Compare Addresses"]
[]
[null,"Bank Of America",null,null,"JPMorgan Chase"]
[null,"Full Name","Address",null,"Full Name","Address",null,"Compare Addresses"]
[null,"Adam Smith","2101, Waverley ",null,"Adam Smith","2101, Waverley ",null,{"$f":"C6=F6","v":true}]
[null,"Scott Murdock","1835, Medina",null,"Scott Murdock","1835, Medina",null,{"$f":"C7=F7","v":true}]
[null,"Rachel Ross","105, New York",null,"Jim Carry","104 , Miami",null,false]
[null,"Victor Rosario","321, Waverley",null,"Nick Branson","208 , LA",null,false]
[null,"Kristin Moran","675, East Buena ",null,"Kristin Moran","675, East Buena ",null,true]
[null,"Julia Johnson","3500, Deer ",null,"Julia Johnson","3500, Deer ",null,true]
[null,"Elaine Gardner","104 , Miami",null,"Mary Smith","3201, Bahamas ",null,false]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"TRIM(E16)","v":""}]

{"sheet":"Using IF function","index":2,"n_rows":16,"n_cols":10,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,7],[3,1,3,2],[3,4,3,5]]}
[]
[null,"Use of IF Function to Compare Addresses"]
[]
[null,"Bank Of America",null,null,"JPMorgan Chase"]
[null,"Full Name","Address",null,"Full Name","Address",null,"Compare Addresses"]
[null,"Adam Smith","2101, Waverley ",null,"Adam Smith","2101, Waverley ",null,{"$f":"IF(C6=F6,\"Match\",\"No Match\")","v":"Match"}]
[null,"Scott Murdock","1835, Medina",null,"Scott Murdock","1835, Medina",null,{"$f":"IF(C7=F7,\"Match\",\"No Match\")","v":"Match"}]
[null,"Rachel Ross","105, New York",null,"Jim Carry","104 , Miami",null,"No Match"]
[null,"Victor Rosario","321, Waverley",null,"Nick Branson","208 , LA",null,"No Match"]
[null,"Kristin Moran","675, East Buena ",null,"Kristin Moran","675, East Buena ",null,"Match"]
[null,"Julia Johnson","3500, Deer ",null,"Julia Johnson","3500, Deer ",null,"Match"]
[null,"Elaine Gardner","104 , Miami",null,"Mary Smith","3201, Bahamas ",null,"No Match"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"TRIM(E16)","v":""}]

{"sheet":"Using IF function (2)","index":3,"n_rows":16,"n_cols":10,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,7],[3,1,3,2],[3,4,3,5]]}
[]
[null,"Overview"]
[]
[null,"Bank Of America",null,null,"JPMorgan Chase"]
[null,"Full Name","Address",null,"Full Name","Address",null,"Compare Addresses"]
[null,"Adam Smith","2101, Waverley ",null,"Adam Smith","2101, Waverley ",null,{"$f":"IF(C6=F6,\"Match\",\"No Match\")","v":"Match"}]
[null,"Scott Murdock","1835, Medina",null,"Scott Murdock","1835, Medina",null,{"$f":"IF(C7=F7,\"Match\",\"No Match\")","v":"Match"}]
[null,"Rachel Ross","105, New York",null,"Jim Carry","104 , Miami",null,"No Match"]
[null,"Victor Rosario","321, Waverley",null,"Nick Branson","208 , LA",null,"No Match"]
[null,"Kristin Moran","675, East Buena ",null,"Kristin Moran","675, East Buena ",null,"Match"]
[null,"Julia Johnson","3500, Deer ",null,"Julia Johnson","3500, Deer ",null,"Match"]
[null,"Elaine Gardner","104 , Miami",null,"Mary Smith","3201, Bahamas ",null,"No Match"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"TRIM(E16)","v":""}]

{"sheet":"Using COUNTIF","index":4,"n_rows":16,"n_cols":10,"rows_kept":16,"cut":false,"hidden":false,"merged":[[3,1,3,2],[3,4,3,5],[1,1,1,7]]}
[]
[null,"Use of COUNTIF Function to Compare Addresses"]
[]
[null,"Bank Of America",null,null,"JPMorgan Chase"]
[null,"Full Name","Email_ID",null,"Full Name","Email_ID",null,"Compare Addresses"]
[null,"Adam Smith","adamsmith@gmail.com",null,"Mary Smith","adamsmith@gmail.com",null,{"$f":"IF(COUNTIF($C$6:$C$12,F6)>0, \"Match Found\",\"No Match\")","v":"Match Found"}]
[null,"Scott Murdock","scotmdock@gmail.com",null,"Scott Murdock","scotmdock@gmail.com",null,{"$f":"IF(COUNTIF($C$6:$C$12,F7)>0, \"Match Found\",\"No Match\")","v":"Match Found"}]
[null,"Rachel Ross","rachelross@gmail.com",null,"Jim Carry","jimcarry@gmail.com",null,"No Match"]
[null,"Victor Rosario","victorosari@gmail.com",null,"Nick Branson","nickbran@gmail.com",null,"No Match"]
[null,"Kristin Moran","kristmoran@gmail.com",null,"Kristin Moran","kristmoran@gmail.com",null,"Match Found"]
[null,"Julia Johnson","juliajohn@gmail.com",null,"Julia Johnson","juliajohn@gmail.com",null,"Match Found"]
[null,"Elaine Gardner","elainegard@gmail.com",null,"Adam Smith","marysmith@gmail.com",null,"No Match"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"TRIM(E16)","v":""}]

{"sheet":"Conditional Formatting With For","index":5,"n_rows":16,"n_cols":9,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,6],[3,1,3,2],[3,4,3,5]]}
[]
[null,"Use of Conditional Formatting to Compare Addresses"]
[]
[null,"Bank Of America",null,null,"JPMorgan Chase"]
[null,"Full Name","Email_ID",null,"Full Name","Email_ID"]
[null,"Adam Smith","adamsmith@gmail.com",null,"Adam Smith","adamsmith@gmail.com"]
[null,"Scott Murdock","scotmdock@gmail.com",null,"Scott Murdock","scotmdock@gmail.com"]
[null,"Rachel Ross","rachelross@gmail.com",null,"Jim Carry","jimcarry@gmail.com"]
[null,"Victor Rosario","victorosari@gmail.com",null,"Nick Branson","nickbran@gmail.com"]
[null,"Kristin Moran","kristmoran@gmail.com",null,"Kristin Moran","kristmoran@gmail.com"]
[null,"Julia Johnson","juliajohn@gmail.com",null,"Julia Johnson","juliajohn@gmail.com"]
[null,"Elaine Gardner","elainegard@gmail.com",null,"Mary Smith","marysmith@gmail.com"]
[]
[]
[]
[null,null,null,null,null,null,null,null,{"$f":"TRIM(E16)","v":""}]

{"sheet":"Using VBA","index":6,"n_rows":12,"n_cols":16,"rows_kept":12,"cut":false,"hidden":false,"merged":[[3,1,3,2],[3,4,3,5],[4,7,4,8],[1,1,1,8]]}
[]
[null,"Use of VBA to Compare Addresses"]
[]
[null,"Bank Of America",null,null,"JPMorgan Chase"]
[null,"Full Name","Address",null,"Full Name","Address",null,"Compare Addresses"]
[null,"Adam Smith","2101, Waverley , Km",null,"Adam Smith","2101, Waverley ,km",null,{"$f":"AddressCompare(C6,F6,2)","v":0.90909090909090906},null,null,null,null,null,null,{"$f":"AddressCompare(C7,F7,2)","v":1},{"$f":"IF(AddressCompare(C6, F6, 2)>0.5, \"Full Match\", \"No Match\")","v":"Full Match"}]
[null,"Scott Murdock","1835, Medina",null,"Scott Murdock","1835, Medina",null,{"$f":"AddressCompare(C7,F7,2)","v":1},null,null,null,null,null,null,{"$f":"AddressCompare(C8,F8,2)","v":0.2857142857142857},{"$f":"IF(AddressCompare(C7, F7, 2)>0.5, \"Full Match\", \"No Match\")","v":"Full Match"}]
[null,"Rachel Ross","105, New York",null,"Jim Carry","104 , Miami",null,{"$f":"AddressCompare(C8,F8,2)","v":0.2857142857142857},null,null,null,null,null,null,{"$f":"AddressCompare(C9,F9,2)","v":0.21428571428571427},{"$f":"IF(AddressCompare(C8, F8, 2)>0.5, \"Full Match\", \"No Match\")","v":"No Match"}]
[null,"Victor Rosario","321, Waverley",null,"Nick Branson","208 , LA",null,{"$f":"AddressCompare(C9,F9,2)","v":0.21428571428571427},null,null,null,null,null,null,{"$f":"AddressCompare(C10,F10,2)","v":1},{"$f":"IF(AddressCompare(C9, F9, 2)>0.5, \"Full Match\", \"No Match\")","v":"No Match"}]
[null,"Kristin Moran","675, East Buena ",null,"Kristin Moran","675, East Buena ",null,{"$f":"AddressCompare(C10,F10,2)","v":1},null,null,null,null,null,null,{"$f":"AddressCompare(C11,F11,2)","v":1},{"$f":"IF(AddressCompare(C10, F10, 2)>0.5, \"Full Match\", \"No Match\")","v":"Full Match"}]
[null,"Julia Johnson","3500, Deer ",null,"Julia Johnson","3500, Deer ",null,{"$f":"AddressCompare(C11,F11,2)","v":1},null,null,null,null,null,null,{"$f":"AddressCompare(C12,F12,2)","v":0.41666666666666669},{"$f":"IF(AddressCompare(C11, F11, 2)>0.5, \"Full Match\", \"No Match\")","v":"Full Match"}]
[null,"Elaine Gardner","104 , Miami",null,"Mary Smith","3201, Bahamas ",null,{"$f":"AddressCompare(C12,F12,2)","v":0.41666666666666669},null,null,null,null,null,null,null,{"$f":"IF(AddressCompare(C12, F12, 2)>0.5, \"Full Match\", \"No Match\")","v":"No Match"}]

{"sheet":"Using LEFT","index":7,"n_rows":16,"n_cols":10,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,7],[3,1,3,2],[3,4,3,5]]}
[]
[null,"Use of LEFT Function to Compare Addresses"]
[]
[null,"Bank Of America",null,null,"JPMorgan Chase"]
[null,"Full Name","Email_ID",null,"Full Name","Email_ID",null,"Compare Addresses"]
[null,"Adam Smith","adamsmith@gmail.com",null,"Adam Smith","adamsmith@gmail.com",null,{"$f":"LEFT(C6,5)=LEFT(F6,5)","v":true}]
[null,"Scott Murdock","scotmdock@gmail.com",null,"Scott Murdock","scotmdock@gmail.com",null,{"$f":"LEFT(C7,5)=LEFT(F7,5)","v":true}]
[null,"Rachel Ross","rachelross@gmail.com",null,"Jim Carry","jimcarry@gmail.com",null,false]
[null,"Victor Rosario","victorosari@gmail.com",null,"Nick Branson","nickbran@gmail.com",null,false]
[null,"Kristin Moran","kristmoran@gmail.com",null,"Kristin Moran","kristmoran@gmail.com",null,true]
[null,"Julia Johnson","juliajohn@gmail.com",null,"Julia Johnson","juliajohn@gmail.com",null,true]
[null,"Elaine Gardner","elainegard@gmail.com",null,"Mary Smith","marysmith@gmail.com",null,false]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"TRIM(E16)","v":""}]

{"sheet":"Using SUBSTITUTE","index":8,"n_rows":16,"n_cols":10,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,7],[3,1,3,2],[3,4,3,5]]}
[]
[null,"Using SUBSTITUTE to Compare Addresses"]
[]
[null,"Bank Of America",null,null,"JPMorgan Chase"]
[null,"Full Name","Address",null,"Full Name","Address",null,"Compare Addresses"]
[null,"Adam Smith","2101, Waverley ",null,"Adam Smith","2101, Waverley ",null,{"$f":"(SUBSTITUTE(SUBSTITUTE(LOWER(C6),\" 2101\",\" 2\"),\" Waverly\",\" Wa\"))=SUBSTITUTE(SUBSTITUTE(LOWER(F6),\" 2101\",\" 2\"),\" Waverly\",\" Wa\")","v":true}]
[null,"Scott Murdock","1835, Medina",null,"Scott Murdock","1835, Medina",null,{"$f":"(SUBSTITUTE(SUBSTITUTE(LOWER(C7),\" 2101\",\" 2\"),\" Waverly\",\" Wa\"))=SUBSTITUTE(SUBSTITUTE(LOWER(F7),\" 2101\",\" 2\"),\" Waverly\",\" Wa\")","v":true}]
[null,"Rachel Ross","105, New York",null,"Jim Carry","104 , Miami",null,false]
[null,"Victor Rosario","321, Waverley",null,"Nick Branson","208 , LA",null,false]
[null,"Kristin Moran","675, East Buena ",null,"Kristin Moran","675, East Buena ",null,true]
[null,"Julia Johnson","3500, Deer ",null,"Julia Johnson","3500, Deer ",null,true]
[null,"Elaine Gardner","104 , Miami",null,"Mary Smith","3201, Bahamas ",null,false]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"TRIM(E16)","v":""}]

{"sheet":"ISNUMBER and MATCH","index":9,"n_rows":16,"n_cols":10,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,7],[3,1,3,2],[3,4,3,5]]}
[]
[null,"Use of ISNUMBER & MATCH to Compare Addresses"]
[]
[null,"Bank Of America",null,null,"JPMorgan Chase"]
[null,"Full Name","Address",null,"Full Name","Address",null,"Compare Addresses"]
[null,"Adam Smith","2101, Waverley ",null,"Adam Smith","2101, Waverley ",null,{"$f":"ISNUMBER(MATCH(F6, $C$6:$C$12,0))","v":true}]
[null,"Scott Murdock","1835, Medina",null,"Scott Murdock","1835, Medina",null,{"$f":"ISNUMBER(MATCH(F7, $C$6:$C$12,0))","v":true}]
[null,"Rachel Ross","105, New York",null,"Jim Carry","104 , Miami",null,true]
[null,"Victor Rosario","321, Waverley",null,"Nick Branson","208 , LA",null,false]
[null,"Kristin Moran","675, East Buena ",null,"Kristin Moran","675, East Buena ",null,true]
[null,"Julia Johnson","3500, Deer ",null,"Julia Johnson","3500, Deer ",null,true]
[null,"Elaine Gardner","104 , Miami",null,"Mary Smith","3201, Bahamas ",null,false]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"TRIM(E16)","v":""}]

{"sheet":"ISNUMBER and XMATCH","index":10,"n_rows":16,"n_cols":10,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,7],[3,1,3,2],[3,4,3,5]]}
[]
[null,"Use of ISNUMBER & XMATCH to Compare Addresses"]
[]
[null,"Bank Of America",null,null,"JPMorgan Chase"]
[null,"Full Name","Address",null,"Full Name","Address",null,"Compare Addresses"]
[null,"Adam Smith","2101, Waverley ",null,"Adam Smith","2101, Waverley ",null,{"$f":"(ISNUMBER(_xlfn.XMATCH(F6,C6:C12)))","v":true}]
[null,"Scott Murdock","1835, Medina",null,"Scott Murdock","1835, Medina",null,{"$f":"(ISNUMBER(_xlfn.XMATCH(F7,C7:C13)))","v":true}]
[null,"Rachel Ross","105, New York",null,"Jim Carry","104 , Miami",null,true]
[null,"Victor Rosario","321, Waverley",null,"Nick Branson","208 , LA",null,false]
[null,"Kristin Moran","675, East Buena ",null,"Kristin Moran","675, East Buena ",null,true]
[null,"Julia Johnson","3500, Deer ",null,"Julia Johnson","3500, Deer ",null,true]
[null,"Elaine Gardner","104 , Miami",null,"Mary Smith","3201, Bahamas ",null,false]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"TRIM(E16)","v":""}]

{"sheet":"ISTEXT and VLOOKUP","index":11,"n_rows":16,"n_cols":10,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,7],[3,1,3,2],[3,4,3,5]]}
[]
[null,"Use of ISTEXT & VLOOKUP to Compare Addresses"]
[]
[null,"Bank Of America",null,null,"JPMorgan Chase"]
[null,"Address","Full Name",null,"Full Name","Address",null,"Compare Addresses"]
[null,"2101, Waverley ","Adam Smith",null,"Adam Smith","2101, Waverley ",null,{"$f":"ISTEXT(VLOOKUP(F6,$B$6:$B$12,1,FALSE))","v":true}]
[null,"1835, Medina","Scott Murdock",null,"Scott Murdock","1835, Medina",null,{"$f":"ISTEXT(VLOOKUP(F7,$B$6:$B$12,1,FALSE))","v":true}]
[null,"105, New York","Rachel Ross",null,"Jim Carry","104 Miami",null,true]
[null,"321, Waverley","Victor Rosario",null,"Nick Branson","208 , LA",null,false]
[null,"675, East Buena ","Kristin Moran",null,"Kristin Moran","675, East Buena ",null,true]
[null,"3500, Deer ","Julia Johnson",null,"Julia Johnson","3500, Deer ",null,true]
[null,"104 Miami","Elaine Gardner",null,"Mary Smith","3201, Bahamas ",null,false]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"TRIM(E16)","v":""}]

{"sheet":"Conditional formatting","index":12,"n_rows":16,"n_cols":10,"rows_kept":16,"cut":false,"hidden":false,"merged":[[3,1,3,2],[3,4,3,5],[1,1,1,5]]}
[]
[null,"Use of Conditional Formatting to Compare Addresses"]
[]
[null,"Bank Of America",null,null,"JPMorgan Chase"]
[null,"Full Name","Address",null,"Full Name","Address"]
[null,"Adam Smith","2101, Waverley ",null,"Adam Smith","2101, Waverley "]
[null,"Scott Murdock","1835, Medina",null,"Scott Murdock","1835, Medina"]
[null,"Rachel Ross","105, New York",null,"Jim Carry","104 Miami"]
[null,"Victor Rosario","321, Waverley",null,"Nick Branson","208 , LA"]
[null,"Kristin Moran","675, East Buena ",null,"Kristin Moran","675, East Buena "]
[null,"Julia Johnson","3500, Deer ",null,"Julia Johnson","3500, Deer "]
[null,"Elaine Gardner","104 Miami",null,"Mary Smith","3201, Bahamas "]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"TRIM(E16)","v":""}]