{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Dataset","Highlight","Find_Matches","Extract Unique Data","sheet1","sheet2","Practice Sheet"],"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":10,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,2,0,6],[2,1,2,3],[2,5,2,7]]}
[null,null,"Excel Macro to Compare Two Columns"]
[]
[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 Street",null,"Mary Smith","marysmith@gmail.com","3201 Bahamas Street"]
[null,"Scott Murdock","scotmdock@gmail.com","1835  NE, Medina",null,"Scott Murdock","scotmdock@gmail.com","1835  NE, Medina"]
[null,"Rachel Ross","rachelross@gmail.com","105,TS, New York",null,"Jim Carry","jimcarry@gmail.com","104 Miami,Florida"]
[null,"Victor Rosario","victorosari@gmail.com","321 Waverley Street",null,"Nick Branson","nickbranson@gmail.com","208 , Los Angele"]
[null,"Kristin Moran","kristinmoran@gmail.com","675 East Buena Vista ",null,"Kristin Moran","kristinmoran@gmail.com","675 East Buena Vista "]
[null,"Julia Johnson","juliajohn@gmail.com","3500 Deer , Palo Alto",null,"Julia Johnson","juliajohn@gmail.com","3500 Deer , Palo Alto"]
[null,"Elaine Gardner","elainegard@gmail.com","104 Miami,Florida",null,"Adam Smith","adamsmith@gmail.com","2101 Waverley Street"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"TRIM(E15)","v":""}]

{"sheet":"Highlight","index":1,"n_rows":15,"n_cols":7,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,1,0,5],[1,1,1,2],[1,4,1,5]]}
[null,"Excel Macro to Compare Two Columns"]
[null,"Bank Of America",null,null,"JPMorgan Chase"]
[null,"Full Name","Full Name",null,"Address","Address"]
[null,"Adam Smith","Mary Smith",null,"3201 Bahamas Street","2101 Waverley Street"]
[null,"Scott Murdock","Scott Murdock",null,"1835  NE, Medina","1835  NE, Medina"]
[null,"Rachel Ross","Jim Carry",null,"104 Miami,Florida","105,TS, New York"]
[null,"Victor Rosario","Nick Branson",null,"208 , Los Angele","321 Waverley Street"]
[null,"Kristin Moran","Kristin Moran",null,"675 East Buena Vista ","675 East Buena Vista "]
[null,"Julia Johnson","Julia Johnson",null,"3500 Deer , Palo Alto","3500 Deer , Palo Alto"]
[null,"Elaine Gardner","Adam Smith",null,"2101 Waverley Street","104 Miami,Florida"]
[]
[]
[]
[]
[null,null,null,null,null,null,{"$f":"TRIM(C11)","v":""}]

{"sheet":"Find_Matches","index":2,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[[2,1,2,2],[2,4,2,5],[0,1,0,5]]}
[null,"Excel Macro to Compare Two Columns"]
[]
[null,"Bank Of America",null,null,"JPMorgan Chase"]
[null,"Full Name","Email_ID","Matches","Full Name","Email_ID"]
[null,"Adam Smith","adamsmith@gmail.com","adamsmith@gmail.com","Mary Smith","marysmith@gmail.com"]
[null,"Scott Murdock","scotmdock@gmail.com","scotmdock@gmail.com","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","nickbranson@gmail.com"]
[null,"Kristin Moran","kristinmoran@gmail.com","kristinmoran@gmail.com","Kristin Moran","kristinmoran@gmail.com"]
[null,"Julia Johnson","juliajohn@gmail.com","juliajohn@gmail.com","Julia Johnson","juliajohn@gmail.com"]
[null,"Elaine Gardner","elainegard@gmail.com",null,"Adam Smith","adamsmith@gmail.com"]

