{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["Dataset","Using (=) Operator","Using IF","Using COUNTIF","Using ISNUMBER & MATCH ","Using ISNUMBER & XMATCH","ISTEXT & VLOOKUP","Conditional Formatting","Conditional Formatting With For","Using VBA","Using LEFT","Using SUBSTITUTE","Practice Sheet1","Practice Sheet2"],"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":15,"n_cols":16,"rows_kept":15,"cut":false,"hidden":false,"merged":[[4,1,4,3],[4,5,4,7],[2,1,2,7]]}
[]
[]
[null,"Comparing Addresses"]
[]
[null,"City Bank",null,null,null,"IFIC Bank"]
[null,"Full Name","Email_ID","Address",null,"Full Name","Email_ID","Address"]
[null,"Graham Smith","grahamsmith@gmail.com","2101, California",null,"Graham Smith","grahamsmith@gmail.com","2101, California"]
[null,"Scott Murdock","scotmdock@gmail.com","1835, Medina",null,"Nick Branson","nickbran@gmail.com","208 , LA",null,null,null,"Scott Murdock"]
[null,"Rachel Roy","rachelross@gmail.com","105, New York",null,"Jim Carry","jimcarry@gmail.com","104 , Miami"]
[null,"Victor Rosario","victorosari@gmail.com","321, Waverley",null,"Scott Murdock","scotmdock@gmail.com","1835, Medina"]
[null,"Kristin More","kristmoran@gmail.com","675, East Buena ",null,"Kristin More","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,"nickbran@gmail.com"]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"TRIM(E15)","v":""}]

{"sheet":"Using (=) Operator","index":1,"n_rows":15,"n_cols":10,"rows_kept":15,"cut":false,"hidden":false,"merged":[[2,1,2,7],[4,1,4,2],[4,4,4,5],[4,7,5,7]]}
[]
[]
[null,"Addresses of Customers from Two Banks"]
[]
[null,"City Bank",null,null,"IFIC Bank",null,null,"Similar Address as City Bank ?"]
[null,"Full Name","Address",null,"Full Name","Address"]
[null,"Graham Smith","2101, California",null,"Graham Smith","2101, California",null,{"$f":"C7=F7","v":true}]
[null,"Scott Murdock","1835, Medina",null,"Nick Branson","208 , LA",null,{"$f":"C8=F8","v":false}]
[null,"Rachel Roy","105, New York",null,"Jim Carry","104 , Miami",null,false]
[null,"Victor Rosario","321, Waverley",null,"Scott Murdock","1835, Medina",null,false]
[null,"Kristin More","675, East Buena ",null,"Kristin More","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(E15)","v":""}]

{"sheet":"Using IF","index":2,"n_rows":15,"n_cols":10,"rows_kept":15,"cut":false,"hidden":false,"merged":[[2,1,2,7],[4,1,4,2],[4,4,4,5],[4,7,5,7]]}
[]
[]
[null,"Addresses of Customers from Two Banks"]
[]
[null,"City Bank",null,null,"IFIC Bank",null,null,"Comparing Addresses"]
[null,"Full Name","Address",null,"Full Name","Address"]
[null,"Graham Smith","2101, Waverley ",null,"Graham Smith","2101, Waverley ",null,{"$f":"IF(C7=F7,\"Same\",\"Different\")","v":"Same"}]
[null,"Scott Murdock","1835, Medina",null,"Nick Branson","208 , LA",null,{"$f":"IF(C8=F8,\"Same\",\"Different\")","v":"Different"}]
[null,"Rachel Roy","105, New York",null,"Jim Carry","104 , Miami",null,"Different"]
[null,"Victor Rosario","321, Waverley",null,"Scott Murdock","1835, Medina",null,"Different"]
[null,"Kristin More","675, East Buena ",null,"Kristin More","675, East Buena ",null,"Same"]
[null,"Julia Johnson","3500, Deer ",null,"Julia Johnson","3500, Deer ",null,"Same"]
[null,"Elaine Gardner","104 , Miami",null,"Mary Smith","3201, Bahamas ",null,"Different"]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"TRIM(E15)","v":""}]

