{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Question","Start","Bill","Mike","Sheet2","Sheet3","Sheet4"],"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":"Question","index":0,"n_rows":7,"n_cols":5,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"02-11-89-85-34-09",null,"55-25-89-02-11-74"]
[]
[null,{"$f":"\"Any Number in \"&ADDRESS(ROW(C2),COLUMN(C2),4)&\" in \"&ADDRESS(ROW(E2),COLUMN(E2),4)&\"?\"","v":"Any Number in C2 in E2?"},null,null,{"$f":"\"Any Number in \"&ADDRESS(ROW(E2),COLUMN(E2),4)&\" in \"&ADDRESS(ROW(C2),COLUMN(C2),4)&\"?\"","v":"Any Number in E2 in C2?"}]
[]
[]
[null,"There should be a match for 02, 11, and 89"]

{"sheet":"Start","index":1,"n_rows":7,"n_cols":5,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"02-11-89-85-34-09",null,"55-25-89-02-11-74"]
[]
[null,{"$f":"\"Any Number in \"&ADDRESS(ROW(C2),COLUMN(C2),4)&\" in \"&ADDRESS(ROW(E2),COLUMN(E2),4)&\"?\"","v":"Any Number in C2 in E2?"},null,null,{"$f":"\"Any Number in \"&ADDRESS(ROW(E2),COLUMN(E2),4)&\" in \"&ADDRESS(ROW(C2),COLUMN(C2),4)&\"?\"","v":"Any Number in E2 in C2?"}]
[]
[]
[null,"There should be a match for 02, 11, and 89"]

{"sheet":"Bill","index":2,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"02-11-89-85-34-09",null,"55-25-89-02-11-74"]
[]
[null,{"$f":"\"Any Number in \"&ADDRESS(ROW(C2),COLUMN(C2),4)&\" in \"&ADDRESS(ROW(E2),COLUMN(E2),4)&\"?\"","v":"Any Number in C2 in E2?"},null,null,{"$f":"\"Any Number in \"&ADDRESS(ROW(E2),COLUMN(E2),4)&\" in \"&ADDRESS(ROW(C2),COLUMN(C2),4)&\"?\"","v":"Any Number in E2 in C2?"}]
[null,null,{"$f":"GetMatch(C2,E2)","v":"02, 11, 89"},null,{"$f":"GetMatch(E2,C2)","v":"89, 02, 11"}]
[]
[null,"There should be a match for 02, 11, and 89"]
[]
[null,null,{"$f":"GetMatch(C2,E2)","v":"02, 11, 89"}]

{"sheet":"Mike","index":3,"n_rows":26,"n_cols":7,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"02-11-89-85-34-09",null,null,"55-25-89-02-11-74"]
[]
[null,{"$f":"\"Any Number in \"&ADDRESS(ROW(C2),COLUMN(C2),4)&\" in \"&ADDRESS(ROW(F2),COLUMN(F2),4)&\"?\"","v":"Any Number in C2 in F2?"},null,"better formula:",{"$f":"\"Any Number in \"&ADDRESS(ROW(F2),COLUMN(F2),4)&\" in \"&ADDRESS(ROW(C2),COLUMN(C2),4)&\"?\"","v":"Any Number in F2 in C2?"},null,"better formula:"]
[null,{"$f":"MID($C$2,ROWS(B$5:B5)*3-2,2)","v":"02"},{"$f":"ISNUMBER(MATCH(B5,MID($F$2,{1,4,7,10,13,16},2),0))","v":true},{"$f":"ISNUMBER(SEARCH(B5,$F$2))","v":true},{"$f":"MID($F$2,ROWS(E$5:E5)*3-2,2)","v":"55"},{"$f":"ISNUMBER(MATCH(E5,MID($C$2,{1,4,7,10,13,16},2),0))","v":false},{"$f":"ISNUMBER(SEARCH(E5,$C$2))","v":false}]
[null,{"$f":"MID($C$2,ROWS(B$5:B6)*3-2,2)","v":"11"},{"$f":"ISNUMBER(MATCH(B6,MID($F$2,{1,4,7,10,13,16},2),0))","v":true},{"$f":"ISNUMBER(SEARCH(B6,$F$2))","v":true},{"$f":"MID($F$2,ROWS(E$5:E6)*3-2,2)","v":"25"},{"$f":"ISNUMBER(MATCH(E6,MID($C$2,{1,4,7,10,13,16},2),0))","v":false},{"$f":"ISNUMBER(SEARCH(E6,$C$2))","v":false}]
[null,{"$f":"MID($C$2,ROWS(B$5:B7)*3-2,2)","v":"89"},{"$f":"ISNUMBER(MATCH(B7,MID($F$2,{1,4,7,10,13,16},2),0))","v":true},true,{"$f":"MID($F$2,ROWS(E$5:E7)*3-2,2)","v":"89"},{"$f":"ISNUMBER(MATCH(E7,MID($C$2,{1,4,7,10,13,16},2),0))","v":true},true]
[null,{"$f":"MID($C$2,ROWS(B$5:B8)*3-2,2)","v":"85"},{"$f":"ISNUMBER(MATCH(B8,MID($F$2,{1,4,7,10,13,16},2),0))","v":false},false,{"$f":"MID($F$2,ROWS(E$5:E8)*3-2,2)","v":"02"},{"$f":"ISNUMBER(MATCH(E8,MID($C$2,{1,4,7,10,13,16},2),0))","v":true},true]
[null,{"$f":"MID($C$2,ROWS(B$5:B9)*3-2,2)","v":"34"},{"$f":"ISNUMBER(MATCH(B9,MID($F$2,{1,4,7,10,13,16},2),0))","v":false},false,{"$f":"MID($F$2,ROWS(E$5:E9)*3-2,2)","v":"11"},{"$f":"ISNUMBER(MATCH(E9,MID($C$2,{1,4,7,10,13,16},2),0))","v":true},true]
[null,{"$f":"MID($C$2,ROWS(B$5:B10)*3-2,2)","v":"09"},{"$f":"ISNUMBER(MATCH(B10,MID($F$2,{1,4,7,10,13,16},2),0))","v":false},false,{"$f":"MID($F$2,ROWS(E$5:E10)*3-2,2)","v":"74"},{"$f":"ISNUMBER(MATCH(E10,MID($C$2,{1,4,7,10,13,16},2),0))","v":false},false]
[]
[null,null,null,"Other better formula:",null,null,"Other better formula:"]
[null,null,null,{"$f":"COUNTIF($F$2,\"*\"&B5&\"*\")>0","v":true},null,null,{"$f":"COUNTIF($C$2,\"*\"&E5&\"*\")>0","v":false}]
[null,null,null,true,null,null,{"$f":"COUNTIF($C$2,\"*\"&E6&\"*\")>0","v":false}]
[null,null,null,true,null,null,true]
[null,null,null,false,null,null,true]
[null,null,null,false,null,null,true]
[null,null,null,false,null,null,false]
[]
[null,null,"Single Cell:",null,null,"Single Cell:"]
[null,null,{"$f":"MID($F$2,SMALL(IF(ISNUMBER(SEARCH(MID($C$2,{1,4,7,10,13,16},2),$F$2)),SEARCH(MID($C$2,{1,4,7,10,13,16},2),$F$2)),ROWS(C$21:C21)),2)","v":"89"},null,null,{"$f":"MID($C$2,SMALL(IF(ISNUMBER(SEARCH(MID($F$2,{1,4,7,10,13,16},2),$C$2)),SEARCH(MID($F$2,{1,4,7,10,13,16},2),$C$2)),ROWS(F$21:F21)),2)","v":"02"}]
[null,null,{"$f":"MID($F$2,SMALL(IF(ISNUMBER(SEARCH(MID($C$2,{1,4,7,10,13,16},2),$F$2)),SEARCH(MID($C$2,{1,4,7,10,13,16},2),$F$2)),ROWS(C$21:C22)),2)","v":"02"},null,null,{"$f":"MID($C$2,SMALL(IF(ISNUMBER(SEARCH(MID($F$2,{1,4,7,10,13,16},2),$C$2)),SEARCH(MID($F$2,{1,4,7,10,13,16},2),$C$2)),ROWS(F$21:F22)),2)","v":"11"}]
[null,null,{"$f":"MID($F$2,SMALL(IF(ISNUMBER(SEARCH(MID($C$2,{1,4,7,10,13,16},2),$F$2)),SEARCH(MID($C$2,{1,4,7,10,13,16},2),$F$2)),ROWS(C$21:C23)),2)","v":"11"},null,null,{"$f":"MID($C$2,SMALL(IF(ISNUMBER(SEARCH(MID($F$2,{1,4,7,10,13,16},2),$C$2)),SEARCH(MID($F$2,{1,4,7,10,13,16},2),$C$2)),ROWS(F$21:F23)),2)","v":"89"}]
[null,null,{"$f":"MID($F$2,SMALL(IF(ISNUMBER(SEARCH(MID($C$2,{1,4,7,10,13,16},2),$F$2)),SEARCH(MID($C$2,{1,4,7,10,13,16},2),$F$2)),ROWS(C$21:C24)),2)","v":{"$error":"#NUM!"}},null,null,{"$f":"MID($C$2,SMALL(IF(ISNUMBER(SEARCH(MID($F$2,{1,4,7,10,13,16},2),$C$2)),SEARCH(MID($F$2,{1,4,7,10,13,16},2),$C$2)),ROWS(F$21:F24)),2)","v":{"$error":"#NUM!"}}]
[null,null,{"$f":"MID($F$2,SMALL(IF(ISNUMBER(SEARCH(MID($C$2,{1,4,7,10,13,16},2),$F$2)),SEARCH(MID($C$2,{1,4,7,10,13,16},2),$F$2)),ROWS(C$21:C25)),2)","v":{"$error":"#NUM!"}},null,null,{"$f":"MID($C$2,SMALL(IF(ISNUMBER(SEARCH(MID($F$2,{1,4,7,10,13,16},2),$C$2)),SEARCH(MID($F$2,{1,4,7,10,13,16},2),$C$2)),ROWS(F$21:F25)),2)","v":{"$error":"#NUM!"}}]
[null,null,{"$f":"MID($F$2,SMALL(IF(ISNUMBER(SEARCH(MID($C$2,{1,4,7,10,13,16},2),$F$2)),SEARCH(MID($C$2,{1,4,7,10,13,16},2),$F$2)),ROWS(C$21:C26)),2)","v":{"$error":"#NUM!"}},null,null,{"$f":"MID($C$2,SMALL(IF(ISNUMBER(SEARCH(MID($F$2,{1,4,7,10,13,16},2),$C$2)),SEARCH(MID($F$2,{1,4,7,10,13,16},2),$C$2)),ROWS(F$21:F26)),2)","v":{"$error":"#NUM!"}}]

{"sheet":"Sheet2","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Sheet3","index":5,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"02-11-89-85-34-09",null,"55-25-89-02-11-74"]
[]
[null,{"$f":"\"Number in \"&ADDRESS(ROW(C2),COLUMN(C2),4)&\" in \"&ADDRESS(ROW(E2),COLUMN(E2),4)&\"?\"","v":"Number in C2 in E2?"},null,null,{"$f":"\"Number in \"&ADDRESS(ROW(E2),COLUMN(E2),4)&\" in \"&ADDRESS(ROW(C2),COLUMN(C2),4)&\"?\"","v":"Number in E2 in C2?"}]
[null,{"$f":"MID($C$2,(ROWS(B$5:B5)-1)*3+1,2)","v":"02"},{"$f":"ISNUMBER(MATCH(B5,MID($E$2,{1,4,7,10,13,16},2),0))","v":true},null,{"$f":"MID($E$2,(ROWS(E$5:E5)-1)*3+1,2)","v":"55"},{"$f":"ISNUMBER(MATCH(E5,MID($C$2,{1,4,7,10,13,16},2),0))","v":false}]
[null,{"$f":"MID($C$2,(ROWS(B$5:B6)-1)*3+1,2)","v":"11"},{"$f":"ISNUMBER(MATCH(B6,MID($E$2,{1,4,7,10,13,16},2),0))","v":true},null,{"$f":"MID($E$2,(ROWS(E$5:E6)-1)*3+1,2)","v":"25"},{"$f":"ISNUMBER(MATCH(E6,MID($C$2,{1,4,7,10,13,16},2),0))","v":false}]
[null,{"$f":"MID($C$2,(ROWS(B$5:B7)-1)*3+1,2)","v":"89"},{"$f":"ISNUMBER(MATCH(B7,MID($E$2,{1,4,7,10,13,16},2),0))","v":true},null,{"$f":"MID($E$2,(ROWS(E$5:E7)-1)*3+1,2)","v":"89"},{"$f":"ISNUMBER(MATCH(E7,MID($C$2,{1,4,7,10,13,16},2),0))","v":true}]
[null,{"$f":"MID($C$2,(ROWS(B$5:B8)-1)*3+1,2)","v":"85"},{"$f":"ISNUMBER(MATCH(B8,MID($E$2,{1,4,7,10,13,16},2),0))","v":false},null,{"$f":"MID($E$2,(ROWS(E$5:E8)-1)*3+1,2)","v":"02"},{"$f":"ISNUMBER(MATCH(E8,MID($C$2,{1,4,7,10,13,16},2),0))","v":true}]
[null,{"$f":"MID($C$2,(ROWS(B$5:B9)-1)*3+1,2)","v":"34"},{"$f":"ISNUMBER(MATCH(B9,MID($E$2,{1,4,7,10,13,16},2),0))","v":false},null,{"$f":"MID($E$2,(ROWS(E$5:E9)-1)*3+1,2)","v":"11"},{"$f":"ISNUMBER(MATCH(E9,MID($C$2,{1,4,7,10,13,16},2),0))","v":true}]
[null,{"$f":"MID($C$2,(ROWS(B$5:B10)-1)*3+1,2)","v":"09"},{"$f":"ISNUMBER(MATCH(B10,MID($E$2,{1,4,7,10,13,16},2),0))","v":false},null,{"$f":"MID($E$2,(ROWS(E$5:E10)-1)*3+1,2)","v":"74"},{"$f":"ISNUMBER(MATCH(E10,MID($C$2,{1,4,7,10,13,16},2),0))","v":false}]

{"sheet":"Sheet4","index":6,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}