{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["Data Set","IF Function","EXACT Function","AND Function","COUNTIF Function","OR Function","ISERROR & MATCH Function","SUM Function","VLOOKUP Function","TRIM Function","Cosditionali For","Excel_VBA","x"],"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":"Data Set","index":0,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"If 2 Cells Match then Yes"]
[]
[null,"Tennis","Rugby"]
[null,"Jessica","Jessica"]
[null,"Henderson","Henderson"]
[null,"Aaron","Joe"]
[null,"Mitchel","Mitchel"]
[null,"John","Josef"]

{"sheet":"IF Function","index":1,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"IF Function to Match 2 Cells"]
[]
[null,"Tennis","Rugby","Status"]
[null,"Jessica","Jessica",{"$f":"IF(B5:B9<>C5:C9,\"\",\"Yes\")","v":"Yes"}]
[null,"Henderson","Henderson","Yes"]
[null,"Aaron","Joe",""]
[null,"Mitchel","Mitchel","Yes"]
[null,"John","Josef",""]

{"sheet":"EXACT Function","index":2,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"EXACT Function to Match 2 Cells"]
[]
[null,"Tennis","Rugby","Status"]
[null,"Jessica","Jessica",{"$f":"IF(EXACT(B5,C5),\"Yes\",\"\")","v":"Yes"}]
[null,"Henderson","Henderson",{"$f":"IF(EXACT(B6,C6),\"Yes\",\"\")","v":"Yes"}]
[null,"Aaron","Joe",""]
[null,"Mitchel","Mitchel","Yes"]
[null,"John","Josef",""]

{"sheet":"AND Function","index":3,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"AND Function to Match 2 Cells"]
[]
[null,"Tennis","Rugby","Status"]
[null,"Jessica","Jessica",{"$f":"IF(AND(B5=C5),\"Yes\",\"\")","v":"Yes"}]
[null,"Henderson","Henderson",{"$f":"IF(AND(B6=C6),\"Yes\",\"\")","v":"Yes"}]
[null,"Aaron","Joe",""]
[null,"Mitchel","Mitchel","Yes"]
[null,"John","Josef",""]

{"sheet":"COUNTIF Function","index":4,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"COUNTIF Function to Match 2 Cells"]
[]
[null,"Tennis","Rugby","Status"]
[null,"Jessica","Jessica",{"$f":"IF(COUNTIF(B5,C5),\"Yes\",\"\")","v":"Yes"}]
[null,"Henderson","Henderson",{"$f":"IF(COUNTIF(B6,C6),\"Yes\",\"\")","v":"Yes"}]
[null,"Aaron","Joe",""]
[null,"Mitchel","Mitchel","Yes"]
[null,"John","Josef",""]

{"sheet":"OR Function","index":5,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"OR Function to Match 2 Cells"]
[]
[null,"Tennis","Rugby","Status"]
[null,"Jessica","Jessica",{"$f":"IF(OR(B5=C5),\"Yes\",\"\")","v":"Yes"}]
[null,"Henderson","Henderson",{"$f":"IF(OR(B6=C6),\"Yes\",\"\")","v":"Yes"}]
[null,"Aaron","Joe",""]
[null,"Mitchel","Mitchel","Yes"]
[null,"John","Josef",""]

{"sheet":"ISERROR & MATCH Function","index":6,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"ISERROR & MATCH Functions to Test 2 Cells"]
[]
[null,"Tennis","Rugby","Status"]
[null,"Jessica","Jessica",{"$f":"IF(ISERROR(MATCH(B5,C5,0)),\"\",\"Yes\")","v":"Yes"}]
[null,"Henderson","Henderson",{"$f":"IF(ISERROR(MATCH(B6,C6,0)),\"\",\"Yes\")","v":"Yes"}]
[null,"Aaron","Joe",""]
[null,"Mitchel","Mitchel","Yes"]
[null,"John","Josef",""]

{"sheet":"SUM Function","index":7,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"SUM Function to Match 2 Cells"]
[]
[null,"Tennis","Rugby","Status"]
[null,"Jessica","Jessica",{"$f":"IF(SUM(--(B5=C5))=1, \" Yes\", \"\")","v":" Yes"}]
[null,"Henderson","Henderson",{"$f":"IF(SUM(--(B6=C6))=1, \" Yes\", \"\")","v":" Yes"}]
[null,"Aaron","Joe",""]
[null,"Mitchel","Mitchel"," Yes"]
[null,"John","Josef",""]

