{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["HomePage","VBA Macro"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":2,"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":"HomePage","index":0,"n_rows":18,"n_cols":3,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[null,"How to Compare Two Lists and Return Differences in Excel"]
[]
[null,"Learn to compare two lists and return differences with this free workbook. Read the article and practice yourself."]
[]
[]
[null,"Prepared By","MD Tanvir Rahman"]
[null,"Last Update","2023-10-23"]
[null,"Reviewed By","Masum Mahdy"]
[null,"Article Link","https://www.exceldemy.com/excel-compare-two-lists-and-return-differences/"]
[]
[]
[]
[null,"Copyright © 2013-2023 ExcelDemy.com | All rights reserved."]

{"sheet":"VBA Macro","index":1,"n_rows":22,"n_cols":15,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[null,"Compare Two Lists and Return Differences in Excel"]
[]
[null,"Using VBA Macro",null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"List 1","List 2",null,"Exist in List 1 but Not in List 2","Exist in List 2 but Not in List 1",null,null,null,null,"List 1","List 2",null,"Exist in List 1 but Not in List 2","Exist in List 2 but Not in List 1"]
[null,"George","Ben",null,"George","Harry",null,null,null,null,"George","Ben"]
[null,"Mike","Harry",null,"Bill","Jack",null,null,null,null,"Mike","Harry"]
[null,"Bill","Jack",null,"Chris","Mat",null,null,null,null,"Bill","Jack"]
[null,"Stephen","John",null,"Dan","Steve",null,null,null,null,"Stephen","John"]
[null,"Chris","Jordan",null,null,null,null,null,null,null,"Chris","Jordan"]
[null,"Ben","Kyle",null,null,null,null,null,null,null,"Ben","Kyle"]
[null,"Dan","Mat",null,null,null,null,null,null,null,"Dan","Mat"]
[null,"Jordan","Mike",null,null,null,null,null,null,null,"Jordan","Mike"]
[null,"Kyle","Stephen",null,null,null,null,null,null,null,"Kyle","Stephen"]
[null,"John","Steve",null,null,null,null,null,null,null,"John","Steve"]
[]
[]
[]
[]
[]
[]
[null,"Go to Home Page"]