{"sheet":"Extract Unique Data","index":3,"n_rows":15,"n_cols":10,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[null,"Full Name","Address","Unique Name","Unique Address","Full Name","Address"]
[null,"Adam Smith","2101 Waverley Street","Rachel Ross","105,TS, New York","Mary Smith","3201 Bahamas Street"]
[null,"Scott Murdock","1835  NE, Medina","Victor Rosario","321 Waverley Street","Scott Murdock","1835  NE, Medina"]
[null,"Rachel Ross","105,TS, New York","Elaine Gardner",null,"Jim Carry","104 Miami,Florida"]
[null,"Victor Rosario","321 Waverley Street",null,null,"Nick Branson","208 , Los Angele"]
[null,"Kristin Moran","675 East Buena Vista ",null,null,"Kristin Moran","675 East Buena Vista "]
[null,"Julia Johnson","3500 Deer , Palo Alto",null,null,"Julia Johnson","3500 Deer , Palo Alto"]
[null,"Elaine Gardner","104 Miami,Florida",null,null,"Adam Smith","2101 Waverley Street"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"TRIM(F12)","v":""}]

{"sheet":"sheet1","index":4,"n_rows":15,"n_cols":9,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[null,"Full Name","Email_ID"]
[null,"Adam Smith","adamsmith@gmail.com"]
[null,"Scott Murdock","scotmdock@gmail.com"]
[null,"Rachel Ross","rachelross@gmail.com"]
[null,"Victor Rosario","victorosari@gmail.com"]
[null,"Kristin Moran","kristinmoran@gmail.com"]
[null,"Julia Johnson","juliajohn@gmail.com"]
[null,"Elaine Gardner","elainegard@gmail.com"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,{"$f":"TRIM(E15)","v":""}]

{"sheet":"sheet2","index":5,"n_rows":15,"n_cols":9,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[null,"Full Name","Email_ID"]
[null,"Adam Smith","adamsmith@gmail.com"]
[null,"Scott Murdock","scotmdock@gmail.com"]
[null,"Jim Carry","jimcarry@gmail.com"]
[null,"Nick Branson","nickbranson@gmail.com"]
[null,"Kristin Moran","kristinmoran@gmail.com"]
[null,"Julia Johnson","juliajohn@gmail.com"]
[null,"Mary Smith","marysmith@gmail.com"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,{"$f":"TRIM(E15)","v":""}]

{"sheet":"Practice Sheet","index":6,"n_rows":15,"n_cols":10,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,2,0,6],[2,1,2,3],[2,5,2,7]]}
[null,null,"Excel Macro to Compare Two Columns"]
[]
[null,"Bank Of America",null,null,null,"JPMorgan Chase"]
[null,"Full Name","Email_ID","Address","Compare","Full Name","Email_ID","Address"]
[null,"Adam Smith","adamsmith@gmail.com","2101 Waverley Street",null,"Mary Smith","marysmith@gmail.com","3201 Bahamas Street"]
[null,"Scott Murdock","scotmdock@gmail.com","1835  NE, Medina",null,"Scott Murdock","scotmdock@gmail.com","1835  NE, Medina"]
[null,"Rachel Ross","rachelross@gmail.com","105,TS, New York",null,"Jim Carry","jimcarry@gmail.com","104 Miami,Florida"]
[null,"Victor Rosario","victorosari@gmail.com","321 Waverley Street",null,"Nick Branson","nickbranson@gmail.com","208 , Los Angele"]
[null,"Kristin Moran","kristinmoran@gmail.com","675 East Buena Vista ",null,"Kristin Moran","kristinmoran@gmail.com","675 East Buena Vista "]
[null,"Julia Johnson","juliajohn@gmail.com","3500 Deer , Palo Alto",null,"Julia Johnson","juliajohn@gmail.com","3500 Deer , Palo Alto"]
[null,"Elaine Gardner","elainegard@gmail.com","104 Miami,Florida",null,"Adam Smith","adamsmith@gmail.com","2101 Waverley Street"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"TRIM(E15)","v":""}]