{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["EXACT Function","Boolean Logic","IF","Formatting with Formula","VBA","Conditional Formatting","IF+COUNTIF","ISERROR+VLOOKUP"],"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":"EXACT Function","index":0,"n_rows":12,"n_cols":8,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,5,1,7]]}
[]
[null,"Use of EXACT Function",null,null,null,"Try Yourself"]
[]
[null,"March","April","Remark",null,"March","April","Remark"]
[null,"Goodnight Moon","A Promised Land",{"$f":"EXACT(B5,C5)","v":false},null,"Goodnight Moon","A Promised Land"]
[null,"Midnight Sun","Midnight Sun",{"$f":"EXACT(B6,C6)","v":true},null,"Midnight Sun","Midnight Sun"]
[null,"A Promised Land","Untamed",false,null,"A Promised Land","Untamed"]
[null,"Greenlights","Becoming",false,null,"Greenlights","Becoming"]
[null,"Fear No Evil","Rage",false,null,"Fear No Evil","Rage"]
[null,"Caste","Caste",true,null,"Caste","Caste"]
[null,"American Dirt","Greenlights",false,null,"American Dirt","Greenlights"]
[null,"Untamed","American Dirt",false,null,"Untamed","American Dirt"]

{"sheet":"Boolean Logic","index":1,"n_rows":12,"n_cols":8,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,5,1,7]]}
[]
[null,"Use of Boolean Logic",null,null,null,"Try Yourself"]
[]
[null,"March","April","Remark",null,"March","April","Remark"]
[null,"Goodnight Moon","A Promised Land",{"$f":"B5<>C5","v":true},null,"Goodnight Moon","A Promised Land"]
[null,"Midnight Sun","Midnight Sun",{"$f":"B6<>C6","v":false},null,"Midnight Sun","Midnight Sun"]
[null,"A Promised Land","Untamed",true,null,"A Promised Land","Untamed"]
[null,"Greenlights","Becoming",true,null,"Greenlights","Becoming"]
[null,"Fear No Evil","Rage",true,null,"Fear No Evil","Rage"]
[null,"Caste","Caste",false,null,"Caste","Caste"]
[null,"American Dirt","Greenlights",true,null,"American Dirt","Greenlights"]
[null,"Untamed","American Dirt",true,null,"Untamed","American Dirt"]

{"sheet":"IF","index":2,"n_rows":12,"n_cols":8,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,5,1,7]]}
[]
[null,"Use of IF Function",null,null,null,"Try Yourself"]
[]
[null,"March","April","Remark",null,"March","April","Remark"]
[null,"Goodnight Moon","A Promised Land",{"$f":"IF(B5<>C5,\"Unique\",\"Similar\")","v":"Unique"},null,"Goodnight Moon","A Promised Land"]
[null,"Midnight Sun","Midnight Sun",{"$f":"IF(B6<>C6,\"Unique\",\"Similar\")","v":"Similar"},null,"Midnight Sun","Midnight Sun"]
[null,"A Promised Land","Untamed","Unique",null,"A Promised Land","Untamed"]
[null,"Greenlights","Becoming","Unique",null,"Greenlights","Becoming"]
[null,"Fear No Evil","Rage","Unique",null,"Fear No Evil","Rage"]
[null,"Caste","Caste","Similar",null,"Caste","Caste"]
[null,"American Dirt","Greenlights","Unique",null,"American Dirt","Greenlights"]
[null,"Untamed","American Dirt","Unique",null,"Untamed","American Dirt"]

{"sheet":"Formatting with Formula","index":3,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,4,1,5]]}
[]
[null,"Use of Conditional Formatting with Formula",null,null,"Try Yourself"]
[]
[null,"March","April",null,"March","April"]
[null,"Goodnight Moon","A Promised Land",null,"Goodnight Moon","A Promised Land"]
[null,"Midnight Sun","Midnight Sun",null,"Midnight Sun","Midnight Sun"]
[null,"A Promised Land","Untamed",null,"A Promised Land","Untamed"]
[null,"Greenlights","Becoming",null,"Greenlights","Becoming"]
[null,"Fear No Evil","Rage",null,"Fear No Evil","Rage"]
[null,"Caste","Caste",null,"Caste","Caste"]
[null,"American Dirt","Greenlights",null,"American Dirt","Greenlights"]
[null,"Untamed","American Dirt",null,"Untamed","American Dirt"]