{"sheet":"Using COUNTIF","index":3,"n_rows":15,"n_cols":10,"rows_kept":15,"cut":false,"hidden":false,"merged":[[2,1,2,7],[4,1,4,2],[4,4,4,5],[4,7,5,7]]}
[]
[]
[null,"Addresses of Customers from Two Banks"]
[]
[null,"City Bank",null,null,"IFIC Bank",null,null,"Comparing Addresses"]
[null,"Full Name","Email_ID",null,"Full Name","Email_ID"]
[null,"Graham Smith","grahamsmith@gmail.com",null,"Graham Smith","grahamsmith@gmail.com",null,{"$f":"IF(COUNTIF($C$7:$C$13,F7\n)>0, \"Duplicate\",\"Distinct\")","v":"Duplicate"}]
[null,"Scott Murdock","scotmdock@gmail.com",null,"Nick Branson","nickbran@gmail.com",null,{"$f":"IF(COUNTIF($C$7:$C$13,F8\n)>0, \"Duplicate\",\"Distinct\")","v":"Distinct"}]
[null,"Rachel Roy","rachelross@gmail.com",null,"Jim Carry","jimcarry@gmail.com",null,"Distinct"]
[null,"Victor Rosario","victorosari@gmail.com",null,"Scott Murdock","scotmdock@gmail.com",null,"Duplicate"]
[null,"Kristin More","kristmoran@gmail.com",null,"Kristin More","kristmoran@gmail.com",null,"Duplicate"]
[null,"Julia Johnson","juliajohn@gmail.com",null,"Julia Johnson","juliajohn@gmail.com",null,"Duplicate"]
[null,"Elaine Gardner","elainegard@gmail.com",null,"Mary Smith","marysmith@gmail.com",null,"Distinct"]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"TRIM(E15)","v":""}]

{"sheet":"Using ISNUMBER & MATCH ","index":4,"n_rows":15,"n_cols":10,"rows_kept":15,"cut":false,"hidden":false,"merged":[[2,1,2,7],[4,7,5,7],[4,1,4,2],[4,4,4,5]]}
[]
[]
[null,"Addresses of Customers from Two Banks"]
[]
[null,"City Bank",null,null,"IFIC Bank",null,null,"Similar Address as City Bank ?"]
[null,"Full Name","Address",null,"Full Name","Address"]
[null,"Graham Smith","2101, Waverley ",null,"Graham Smith","2101, Waverley ",null,{"$f":"ISNUMBER(MATCH(\nF7, $C$7:$C$13,0))","v":true}]
[null,"Scott Murdock","1835, Medina",null,"Nick Branson","208 , LA",null,{"$f":"ISNUMBER(MATCH(\nF8, $C$7:$C$13,0))","v":false}]
[null,"Rachel Roy","105, New York",null,"Jim Carry","104 , Miami",null,true]
[null,"Victor Rosario","321, Waverley",null,"Scott Murdock","1835, Medina",null,true]
[null,"Kristin More","675, East Buena ",null,"Kristin More","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(E15)","v":""}]

{"sheet":"Using ISNUMBER & XMATCH","index":5,"n_rows":15,"n_cols":10,"rows_kept":15,"cut":false,"hidden":false,"merged":[[2,1,2,7],[4,7,5,7],[4,1,4,2],[4,4,4,5]]}
[]
[]
[null,"Addresses of Customers from Two Banks"]
[]
[null,"City Bank",null,null,"IFIC Bank",null,null,"Similar Address as City Bank ?"]
[null,"Full Name","Address",null,"Full Name","Address"]
[null,"Graham Smith","2101, Waverley ",null,"Graham Smith","2101, Waverley ",null,{"$f":"(ISNUMBER(_xlfn.XMATCH(\nF7,$C$7:$C$13)))","v":true}]
[null,"Scott Murdock","1835, Medina",null,"Nick Branson","208 , LA",null,{"$f":"(ISNUMBER(_xlfn.XMATCH(\nF8,$C$7:$C$13)))","v":false}]
[null,"Rachel Roy","105, New York",null,"Jim Carry","104 , Miami",null,true]
[null,"Victor Rosario","321, Waverley",null,"Scott Murdock","1835, Medina",null,true]
[null,"Kristin More","675, East Buena ",null,"Kristin More","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(E15)","v":""}]

