{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Dataset","Formula","VBA"],"not_rendered":{"charts":0,"images":0,"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":"Dataset","index":0,"n_rows":22,"n_cols":11,"rows_kept":22,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Dataset"]
[]
[null,"Text","Matched/Not Matched"]
[null,"BJK234lpo"]
[null,"NKX344ert"]
[null,"aBO7a9yui"]
[null,"PLU123mnu"]
[null,"VBA237you"]
[null,"ILO456veu"]
[null,"QWT324mcf"]
[null,"aba890NTY"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"Formula","index":1,"n_rows":22,"n_cols":11,"rows_kept":22,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,9,1,10]]}
[]
[null,"Combination of Functions",null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Text","Matched/Not Matched",null,null,null,null,null,null,"Text","Matched/Not Matched"]
[null,"BJK234lpo",{"$f":"IF(AND(LEN(B5)=9,COUNT(FIND(MID(LEFT(B5,3), ROW(INDIRECT(\"1:\"&LEN(LEFT(B5,3)))),1 ),UPPER(Letters)))=LEN(LEFT(B5,3)),COUNT(FIND(MID(MID(B5,4,3), ROW(INDIRECT(\"1:\"&LEN(MID(B5,4,3)))),1 ),Numbers))=LEN(MID(B5,4,3)),ISNUMBER(FIND(RIGHT(B5),Letters))),\"Matched\",\"Not Matched\")","v":"Matched"},null,null,null,null,null,null,"BJK234lpo"]
[null,"NKX344ert",{"$f":"IF(AND(LEN(B6)=9,COUNT(FIND(MID(LEFT(B6,3), ROW(INDIRECT(\"1:\"&LEN(LEFT(B6,3)))),1 ),UPPER(Letters)))=LEN(LEFT(B6,3)),COUNT(FIND(MID(MID(B6,4,3), ROW(INDIRECT(\"1:\"&LEN(MID(B6,4,3)))),1 ),Numbers))=LEN(MID(B6,4,3)),ISNUMBER(FIND(RIGHT(B6),Letters))),\"Matched\",\"Not Matched\")","v":"Matched"},null,null,null,null,null,null,"NKX344ert"]
[null,"aBO7a9yui",{"$f":"IF(AND(LEN(B7)=9,COUNT(FIND(MID(LEFT(B7,3), ROW(INDIRECT(\"1:\"&LEN(LEFT(B7,3)))),1 ),UPPER(Letters)))=LEN(LEFT(B7,3)),COUNT(FIND(MID(MID(B7,4,3), ROW(INDIRECT(\"1:\"&LEN(MID(B7,4,3)))),1 ),Numbers))=LEN(MID(B7,4,3)),ISNUMBER(FIND(RIGHT(B7),Letters))),\"Matched\",\"Not Matched\")","v":"Not Matched"},null,null,null,null,null,null,"aBO7a9yui"]
[null,"PLU123mnu",{"$f":"IF(AND(LEN(B8)=9,COUNT(FIND(MID(LEFT(B8,3), ROW(INDIRECT(\"1:\"&LEN(LEFT(B8,3)))),1 ),UPPER(Letters)))=LEN(LEFT(B8,3)),COUNT(FIND(MID(MID(B8,4,3), ROW(INDIRECT(\"1:\"&LEN(MID(B8,4,3)))),1 ),Numbers))=LEN(MID(B8,4,3)),ISNUMBER(FIND(RIGHT(B8),Letters))),\"Matched\",\"Not Matched\")","v":"Matched"},null,null,null,null,null,null,"PLU123mnu"]
[null,"VBA237you",{"$f":"IF(AND(LEN(B9)=9,COUNT(FIND(MID(LEFT(B9,3), ROW(INDIRECT(\"1:\"&LEN(LEFT(B9,3)))),1 ),UPPER(Letters)))=LEN(LEFT(B9,3)),COUNT(FIND(MID(MID(B9,4,3), ROW(INDIRECT(\"1:\"&LEN(MID(B9,4,3)))),1 ),Numbers))=LEN(MID(B9,4,3)),ISNUMBER(FIND(RIGHT(B9),Letters))),\"Matched\",\"Not Matched\")","v":"Matched"},null,null,null,null,null,null,"VBA237you"]
[null,"ILO456veu",{"$f":"IF(AND(LEN(B10)=9,COUNT(FIND(MID(LEFT(B10,3), ROW(INDIRECT(\"1:\"&LEN(LEFT(B10,3)))),1 ),UPPER(Letters)))=LEN(LEFT(B10,3)),COUNT(FIND(MID(MID(B10,4,3), ROW(INDIRECT(\"1:\"&LEN(MID(B10,4,3)))),1 ),Numbers))=LEN(MID(B10,4,3)),ISNUMBER(FIND(RIGHT(B10),Letters))),\"Matched\",\"Not Matched\")","v":"Matched"},null,null,null,null,null,null,"ILO456veu"]
[null,"QWT324mcf",{"$f":"IF(AND(LEN(B11)=9,COUNT(FIND(MID(LEFT(B11,3), ROW(INDIRECT(\"1:\"&LEN(LEFT(B11,3)))),1 ),UPPER(Letters)))=LEN(LEFT(B11,3)),COUNT(FIND(MID(MID(B11,4,3), ROW(INDIRECT(\"1:\"&LEN(MID(B11,4,3)))),1 ),Numbers))=LEN(MID(B11,4,3)),ISNUMBER(FIND(RIGHT(B11),Letters))),\"Matched\",\"Not Matched\")","v":"Matched"},null,null,null,null,null,null,"QWT324mcf"]
[null,"aba890NTY",{"$f":"IF(AND(LEN(B12)=9,COUNT(FIND(MID(LEFT(B12,3), ROW(INDIRECT(\"1:\"&LEN(LEFT(B12,3)))),1 ),UPPER(Letters)))=LEN(LEFT(B12,3)),COUNT(FIND(MID(MID(B12,4,3), ROW(INDIRECT(\"1:\"&LEN(MID(B12,4,3)))),1 ),Numbers))=LEN(MID(B12,4,3)),ISNUMBER(FIND(RIGHT(B12),Letters))),\"Matched\",\"Not Matched\")","v":"Not Matched"},null,null,null,null,null,null,"aba890NTY"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"VBA","index":2,"n_rows":23,"n_cols":11,"rows_kept":23,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,8,1,9]]}
[null," "]
[null,"Use of VBA Macro",null,null,null,null,null,null,"Do Yourself"]
[null," ",null,null,null,null,null,null," "]
[null,"Text","Matched or Not",null,null,null,null,null,"Text","Matched or Not"]
[null,"6789uuyt",{"$f":"IF(PatternMatch(B5,\"\\D{4}\\d{4}\"),\"Matched\",\"Not Matched\")","v":"Not Matched"},null,null,null,null,null,"6789uuyt",{"$f":"IF(PatternMatch(I5,\"\\D{4}\\d{4}\"),\"Matched\",\"Not Matched\")","v":"Not Matched"}]
[null,"GFY7898",{"$f":"IF(PatternMatch(B6,\"\\D{4}\\d{4}\"),\"Matched\",\"Not Matched\")","v":"Not Matched"},null,null,null,null,null,"GFY7898",{"$f":"IF(PatternMatch(I6,\"\\D{4}\\d{4}\"),\"Matched\",\"Not Matched\")","v":"Not Matched"}]
[null,"AioI7953",{"$f":"IF(PatternMatch(B7,\"\\D{4}\\d{4}\"),\"Matched\",\"Not Matched\")","v":"Matched"},null,null,null,null,null,"AioI7953",{"$f":"IF(PatternMatch(I7,\"\\D{4}\\d{4}\"),\"Matched\",\"Not Matched\")","v":"Matched"}]
[null,"BMUT6546",{"$f":"IF(PatternMatch(B8,\"\\D{4}\\d{4}\"),\"Matched\",\"Not Matched\")","v":"Matched"},null,null,null,null,null,"BMUT6546",{"$f":"IF(PatternMatch(I8,\"\\D{4}\\d{4}\"),\"Matched\",\"Not Matched\")","v":"Matched"}]
[null,"UIYJ967",{"$f":"IF(PatternMatch(B9,\"\\D{4}\\d{4}\"),\"Matched\",\"Not Matched\")","v":"Not Matched"},null,null,null,null,null,"UIYJ967",{"$f":"IF(PatternMatch(I9,\"\\D{4}\\d{4}\"),\"Matched\",\"Not Matched\")","v":"Not Matched"}]
[null,"POI6547",{"$f":"IF(PatternMatch(B10,\"\\D{4}\\d{4}\"),\"Matched\",\"Not Matched\")","v":"Not Matched"},null,null,null,null,null,"POI6547",{"$f":"IF(PatternMatch(I10,\"\\D{4}\\d{4}\"),\"Matched\",\"Not Matched\")","v":"Not Matched"}]
[null,"QTyy3247",{"$f":"IF(PatternMatch(B11,\"\\D{4}\\d{4}\"),\"Matched\",\"Not Matched\")","v":"Matched"},null,null,null,null,null,"QTyy3247",{"$f":"IF(PatternMatch(I11,\"\\D{4}\\d{4}\"),\"Matched\",\"Not Matched\")","v":"Matched"}]
[null,"UOPW5643",{"$f":"IF(PatternMatch(B12,\"\\D{4}\\d{4}\"),\"Matched\",\"Not Matched\")","v":"Matched"},null,null,null,null,null,"UOPW5643",{"$f":"IF(PatternMatch(I12,\"\\D{4}\\d{4}\"),\"Matched\",\"Not Matched\")","v":"Matched"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]