{"sheet":"VBA","index":4,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,4,1,5]]}
[]
[null,"Use of VBA",null,null,"Try Yourself"]
[]
[null,"March","April",null,"March","April"]
[null,"Goodnight Moon","A Promised Land",null,"Goodnight Moon","A Promised Land"]
[null,"Midnight Sun","Midnight Sun",null,"Midnight Sun","Midnight Sun"]
[null,"A Promised Land","Untamed",null,"A Promised Land","Untamed"]
[null,"Greenlights","Becoming",null,"Greenlights","Becoming"]
[null,"Fear No Evil","Rage",null,"Fear No Evil","Rage"]
[null,"Caste","Caste",null,"Caste","Caste"]
[null,"American Dirt","Greenlights",null,"American Dirt","Greenlights"]
[null,"Untamed","American Dirt",null,"Untamed","American Dirt"]

{"sheet":"Conditional Formatting","index":5,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,4,1,5]]}
[]
[null,"Use of Conditional Formatting",null,null,"Try Yourself"]
[]
[null,"March","April",null,"March","April"]
[null,"Goodnight Moon","A Promised Land",null,"Goodnight Moon","A Promised Land"]
[null,"Midnight Sun","Midnight Sun",null,"Midnight Sun","Midnight Sun"]
[null,"A Promised Land","Untamed",null,"A Promised Land","Untamed"]
[null,"Greenlights","Becoming",null,"Greenlights","Becoming"]
[null,"Fear No Evil","Rage",null,"Fear No Evil","Rage"]
[null,"Caste","Caste",null,"Caste","Caste"]
[null,"American Dirt","Greenlights",null,"American Dirt","Greenlights"]
[null,"Untamed","American Dirt",null,"Untamed","American Dirt"]

{"sheet":"IF+COUNTIF","index":6,"n_rows":12,"n_cols":8,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,5,1,7]]}
[]
[null,"Use of IF+COUNTIF Functions",null,null,null,"Try Yourself"]
[]
[null,"March","April","Remark",null,"March","April","Remark"]
[null,"Goodnight Moon","A Promised Land",{"$f":"IF(COUNTIF($C$5:$C$12,$B5)=0,\"No match in C\",\"Match in C\")","v":"No match in C"},null,"Goodnight Moon","A Promised Land"]
[null,"Midnight Sun","Midnight Sun",{"$f":"IF(COUNTIF($C$5:$C$12,$B6)=0,\"No match in C\",\"Match in C\")","v":"Match in C"},null,"Midnight Sun","Midnight Sun"]
[null,"A Promised Land","Untamed","Match in C",null,"A Promised Land","Untamed"]
[null,"Greenlights","Becoming","Match in C",null,"Greenlights","Becoming"]
[null,"Fear No Evil","Rage","No match in C",null,"Fear No Evil","Rage"]
[null,"Caste","Caste","Match in C",null,"Caste","Caste"]
[null,"American Dirt","Greenlights","Match in C",null,"American Dirt","Greenlights"]
[null,"Untamed","American Dirt","Match in C",null,"Untamed","American Dirt"]

{"sheet":"ISERROR+VLOOKUP","index":7,"n_rows":12,"n_cols":8,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,5,1,7]]}
[]
[null,"Use of ISERROR+VLOOKUP Functions",null,null,null,"Try Yourself"]
[]
[null,"March","April","Remark",null,"March","April","Remark"]
[null,"Goodnight Moon","A Promised Land",{"$f":"ISERROR(VLOOKUP(B5,$C$5:$C$12,1,0))","v":true},null,"Goodnight Moon","A Promised Land"]
[null,"Midnight Sun","Midnight Sun",{"$f":"ISERROR(VLOOKUP(B6,$C$5:$C$12,1,0))","v":false},null,"Midnight Sun","Midnight Sun"]
[null,"A Promised Land","Untamed",false,null,"A Promised Land","Untamed"]
[null,"Greenlights","Becoming",false,null,"Greenlights","Becoming"]
[null,"Fear No Evil","Rage",true,null,"Fear No Evil","Rage"]
[null,"Caste","Caste",false,null,"Caste","Caste"]
[null,"American Dirt","Greenlights",false,null,"American Dirt","Greenlights"]
[null,"Untamed","American Dirt",false,null,"Untamed","American Dirt"]