{"sheet":"ISTEXT & VLOOKUP","index":6,"n_rows":15,"n_cols":10,"rows_kept":15,"cut":false,"hidden":false,"merged":[[2,1,2,7],[4,7,5,7],[4,4,4,5],[4,1,4,2]]}
[]
[]
[null,"Addresses of Customers from Two Banks"]
[]
[null,"City Bank",null,null,"IFIC Bank",null,null,"Similar Address as City Bank ?"]
[null,"Full Name","Address",null,"Full Name","Address"]
[null,"Graham Smith","2101, Waverley ",null,"Graham Smith","2101, Waverley ",null,{"$f":"ISTEXT(VLOOKUP(\nF7,$C$7:$C$13,1,FALSE))","v":true}]
[null,"Scott Murdock","1835, Medina",null,"Nick Branson","208 , LA",null,{"$f":"ISTEXT(VLOOKUP(\nF8,$C$7:$C$13,1,FALSE))","v":false}]
[null,"Rachel Roy","105, New York",null,"Jim Carry","104 , Miami",null,true]
[null,"Victor Rosario","321, Waverley",null,"Scott Murdock","1835, Medina",null,true]
[null,"Kristin More","675, East Buena ",null,"Kristin More","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(E15)","v":""}]

{"sheet":"Conditional Formatting","index":7,"n_rows":15,"n_cols":10,"rows_kept":15,"cut":false,"hidden":false,"merged":[[2,1,2,5],[4,1,4,2],[4,4,4,5]]}
[]
[]
[null,"Addresses of Customers from Two Banks"]
[]
[null,"City Bank",null,null,"IFIC Bank"]
[null,"Full Name","Address",null,"Full Name","Address"]
[null,"Graham Smith","2101, Waverley ",null,"Graham Smith","2101, Waverley "]
[null,"Scott Murdock","1835, Medina",null,"Nick Branson","208 , LA"]
[null,"Rachel Roy","105, New York",null,"Jim Carry","104 , Miami"]
[null,"Victor Rosario","321, Waverley",null,"Scott Murdock","1835, Medina"]
[null,"Kristin More","675, East Buena ",null,"Kristin More","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(E15)","v":""}]

{"sheet":"Conditional Formatting With For","index":8,"n_rows":15,"n_cols":9,"rows_kept":15,"cut":false,"hidden":false,"merged":[[2,1,2,5],[4,4,4,5],[4,1,4,2]]}
[]
[]
[null,"Addresses of Customers from Two Banks"]
[]
[null,"City Bank",null,null,"IFIC Bank"]
[null,"Full Name","Email_ID",null,"Full Name","Email_ID"]
[null,"Graham Smith","grahamsmith@gmail.com",null,"Graham Smith","grahamsmith@gmail.com"]
[null,"Scott Murdock","scotmdock@gmail.com",null,"Nick Branson","nickbran@gmail.com"]
[null,"Rachel Roy","rachelross@gmail.com",null,"Jim Carry","jimcarry@gmail.com"]
[null,"Victor Rosario","victorosari@gmail.com",null,"Scott Murdock","scotmdock@gmail.com"]
[null,"Kristin More","kristmoran@gmail.com",null,"Kristin More","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(E15)","v":""}]

