{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Dataset 2021","Dataset2022","Logic","Exact","IF","VLOOKUP","Conditional","VBA","Duplicates","Count","Remove Duplicate"],"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 2021","index":0,"n_rows":15,"n_cols":3,"rows_kept":15,"cut":false,"hidden":false,"merged":[[2,1,2,2]]}
[]
[]
[null,"Top Seller 2021"]
[]
[null,"Ranking","Name"]
[null,1,"Margery"]
[null,2,"Danerys"]
[null,3,"Cersei"]
[null,4,"John"]
[null,5,"Tyrion"]
[null,6,"Arya"]
[null,7,"Sansa"]
[null,8,"Melisandre"]
[null,9,"Rob"]
[null,10,"Sam"]

{"sheet":"Dataset2022","index":1,"n_rows":15,"n_cols":3,"rows_kept":15,"cut":false,"hidden":false,"merged":[[2,1,2,2]]}
[]
[]
[null,"Top Seller 2022"]
[]
[null,"Ranking","Name"]
[null,1,"Cersei"]
[null,2,"Danerys"]
[null,3,"Margery"]
[null,4,"Snow"]
[null,5,"Tyrion"]
[null,6,"Arya"]
[null,7,"Sansa"]
[null,8,"Yigritte"]
[null,9,"Rob"]
[null,10,"Sam"]

{"sheet":"Logic","index":2,"n_rows":15,"n_cols":4,"rows_kept":15,"cut":false,"hidden":false,"merged":[[2,1,2,3]]}
[]
[]
[null,"Top Seller 2022"]
[]
[null,"Ranking","Name","Statement"]
[null,1,"Cersei",{"$f":"C6='Dataset 2021'!C6","v":false}]
[null,2,"Danerys",{"$f":"C7='Dataset 2021'!C7","v":true}]
[null,3,"Margery",{"$f":"C8='Dataset 2021'!C8","v":false}]
[null,4,"Snow",{"$f":"C9='Dataset 2021'!C9","v":false}]
[null,5,"Tyrion",{"$f":"C10='Dataset 2021'!C10","v":true}]
[null,6,"Arya",{"$f":"C11='Dataset 2021'!C11","v":true}]
[null,7,"Sansa",{"$f":"C12='Dataset 2021'!C12","v":true}]
[null,8,"Yigritte",{"$f":"C13='Dataset 2021'!C13","v":false}]
[null,9,"Rob",{"$f":"C14='Dataset 2021'!C14","v":true}]
[null,10,"Sam",{"$f":"C15='Dataset 2021'!C15","v":true}]

{"sheet":"Exact","index":3,"n_rows":15,"n_cols":4,"rows_kept":15,"cut":false,"hidden":false,"merged":[[2,1,2,3]]}
[]
[]
[null,"Top Seller 2022"]
[]
[null,"Ranking","Name","Statement"]
[null,1,"Cersei",{"$f":"EXACT(C6,'Dataset 2021'!C6)","v":false}]
[null,2,"Danerys",{"$f":"EXACT(C7,'Dataset 2021'!C7)","v":true}]
[null,3,"Margery",{"$f":"EXACT(C8,'Dataset 2021'!C8)","v":false}]
[null,4,"Snow",{"$f":"EXACT(C9,'Dataset 2021'!C9)","v":false}]
[null,5,"Tyrion",{"$f":"EXACT(C10,'Dataset 2021'!C10)","v":true}]
[null,6,"Arya",{"$f":"EXACT(C11,'Dataset 2021'!C11)","v":true}]
[null,7,"Sansa",{"$f":"EXACT(C12,'Dataset 2021'!C12)","v":true}]
[null,8,"Yigritte",{"$f":"EXACT(C13,'Dataset 2021'!C13)","v":false}]
[null,9,"Rob",{"$f":"EXACT(C14,'Dataset 2021'!C14)","v":true}]
[null,10,"Sam",{"$f":"EXACT(C15,'Dataset 2021'!C15)","v":true}]

{"sheet":"IF","index":4,"n_rows":15,"n_cols":4,"rows_kept":15,"cut":false,"hidden":false,"merged":[[2,1,2,3]]}
[]
[]
[null,"Top Seller 2022"]
[]
[null,"Ranking","Name","Statement"]
[null,1,"Cersei",{"$f":"IF(C6='Dataset 2021'!C6, \"Match\",\"Mismatch\")","v":"Mismatch"}]
[null,2,"Danerys",{"$f":"IF(C7='Dataset 2021'!C7, \"Match\",\"Mismatch\")","v":"Match"}]
[null,3,"Margery",{"$f":"IF(C8='Dataset 2021'!C8, \"Match\",\"Mismatch\")","v":"Mismatch"}]
[null,4,"Snow",{"$f":"IF(C9='Dataset 2021'!C9, \"Match\",\"Mismatch\")","v":"Mismatch"}]
[null,5,"Tyrion",{"$f":"IF(C10='Dataset 2021'!C10, \"Match\",\"Mismatch\")","v":"Match"}]
[null,6,"Arya",{"$f":"IF(C11='Dataset 2021'!C11, \"Match\",\"Mismatch\")","v":"Match"}]
[null,7,"Sansa",{"$f":"IF(C12='Dataset 2021'!C12, \"Match\",\"Mismatch\")","v":"Match"}]
[null,8,"Yigritte",{"$f":"IF(C13='Dataset 2021'!C13, \"Match\",\"Mismatch\")","v":"Mismatch"}]
[null,9,"Rob",{"$f":"IF(C14='Dataset 2021'!C14, \"Match\",\"Mismatch\")","v":"Match"}]
[null,10,"Sam",{"$f":"IF(C15='Dataset 2021'!C15, \"Match\",\"Mismatch\")","v":"Match"}]

{"sheet":"VLOOKUP","index":5,"n_rows":15,"n_cols":4,"rows_kept":15,"cut":false,"hidden":false,"merged":[[2,1,2,3]]}
[]
[]
[null,"Top Seller 2022"]
[]
[null,"Ranking","Name","Statement"]
[null,1,"Cersei",{"$f":"IF(ISNA(VLOOKUP(C6,'Dataset 2021'!$C$6:$C$15,1,FALSE)),\"Mismatch\",\"Match\")","v":"Match"}]
[null,2,"Danerys",{"$f":"IF(ISNA(VLOOKUP(C7,'Dataset 2021'!$C$6:$C$15,1,FALSE)),\"MisMatch\",\"Match\")","v":"Match"}]
[null,3,"Margery",{"$f":"IF(ISNA(VLOOKUP(C8,'Dataset 2021'!$C$6:$C$15,1,FALSE)),\"MisMatch\",\"Match\")","v":"Match"}]
[null,4,"Snow",{"$f":"IF(ISNA(VLOOKUP(C9,'Dataset 2021'!$C$6:$C$15,1,FALSE)),\"MisMatch\",\"Match\")","v":"MisMatch"}]
[null,5,"Tyrion",{"$f":"IF(ISNA(VLOOKUP(C10,'Dataset 2021'!$C$6:$C$15,1,FALSE)),\"MisMatch\",\"Match\")","v":"Match"}]
[null,6,"Arya",{"$f":"IF(ISNA(VLOOKUP(C11,'Dataset 2021'!$C$6:$C$15,1,FALSE)),\"MisMatch\",\"Match\")","v":"Match"}]
[null,7,"Sansa",{"$f":"IF(ISNA(VLOOKUP(C12,'Dataset 2021'!$C$6:$C$15,1,FALSE)),\"MisMatch\",\"Match\")","v":"Match"}]
[null,8,"Yigritte",{"$f":"IF(ISNA(VLOOKUP(C13,'Dataset 2021'!$C$6:$C$15,1,FALSE)),\"MisMatch\",\"Match\")","v":"MisMatch"}]
[null,9,"Rob",{"$f":"IF(ISNA(VLOOKUP(C14,'Dataset 2021'!$C$6:$C$15,1,FALSE)),\"MisMatch\",\"Match\")","v":"Match"}]
[null,10,"Sam",{"$f":"IF(ISNA(VLOOKUP(C15,'Dataset 2021'!$C$6:$C$15,1,FALSE)),\"MisMatch\",\"Match\")","v":"Match"}]

{"sheet":"Conditional","index":6,"n_rows":15,"n_cols":3,"rows_kept":15,"cut":false,"hidden":false,"merged":[[2,1,2,2]]}
[]
[]
[null,"Top Seller 2022"]
[]
[null,"Ranking","Name"]
[null,1,"Cersei"]
[null,2,"Danerys"]
[null,3,"Margery"]
[null,4,"Snow"]
[null,5,"Tyrion"]
[null,6,"Arya"]
[null,7,"Sansa"]
[null,8,"Yigritte"]
[null,9,"Rob"]
[null,10,"Sam"]

{"sheet":"VBA","index":7,"n_rows":15,"n_cols":3,"rows_kept":15,"cut":false,"hidden":false,"merged":[[2,1,2,2]]}
[]
[]
[null,"Top Seller 2022"]
[]
[null,"Ranking","Name"]
[null,1,"Cersei"]
[null,2,"Danerys"]
[null,3,"Margery"]
[null,4,"Snow"]
[null,5,"Tyrion"]
[null,6,"Arya"]
[null,7,"Sansa"]
[null,8,"Yigritte"]
[null,9,"Rob"]
[null,10,"Sam"]

{"sheet":"Duplicates","index":8,"n_rows":15,"n_cols":3,"rows_kept":15,"cut":false,"hidden":false,"merged":[[2,1,2,2]]}
[]
[]
[null,"Top Seller 2022"]
[]
[null,"Ranking","Name"]
[null,1,"Cersei"]
[null,2,"Danerys"]
[null,3,"Margery"]
[null,4,"Snow"]
[null,5,"Tyrion"]
[null,6,"Arya"]
[null,7,"Sansa"]
[null,8,"Yigritte"]
[null,9,"Rob"]
[null,10,"Sam"]

{"sheet":"Count","index":9,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Top seller 2021","Top seller 2021",null,"Match",{"$f":"SUMPRODUCT(--(B4:B13=C4:C13))","v":6}]
[null,"Margery","Cersei",null,"Mismatch",{"$f":"SUM(--(B4:B13<>C4:C13))","v":4}]
[null,"Danerys","Danerys"]
[null,"Cersei","Margery"]
[null,"John","Snow"]
[null,"Tyrion","Tyrion"]
[null,"Arya","Arya"]
[null,"Sansa","Sansa"]
[null,"Melisandre","Yigritte"]
[null,"Rob","Rob"]
[null,"Sam","Sam"]

{"sheet":"Remove Duplicate","index":10,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Top seller 2021","Top seller 2021"]
[null,"Margery","Cersei"]
[null,"Danerys","Danerys"]
[null,"Cersei","Margery"]
[null,"John","Snow"]
[null,"Tyrion","Tyrion"]
[null,"Arya","Arya"]
[null,"Sansa","Sansa"]
[null,"Melisandre","Yigritte"]
[null,"Rob","Rob"]
[null,"Sam","Sam"]