{"sheet":"VLOOKUP Function","index":8,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"VLOOKUP Function to Match 2 Cells"]
[]
[null,"Tennis","Rugby","Status"]
[null,"Jessica","Jessica",{"$f":"IF(ISERROR(VLOOKUP(C5, B5, 1, FALSE)),\"\",\"Yes\")","v":"Yes"}]
[null,"Henderson","Henderson",{"$f":"IF(ISERROR(VLOOKUP(C6, B6, 1, FALSE)),\"\",\"Yes\")","v":"Yes"}]
[null,"Aaron","Josef",""]
[null,"Mitchel","Mitchel","Yes"]
[null,"John","Jeo",""]

{"sheet":"TRIM Function","index":9,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"TRIM Function to Match 2 Cells"]
[]
[null,"Tennis","Rugby","Status"]
[null,"Jessica","Jessica",{"$f":"IF((TRIM(B5)=TRIM(C5)),\"Yes\",\"\")","v":"Yes"}]
[null,"Henderson","Henderson",{"$f":"IF((TRIM(B6)=TRIM(C6)),\"Yes\",\"\")","v":"Yes"}]
[null,"Aaron","Josef",""]
[null,"Mitchel","Mitchel","Yes"]
[null,"John","Jeo",""]

{"sheet":"Cosditionali For","index":10,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Conditional Formatting to Match 2 Cells"]
[]
[null,"Tennis","Rugby"]
[null,"Jessica","Jessica"]
[null,"Henderson","Henderson"]
[null,"Aaron","Josef"]
[null,"Mitchel","Mitchel"]
[null,"John","Jeo"]

{"sheet":"Excel_VBA","index":11,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Excel VBA to Match 2 Cells"]
[]
[null,"Tennis","Rugby"]
[null,"Jessica","Jessica",null,"Status"]
[null,"Henderson","Henderson",null,"Yes"]
[null,"Aaron","Josef"]
[null,"Mitchel","Mitchel"]
[null,"John","Jeo"]

{"sheet":"x","index":12,"n_rows":15,"n_cols":7,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Conditional Formatting Formula If Cell Contains Text"]
[]
[null,"Standard 1","Standard 2","Standard 3","Standard 4"]
[null,"Jessica","Allisa","Joe","Josef",{"$f":"IF(EXACT(C7,D5),\"Yes\",\"\")","v":"Yes"},{"$f":"_xlfn.FORMULATEXT(F5)","v":"=IF(EXACT(C7,D5),\"Yes\",\"\")"}]
[null,"Henderson","Jose",null,"Gerg",{"$f":"IF(C7=D5,\"Yes\",\"\")","v":"Yes"},{"$f":"_xlfn.FORMULATEXT(F6)","v":"=IF(C7=D5,\"Yes\",\"\")"}]
[null,"Aaron","Joe","Josef",null,{"$f":"IF(C7<>D5,\"\",\"Yes\")","v":"Yes"},"=IF(C7<>D5,\"\",\"Yes\")"]
[null,"Mitchel",null,"Rogers","Jessica",{"$f":"IF(AND(C7=D5),\"Yes\",\"\")","v":"Yes"},"=IF(AND(C7=D5),\"Yes\",\"\")"]
[null,"John","John","John","John",{"$f":"IF(COUNTIF(C7,D5)=1, \"Yes\", \"\")","v":"Yes"},"=IF(COUNTIF(C7,D5)=1, \"Yes\", \"\")"]
[null,null,null,null,null,{"$f":"IF(OR(C7=D5),\"Yes\",\"\")","v":"Yes"},"=IF(OR(C7=D5),\"Yes\",\"\")"]
[null,null,null,null,null,{"$f":"IF(ISERROR(MATCH(C7,D5,0)),\"\",\"Yes\")","v":"Yes"},"=IF(ISERROR(MATCH(C7,D5,0)),\"\",\"Yes\")"]
[null,null,null,null,null,{"$f":"IF(SUM(--(C7=D5))=1, \" Yes\", \"\")","v":" Yes"},"=IF(SUM(--(C7=D5))=1, \" Yes\", \"\")"]
[null,null,null,null,null,{"$f":"C7=D5","v":true},"=C7=D5"]
[null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,{"$error":"#N/A"}]