{"sheet":"Using VBA","index":9,"n_rows":13,"n_cols":15,"rows_kept":13,"cut":false,"hidden":false,"merged":[[4,4,4,5],[4,1,4,2],[4,7,5,8],[2,1,2,8]]}
[]
[]
[null,"Addresses of Customers from Two Banks"]
[]
[null,"City Bank",null,null,"IFIC Bank",null,null,"Compare Addresses"]
[null,"Full Name","Address",null,"Full Name","Address"]
[null,"Graham Smith","2101, Waverley ",null,"Graham Smith","2101, Waverley ",null,{"$f":"MatchAdd(C7,F7,2)","v":1},{"$f":"IF(MatchAdd(C7,F7,2)\n=1,\"Perfect Match\",\n\"Don't Match\")","v":"Perfect Match"}]
[null,"Scott Murdock","1835, Medina",null,"Nick Branson","208 , LA",null,{"$f":"MatchAdd(C8,F8,2)","v":0.23076923076923078},{"$f":"IF(MatchAdd(C8,F8,2)\n=1,\"Perfect Match\",\n\"Don't Match\")","v":"Don't Match"},null,null,null,null,null,{"$f":"IF(MatchAdd(C7,F7,2)=1,\"Perfect Match\",\"Don't Match\")","v":"Perfect Match"}]
[null,"Rachel Roy","105, New York",null,"Jim Carry","104 , Miami",null,{"$f":"MatchAdd(C9,F9,2)","v":0.2857142857142857},{"$f":"IF(MatchAdd(C9,F9,2)\n=1,\"Perfect Match\",\n\"Don't Match\")","v":"Don't Match"}]
[null,"Victor Rosario","321, Waverley",null,"Scott Murdock","1835, Medina",null,{"$f":"MatchAdd(C10,F10,2)","v":0.2857142857142857},{"$f":"IF(MatchAdd(C10,F10,2)\n=1,\"Perfect Match\",\n\"Don't Match\")","v":"Don't Match"}]
[null,"Kristin More","675, East Buena ",null,"Kristin More","675, East Buena ",null,{"$f":"MatchAdd(C11,F11,2)","v":1},{"$f":"IF(MatchAdd(C11,F11,2)\n=1,\"Perfect Match\",\n\"Don't Match\")","v":"Perfect Match"}]
[null,"Julia Johnson","3500, Deer ",null,"Julia Johnson","3500, Deer ",null,{"$f":"MatchAdd(C12,F12,2)","v":1},{"$f":"IF(MatchAdd(C12,F12,2)\n=1,\"Perfect Match\",\n\"Don't Match\")","v":"Perfect Match"}]
[null,"Elaine Gardner","104 , Miami",null,"Mary Smith","3201, Bahamas ",null,{"$f":"MatchAdd(C13,F13,2)","v":0.41666666666666669},{"$f":"IF(MatchAdd(C13,F13,2)\n=1,\"Perfect Match\",\n\"Don't Match\")","v":"Don't Match"}]

{"sheet":"Using LEFT","index":10,"n_rows":15,"n_cols":10,"rows_kept":15,"cut":false,"hidden":false,"merged":[[2,1,2,7],[4,1,4,2],[4,4,4,5],[4,7,5,7]]}
[]
[]
[null,"Addresses of Customers from Two Banks"]
[]
[null,"City Bank",null,null,"IFIC Bank",null,null,"Similar Address as City Bank ?"]
[null,"Full Name","Email_ID",null,"Full Name","Email_ID"]
[null,"Graham Smith","grahamsmith@gmail.com",null,"Graham Smith","grahamsmith@gmail.com",null,{"$f":"LEFT(C7,5)=LEFT(F7,5)","v":true}]
[null,"Scott Murdock","scotmdock@gmail.com",null,"Nick Branson","nickbran@gmail.com",null,{"$f":"LEFT(C8,5)=LEFT(F8,5)","v":false}]
[null,"Rachel Roy","rachelross@gmail.com",null,"Jim Carry","jimcarry@gmail.com",null,false]
[null,"Victor Rosario","victorosari@gmail.com",null,"Scott Murdock","scotmdock@gmail.com",null,false]
[null,"Kristin More","kristmoran@gmail.com",null,"Kristin More","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(E15)","v":""}]

{"sheet":"Using SUBSTITUTE","index":11,"n_rows":15,"n_cols":10,"rows_kept":15,"cut":false,"hidden":false,"merged":[[2,1,2,7],[4,4,4,5],[4,1,4,2],[4,7,5,7]]}
[]
[]
[null,"Addresses of Customers from Two Banks"]
[]
[null,"City Bank",null,null,"IFIC Bank",null,null,"Similar Address as City Bank ?"]
[null,"Full Name","Address",null,"Full Name","Address"]
[null,"Graham Smith","2101, Waverley ",null,"Graham Smith","2101, Waverley ",null,{"$f":"(SUBSTITUTE(SUBSTITUTE(\nLOWER(C7),\" 2101\",\" 2\"),\" \nWaverly\",\" Wa\"))=SUBSTITUTE(\nSUBSTITUTE(LOWER(F7\n),\" 2101\",\" 2\"),\" Waverly\",\" Wa\")","v":true}]
[null,"Scott Murdock","1835, Medina",null,"Nick Branson","208 , LA",null,{"$f":"(SUBSTITUTE(SUBSTITUTE(\nLOWER(C8),\" 2101\",\" 2\"),\" \nWaverly\",\" Wa\"))=SUBSTITUTE(\nSUBSTITUTE(LOWER(F8\n),\" 2101\",\" 2\"),\" Waverly\",\" Wa\")","v":false}]
[null,"Rachel Roy","105, New York",null,"Jim Carry","104 , Miami",null,false]
[null,"Victor Rosario","321, Waverley",null,"Scott Murdock","1835, Medina",null,false]
[null,"Kristin More","675, East Buena ",null,"Kristin More","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(E15)","v":""}]

{"sheet":"Practice Sheet1","index":12,"n_rows":15,"n_cols":10,"rows_kept":15,"cut":false,"hidden":false,"merged":[[2,1,2,7],[4,1,4,2],[4,4,4,5],[4,7,5,7]]}
[]
[]
[null,"Comparing Addresses"]
[]
[null,"City Bank",null,null,"IFIC Bank",null,null,"Compare Addresses"]
[null,"Full Name","Address",null,"Full Name","Address"]
[null,"Graham Smith","2101, Waverley ",null,"Graham Smith","2101, Waverley "]
[null,"Scott Murdock","1835, Medina",null,"Nick Branson","208 , LA"]
[null,"Rachel Roy","105, New York",null,"Jim Carry","104 , Miami"]
[null,"Victor Rosario","321, Waverley",null,"Scott Murdock","1835, Medina"]
[null,"Kristin More","675, East Buena ",null,"Kristin More","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(E15)","v":""}]

{"sheet":"Practice Sheet2","index":13,"n_rows":15,"n_cols":10,"rows_kept":15,"cut":false,"hidden":false,"merged":[[2,1,2,7],[4,1,4,2],[4,4,4,5],[4,7,5,7]]}
[]
[]
[null,"Comparing Addresses"]
[]
[null,"City Bank",null,null,"IFIC Bank",null,null,"Compare Addresses"]
[null,"Full Name","Email_ID",null,"Full Name","Email_ID"]
[null,"Graham Smith","grahamsmith@gmail.com",null,"Graham Smith","grahamsmith@gmail.com"]
[null,"Scott Murdock","scotmdock@gmail.com",null,"Nick Branson","nickbran@gmail.com"]
[null,"Rachel Roy","rachelross@gmail.com",null,"Jim Carry","jimcarry@gmail.com"]
[null,"Victor Rosario","victorosari@gmail.com",null,"Scott Murdock","scotmdock@gmail.com"]
[null,"Kristin More","kristmoran@gmail.com",null,"Kristin More","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,null,{"$f":"TRIM(E15)","v":""}]