{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Title","Question","BillTry","MikeTry","BillTry3","Cover"],"not_rendered":{"charts":0,"images":12,"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":"Title","index":0,"n_rows":7,"n_cols":13,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,186]

{"sheet":"Question","index":1,"n_rows":45,"n_cols":2,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
["Code","Change"]
["BXB0","Yes"]
["wSEP9","Yes"]
["Hwkj","No"]
["RcdgM","No"]
["lTSc","No"]
["br86Z5tQ","Yes"]
["EvdnaBTg","No"]
["qn17r89f","Yes"]
["KsbeLd","No"]
["htagh","No"]
["tjaoEmr","No"]
["wJnv","No"]
["Mdotblh","No"]
["li419","Yes"]
["S0Hh8","Yes"]
["0TuW","Yes"]
["hPdJtAgK","No"]
["gpRqr","No"]
["tXzcZ","No"]
["uQIymo","No"]
["i8v08","Yes"]
["dLKBb","No"]
["0DeBe1Lb","Yes"]
["ldwD","No"]
["cycNV","No"]
["xMLGtc","No"]
["VvnP","No"]
["3sFY9Q","Yes"]
["oBjq","No"]
["TlnTzkK","No"]
["Dl3t6EJ","Yes"]
["2tI4Dd","Yes"]
["DHt1VV7hh","Yes"]
["IRpsK","No"]
["uleVVx","No"]
["ufuOTKpV","No"]
["gUjp2C","Yes"]
["UBfUp","No"]
["C5GDH","Yes"]
["QDfWg","No"]
["NO488B1","Yes"]
["HpcMQEJKV","No"]
["640586Xk7","Yes"]
["bGKvynJQd","No"]

{"sheet":"BillTry","index":2,"n_rows":46,"n_cols":3,"rows_kept":46,"cut":false,"hidden":false,"merged":[]}
["Code","Fix","Change"]
["w1e2r3b4b5v6c7c8c9c0","werbbvcccc",{"$f":"IF(B2=A2,\"No\",\"Yes\")","v":"Yes"}]
["BXB0","BXB",{"$f":"IF(B3=A3,\"No\",\"Yes\")","v":"Yes"}]
["wSEP9","wSEP","Yes"]
["Hwkj","Hwkj","No"]
["RcdgM","RcdgM","No"]
["lTSc","lTSc","No"]
["br86Z5tQ","brZtQ","Yes"]
["EvdnaBTg","EvdnaBTg","No"]
["qn17r89f","qnrf","Yes"]
["KsbeLd","KsbeLd","No"]
["htagh","htagh","No"]
["tjaoEmr","tjaoEmr","No"]
["wJnv","wJnv","No"]
["Mdotblh","Mdotblh","No"]
["li419","li","Yes"]
["S0Hh8","SHh","Yes"]
["0TuW","TuW","Yes"]
["hPdJtAgK","hPdJtAgK","No"]
["gpRqr","gpRqr","No"]
["tXzcZ","tXzcZ","No"]
["uQIymo","uQIymo","No"]
["i8v08","iv","Yes"]
["dLKBb","dLKBb","No"]
["0DeBe1Lb","DeBeLb","Yes"]
["ldwD","ldwD","No"]
["cycNV","cycNV","No"]
["xMLGtc","xMLGtc","No"]
["VvnP","VvnP","No"]
["3sFY9Q","sFYQ","Yes"]
["oBjq","oBjq","No"]
["TlnTzkK","TlnTzkK","No"]
["Dl3t6EJ","DltEJ","Yes"]
["2tI4Dd","tIDd","Yes"]
["DHt1VV7hh","DHtVVhh","Yes"]
["IRpsK","IRpsK","No"]
["uleVVx","uleVVx","No"]
["ufuOTKpV","ufuOTKpV","No"]
["gUjp2C","gUjpC","Yes"]
["UBfUp","UBfUp","No"]
["C5GDH","CGDH","Yes"]
["QDfWg","QDfWg","No"]
["NO488B1","NOB","Yes"]
["HpcMQEJKV","HpcMQEJKV","No"]
["640586Xk7","Xk","Yes"]
["bGKvynJQd","bGKvynJQd","No"]

{"sheet":"MikeTry","index":3,"n_rows":45,"n_cols":17,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
["Code","Yes = Found Number in Text","Meni Formula",null,"Method 2","Equal?",null,"count 0",null,"count 0",null,null,null,null,null,null,{"$f":"COUNTIFS(P2:P45,FALSE)","v":0}]
["BXB0",{"$f":"IF(AND(SUBSTITUTE(A2,{1,2,3,4,5,6,7,8,9,0},\"\")=A2),\"No\",\"Yes\")","v":"Yes"},{"$f":"IF(COUNT(SEARCH({1,2,3,4,5,6,7,8,9,0},A2)),\"Yes\",\"No\")","v":"Yes"},null,{"$f":"IF(AND(ISERROR(--MID(A2,ROW(INDIRECT(\"1:\"&LEN(A2))),1))),\"No\",\"Yes\")","v":"Yes"},{"$f":"E2=B2","v":true},null,{"$f":"COUNTIFS(F2:F45,FALSE)","v":0},null,{"$f":"COUNTIFS(L2:L45,FALSE)","v":0},null,{"$f":"M2=O2","v":true},{"$f":"IF(B2=\"Yes\",\"Numbers\",\"Alpha\")","v":"Numbers"},{"$f":"IF(AND(SUBSTITUTE(A2,{1,2,3,4,5,6,7,8,9,0},\"\")=A2),\"Alpha\",\"Numbers\")","v":"Numbers"},{"$f":"BillTry3!B2","v":"Numbers"},{"$f":"O2=N2","v":true}]
["wSEP9",{"$f":"IF(AND(SUBSTITUTE(A3,{1,2,3,4,5,6,7,8,9,0},\"\")=A3),\"No\",\"Yes\")","v":"Yes"},{"$f":"IF(COUNT(SEARCH({1,2,3,4,5,6,7,8,9,0},A3)),\"Yes\",\"No\")","v":"Yes"},null,{"$f":"IF(AND(ISERROR(--MID(A3,ROW(INDIRECT(\"1:\"&LEN(A3))),1))),\"No\",\"Yes\")","v":"Yes"},true,null,null,null,null,null,{"$f":"M3=O3","v":true},"Numbers",{"$f":"IF(AND(SUBSTITUTE(A3,{1,2,3,4,5,6,7,8,9,0},\"\")=A3),\"Alpha\",\"Numbers\")","v":"Numbers"},{"$f":"BillTry3!B3","v":"Numbers"},{"$f":"O3=N3","v":true}]
["Hwkj",{"$f":"IF(AND(SUBSTITUTE(A4,{1,2,3,4,5,6,7,8,9,0},\"\")=A4),\"No\",\"Yes\")","v":"No"},{"$f":"IF(COUNT(SEARCH({1,2,3,4,5,6,7,8,9,0},A4)),\"Yes\",\"No\")","v":"No"},null,{"$f":"IF(AND(ISERROR(--MID(A4,ROW(INDIRECT(\"1:\"&LEN(A4))),1))),\"No\",\"Yes\")","v":"No"},true,null,null,null,null,null,true,"Alpha",{"$f":"IF(AND(SUBSTITUTE(A4,{1,2,3,4,5,6,7,8,9,0},\"\")=A4),\"Alpha\",\"Numbers\")","v":"Alpha"},{"$f":"BillTry3!B4","v":"Alpha"},true]
["RcdgM",{"$f":"IF(AND(SUBSTITUTE(A5,{1,2,3,4,5,6,7,8,9,0},\"\")=A5),\"No\",\"Yes\")","v":"No"},{"$f":"IF(COUNT(SEARCH({1,2,3,4,5,6,7,8,9,0},A5)),\"Yes\",\"No\")","v":"No"},null,{"$f":"IF(AND(ISERROR(--MID(A5,ROW(INDIRECT(\"1:\"&LEN(A5))),1))),\"No\",\"Yes\")","v":"No"},true,null,null,null,null,null,true,"Alpha",{"$f":"IF(AND(SUBSTITUTE(A5,{1,2,3,4,5,6,7,8,9,0},\"\")=A5),\"Alpha\",\"Numbers\")","v":"Alpha"},{"$f":"BillTry3!B5","v":"Alpha"},true]
["lTSc",{"$f":"IF(AND(SUBSTITUTE(A6,{1,2,3,4,5,6,7,8,9,0},\"\")=A6),\"No\",\"Yes\")","v":"No"},{"$f":"IF(COUNT(SEARCH({1,2,3,4,5,6,7,8,9,0},A6)),\"Yes\",\"No\")","v":"No"},null,{"$f":"IF(AND(ISERROR(--MID(A6,ROW(INDIRECT(\"1:\"&LEN(A6))),1))),\"No\",\"Yes\")","v":"No"},true,null,"Full Book on Array Formula ==>>",null,null,null,true,"Alpha",{"$f":"IF(AND(SUBSTITUTE(A6,{1,2,3,4,5,6,7,8,9,0},\"\")=A6),\"Alpha\",\"Numbers\")","v":"Alpha"},{"$f":"BillTry3!B6","v":"Alpha"},true]
["br86Z5tQ",{"$f":"IF(AND(SUBSTITUTE(A7,{1,2,3,4,5,6,7,8,9,0},\"\")=A7),\"No\",\"Yes\")","v":"Yes"},{"$f":"IF(COUNT(SEARCH({1,2,3,4,5,6,7,8,9,0},A7)),\"Yes\",\"No\")","v":"Yes"},null,{"$f":"IF(AND(ISERROR(--MID(A7,ROW(INDIRECT(\"1:\"&LEN(A7))),1))),\"No\",\"Yes\")","v":"Yes"},true,null,"at Amazon",null,null,null,true,"Numbers",{"$f":"IF(AND(SUBSTITUTE(A7,{1,2,3,4,5,6,7,8,9,0},\"\")=A7),\"Alpha\",\"Numbers\")","v":"Numbers"},{"$f":"BillTry3!B7","v":"Numbers"},true]
["EvdnaBTg",{"$f":"IF(AND(SUBSTITUTE(A8,{1,2,3,4,5,6,7,8,9,0},\"\")=A8),\"No\",\"Yes\")","v":"No"},{"$f":"IF(COUNT(SEARCH({1,2,3,4,5,6,7,8,9,0},A8)),\"Yes\",\"No\")","v":"No"},null,{"$f":"IF(AND(ISERROR(--MID(A8,ROW(INDIRECT(\"1:\"&LEN(A8))),1))),\"No\",\"Yes\")","v":"No"},true,null,"https://www.amazon.com/Shift-Enter-Mastering-Excel-Formulas/dp/1615470077",null,null,null,true,"Alpha",{"$f":"IF(AND(SUBSTITUTE(A8,{1,2,3,4,5,6,7,8,9,0},\"\")=A8),\"Alpha\",\"Numbers\")","v":"Alpha"},{"$f":"BillTry3!B8","v":"Alpha"},true]
["qn17r89f",{"$f":"IF(AND(SUBSTITUTE(A9,{1,2,3,4,5,6,7,8,9,0},\"\")=A9),\"No\",\"Yes\")","v":"Yes"},{"$f":"IF(COUNT(SEARCH({1,2,3,4,5,6,7,8,9,0},A9)),\"Yes\",\"No\")","v":"Yes"},null,{"$f":"IF(AND(ISERROR(--MID(A9,ROW(INDIRECT(\"1:\"&LEN(A9))),1))),\"No\",\"Yes\")","v":"Yes"},true,null,"or at mrexcel.com",null,null,null,true,"Numbers",{"$f":"IF(AND(SUBSTITUTE(A9,{1,2,3,4,5,6,7,8,9,0},\"\")=A9),\"Alpha\",\"Numbers\")","v":"Numbers"},{"$f":"BillTry3!B9","v":"Numbers"},true]
["KsbeLd",{"$f":"IF(AND(SUBSTITUTE(A10,{1,2,3,4,5,6,7,8,9,0},\"\")=A10),\"No\",\"Yes\")","v":"No"},{"$f":"IF(COUNT(SEARCH({1,2,3,4,5,6,7,8,9,0},A10)),\"Yes\",\"No\")","v":"No"},null,{"$f":"IF(AND(ISERROR(--MID(A10,ROW(INDIRECT(\"1:\"&LEN(A10))),1))),\"No\",\"Yes\")","v":"No"},true,null,"http://www.mrexcel.com/store/index.php?l=product_detail&p=263",null,null,null,true,"Alpha",{"$f":"IF(AND(SUBSTITUTE(A10,{1,2,3,4,5,6,7,8,9,0},\"\")=A10),\"Alpha\",\"Numbers\")","v":"Alpha"},{"$f":"BillTry3!B10","v":"Alpha"},true]
["htagh",{"$f":"IF(AND(SUBSTITUTE(A11,{1,2,3,4,5,6,7,8,9,0},\"\")=A11),\"No\",\"Yes\")","v":"No"},{"$f":"IF(COUNT(SEARCH({1,2,3,4,5,6,7,8,9,0},A11)),\"Yes\",\"No\")","v":"No"},null,{"$f":"IF(AND(ISERROR(--MID(A11,ROW(INDIRECT(\"1:\"&LEN(A11))),1))),\"No\",\"Yes\")","v":"No"},true,null,null,null,null,null,true,"Alpha",{"$f":"IF(AND(SUBSTITUTE(A11,{1,2,3,4,5,6,7,8,9,0},\"\")=A11),\"Alpha\",\"Numbers\")","v":"Alpha"},{"$f":"BillTry3!B11","v":"Alpha"},true]
["tjaoEmr",{"$f":"IF(AND(SUBSTITUTE(A12,{1,2,3,4,5,6,7,8,9,0},\"\")=A12),\"No\",\"Yes\")","v":"No"},{"$f":"IF(COUNT(SEARCH({1,2,3,4,5,6,7,8,9,0},A12)),\"Yes\",\"No\")","v":"No"},null,{"$f":"IF(AND(ISERROR(--MID(A12,ROW(INDIRECT(\"1:\"&LEN(A12))),1))),\"No\",\"Yes\")","v":"No"},true,null,null,null,null,null,true,"Alpha",{"$f":"IF(AND(SUBSTITUTE(A12,{1,2,3,4,5,6,7,8,9,0},\"\")=A12),\"Alpha\",\"Numbers\")","v":"Alpha"},{"$f":"BillTry3!B12","v":"Alpha"},true]
["wJnv",{"$f":"IF(AND(SUBSTITUTE(A13,{1,2,3,4,5,6,7,8,9,0},\"\")=A13),\"No\",\"Yes\")","v":"No"},{"$f":"IF(COUNT(SEARCH({1,2,3,4,5,6,7,8,9,0},A13)),\"Yes\",\"No\")","v":"No"},null,{"$f":"IF(AND(ISERROR(--MID(A13,ROW(INDIRECT(\"1:\"&LEN(A13))),1))),\"No\",\"Yes\")","v":"No"},true,null,null,null,null,null,true,"Alpha",{"$f":"IF(AND(SUBSTITUTE(A13,{1,2,3,4,5,6,7,8,9,0},\"\")=A13),\"Alpha\",\"Numbers\")","v":"Alpha"},{"$f":"BillTry3!B13","v":"Alpha"},true]
["Mdotblh",{"$f":"IF(AND(SUBSTITUTE(A14,{1,2,3,4,5,6,7,8,9,0},\"\")=A14),\"No\",\"Yes\")","v":"No"},{"$f":"IF(COUNT(SEARCH({1,2,3,4,5,6,7,8,9,0},A14)),\"Yes\",\"No\")","v":"No"},null,{"$f":"IF(AND(ISERROR(--MID(A14,ROW(INDIRECT(\"1:\"&LEN(A14))),1))),\"No\",\"Yes\")","v":"No"},true,null,null,null,null,null,true,"Alpha",{"$f":"IF(AND(SUBSTITUTE(A14,{1,2,3,4,5,6,7,8,9,0},\"\")=A14),\"Alpha\",\"Numbers\")","v":"Alpha"},{"$f":"BillTry3!B14","v":"Alpha"},true]
["li419",{"$f":"IF(AND(SUBSTITUTE(A15,{1,2,3,4,5,6,7,8,9,0},\"\")=A15),\"No\",\"Yes\")","v":"Yes"},{"$f":"IF(COUNT(SEARCH({1,2,3,4,5,6,7,8,9,0},A15)),\"Yes\",\"No\")","v":"Yes"},null,{"$f":"IF(AND(ISERROR(--MID(A15,ROW(INDIRECT(\"1:\"&LEN(A15))),1))),\"No\",\"Yes\")","v":"Yes"},true,null,null,null,null,null,true,"Numbers",{"$f":"IF(AND(SUBSTITUTE(A15,{1,2,3,4,5,6,7,8,9,0},\"\")=A15),\"Alpha\",\"Numbers\")","v":"Numbers"},{"$f":"BillTry3!B15","v":"Numbers"},true]
["S0Hh8",{"$f":"IF(AND(SUBSTITUTE(A16,{1,2,3,4,5,6,7,8,9,0},\"\")=A16),\"No\",\"Yes\")","v":"Yes"},{"$f":"IF(COUNT(SEARCH({1,2,3,4,5,6,7,8,9,0},A16)),\"Yes\",\"No\")","v":"Yes"},null,{"$f":"IF(AND(ISERROR(--MID(A16,ROW(INDIRECT(\"1:\"&LEN(A16))),1))),\"No\",\"Yes\")","v":"Yes"},true,null,null,null,null,null,true,"Numbers",{"$f":"IF(AND(SUBSTITUTE(A16,{1,2,3,4,5,6,7,8,9,0},\"\")=A16),\"Alpha\",\"Numbers\")","v":"Numbers"},{"$f":"BillTry3!B16","v":"Numbers"},true]
["0TuW",{"$f":"IF(AND(SUBSTITUTE(A17,{1,2,3,4,5,6,7,8,9,0},\"\")=A17),\"No\",\"Yes\")","v":"Yes"},{"$f":"IF(COUNT(SEARCH({1,2,3,4,5,6,7,8,9,0},A17)),\"Yes\",\"No\")","v":"Yes"},null,{"$f":"IF(AND(ISERROR(--MID(A17,ROW(INDIRECT(\"1:\"&LEN(A17))),1))),\"No\",\"Yes\")","v":"Yes"},true,null,null,null,null,null,true,"Numbers",{"$f":"IF(AND(SUBSTITUTE(A17,{1,2,3,4,5,6,7,8,9,0},\"\")=A17),\"Alpha\",\"Numbers\")","v":"Numbers"},{"$f":"BillTry3!B17","v":"Numbers"},true]
["hPdJtAgK",{"$f":"IF(AND(SUBSTITUTE(A18,{1,2,3,4,5,6,7,8,9,0},\"\")=A18),\"No\",\"Yes\")","v":"No"},{"$f":"IF(COUNT(SEARCH({1,2,3,4,5,6,7,8,9,0},A18)),\"Yes\",\"No\")","v":"No"},null,{"$f":"IF(AND(ISERROR(--MID(A18,ROW(INDIRECT(\"1:\"&LEN(A18))),1))),\"No\",\"Yes\")","v":"No"},true,null,null,null,null,null,true,"Alpha",{"$f":"IF(AND(SUBSTITUTE(A18,{1,2,3,4,5,6,7,8,9,0},\"\")=A18),\"Alpha\",\"Numbers\")","v":"Alpha"},{"$f":"BillTry3!B18","v":"Alpha"},true]
["gpRqr",{"$f":"IF(AND(SUBSTITUTE(A19,{1,2,3,4,5,6,7,8,9,0},\"\")=A19),\"No\",\"Yes\")","v":"No"},{"$f":"IF(COUNT(SEARCH({1,2,3,4,5,6,7,8,9,0},A19)),\"Yes\",\"No\")","v":"No"},null,{"$f":"IF(AND(ISERROR(--MID(A19,ROW(INDIRECT(\"1:\"&LEN(A19))),1))),\"No\",\"Yes\")","v":"No"},true,null,null,null,null,null,true,"Alpha",{"$f":"IF(AND(SUBSTITUTE(A19,{1,2,3,4,5,6,7,8,9,0},\"\")=A19),\"Alpha\",\"Numbers\")","v":"Alpha"},{"$f":"BillTry3!B19","v":"Alpha"},true]
["tXzcZ",{"$f":"IF(AND(SUBSTITUTE(A20,{1,2,3,4,5,6,7,8,9,0},\"\")=A20),\"No\",\"Yes\")","v":"No"},{"$f":"IF(COUNT(SEARCH({1,2,3,4,5,6,7,8,9,0},A20)),\"Yes\",\"No\")","v":"No"},null,{"$f":"IF(AND(ISERROR(--MID(A20,ROW(INDIRECT(\"1:\"&LEN(A20))),1))),\"No\",\"Yes\")","v":"No"},true,null,null,null,null,null,true,"Alpha",{"$f":"IF(AND(SUBSTITUTE(A20,{1,2,3,4,5,6,7,8,9,0},\"\")=A20),\"Alpha\",\"Numbers\")","v":"Alpha"},{"$f":"BillTry3!B20","v":"Alpha"},true]
["uQIymo",{"$f":"IF(AND(SUBSTITUTE(A21,{1,2,3,4,5,6,7,8,9,0},\"\")=A21),\"No\",\"Yes\")","v":"No"},{"$f":"IF(COUNT(SEARCH({1,2,3,4,5,6,7,8,9,0},A21)),\"Yes\",\"No\")","v":"No"},null,{"$f":"IF(AND(ISERROR(--MID(A21,ROW(INDIRECT(\"1:\"&LEN(A21))),1))),\"No\",\"Yes\")","v":"No"},true,null,null,null,null,null,true,"Alpha",{"$f":"IF(AND(SUBSTITUTE(A21,{1,2,3,4,5,6,7,8,9,0},\"\")=A21),\"Alpha\",\"Numbers\")","v":"Alpha"},{"$f":"BillTry3!B21","v":"Alpha"},true]
["i8v08",{"$f":"IF(AND(SUBSTITUTE(A22,{1,2,3,4,5,6,7,8,9,0},\"\")=A22),\"No\",\"Yes\")","v":"Yes"},{"$f":"IF(COUNT(SEARCH({1,2,3,4,5,6,7,8,9,0},A22)),\"Yes\",\"No\")","v":"Yes"},null,{"$f":"IF(AND(ISERROR(--MID(A22,ROW(INDIRECT(\"1:\"&LEN(A22))),1))),\"No\",\"Yes\")","v":"Yes"},true,null,null,null,null,null,true,"Numbers",{"$f":"IF(AND(SUBSTITUTE(A22,{1,2,3,4,5,6,7,8,9,0},\"\")=A22),\"Alpha\",\"Numbers\")","v":"Numbers"},{"$f":"BillTry3!B22","v":"Numbers"},true]
["dLKBb",{"$f":"IF(AND(SUBSTITUTE(A23,{1,2,3,4,5,6,7,8,9,0},\"\")=A23),\"No\",\"Yes\")","v":"No"},{"$f":"IF(COUNT(SEARCH({1,2,3,4,5,6,7,8,9,0},A23)),\"Yes\",\"No\")","v":"No"},null,{"$f":"IF(AND(ISERROR(--MID(A23,ROW(INDIRECT(\"1:\"&LEN(A23))),1))),\"No\",\"Yes\")","v":"No"},true,null,null,null,null,null,true,"Alpha",{"$f":"IF(AND(SUBSTITUTE(A23,{1,2,3,4,5,6,7,8,9,0},\"\")=A23),\"Alpha\",\"Numbers\")","v":"Alpha"},{"$f":"BillTry3!B23","v":"Alpha"},true]
["0DeBe1Lb",{"$f":"IF(AND(SUBSTITUTE(A24,{1,2,3,4,5,6,7,8,9,0},\"\")=A24),\"No\",\"Yes\")","v":"Yes"},{"$f":"IF(COUNT(SEARCH({1,2,3,4,5,6,7,8,9,0},A24)),\"Yes\",\"No\")","v":"Yes"},null,{"$f":"IF(AND(ISERROR(--MID(A24,ROW(INDIRECT(\"1:\"&LEN(A24))),1))),\"No\",\"Yes\")","v":"Yes"},true,null,null,null,null,null,true,"Numbers",{"$f":"IF(AND(SUBSTITUTE(A24,{1,2,3,4,5,6,7,8,9,0},\"\")=A24),\"Alpha\",\"Numbers\")","v":"Numbers"},{"$f":"BillTry3!B24","v":"Numbers"},true]
["ldwD",{"$f":"IF(AND(SUBSTITUTE(A25,{1,2,3,4,5,6,7,8,9,0},\"\")=A25),\"No\",\"Yes\")","v":"No"},{"$f":"IF(COUNT(SEARCH({1,2,3,4,5,6,7,8,9,0},A25)),\"Yes\",\"No\")","v":"No"},null,{"$f":"IF(AND(ISERROR(--MID(A25,ROW(INDIRECT(\"1:\"&LEN(A25))),1))),\"No\",\"Yes\")","v":"No"},true,null,null,null,null,null,true,"Alpha",{"$f":"IF(AND(SUBSTITUTE(A25,{1,2,3,4,5,6,7,8,9,0},\"\")=A25),\"Alpha\",\"Numbers\")","v":"Alpha"},{"$f":"BillTry3!B25","v":"Alpha"},true]
["cycNV",{"$f":"IF(AND(SUBSTITUTE(A26,{1,2,3,4,5,6,7,8,9,0},\"\")=A26),\"No\",\"Yes\")","v":"No"},{"$f":"IF(COUNT(SEARCH({1,2,3,4,5,6,7,8,9,0},A26)),\"Yes\",\"No\")","v":"No"},null,{"$f":"IF(AND(ISERROR(--MID(A26,ROW(INDIRECT(\"1:\"&LEN(A26))),1))),\"No\",\"Yes\")","v":"No"},true,null,null,null,null,null,true,"Alpha",{"$f":"IF(AND(SUBSTITUTE(A26,{1,2,3,4,5,6,7,8,9,0},\"\")=A26),\"Alpha\",\"Numbers\")","v":"Alpha"},{"$f":"BillTry3!B26","v":"Alpha"},true]
["xMLGtc",{"$f":"IF(AND(SUBSTITUTE(A27,{1,2,3,4,5,6,7,8,9,0},\"\")=A27),\"No\",\"Yes\")","v":"No"},{"$f":"IF(COUNT(SEARCH({1,2,3,4,5,6,7,8,9,0},A27)),\"Yes\",\"No\")","v":"No"},null,{"$f":"IF(AND(ISERROR(--MID(A27,ROW(INDIRECT(\"1:\"&LEN(A27))),1))),\"No\",\"Yes\")","v":"No"},true,null,null,null,null,null,true,"Alpha",{"$f":"IF(AND(SUBSTITUTE(A27,{1,2,3,4,5,6,7,8,9,0},\"\")=A27),\"Alpha\",\"Numbers\")","v":"Alpha"},{"$f":"BillTry3!B27","v":"Alpha"},true]
["VvnP",{"$f":"IF(AND(SUBSTITUTE(A28,{1,2,3,4,5,6,7,8,9,0},\"\")=A28),\"No\",\"Yes\")","v":"No"},{"$f":"IF(COUNT(SEARCH({1,2,3,4,5,6,7,8,9,0},A28)),\"Yes\",\"No\")","v":"No"},null,{"$f":"IF(AND(ISERROR(--MID(A28,ROW(INDIRECT(\"1:\"&LEN(A28))),1))),\"No\",\"Yes\")","v":"No"},true,null,null,null,null,null,true,"Alpha",{"$f":"IF(AND(SUBSTITUTE(A28,{1,2,3,4,5,6,7,8,9,0},\"\")=A28),\"Alpha\",\"Numbers\")","v":"Alpha"},{"$f":"BillTry3!B28","v":"Alpha"},true]
["3sFY9Q",{"$f":"IF(AND(SUBSTITUTE(A29,{1,2,3,4,5,6,7,8,9,0},\"\")=A29),\"No\",\"Yes\")","v":"Yes"},{"$f":"IF(COUNT(SEARCH({1,2,3,4,5,6,7,8,9,0},A29)),\"Yes\",\"No\")","v":"Yes"},null,{"$f":"IF(AND(ISERROR(--MID(A29,ROW(INDIRECT(\"1:\"&LEN(A29))),1))),\"No\",\"Yes\")","v":"Yes"},true,null,null,null,null,null,true,"Numbers",{"$f":"IF(AND(SUBSTITUTE(A29,{1,2,3,4,5,6,7,8,9,0},\"\")=A29),\"Alpha\",\"Numbers\")","v":"Numbers"},{"$f":"BillTry3!B29","v":"Numbers"},true]
["oBjq",{"$f":"IF(AND(SUBSTITUTE(A30,{1,2,3,4,5,6,7,8,9,0},\"\")=A30),\"No\",\"Yes\")","v":"No"},{"$f":"IF(COUNT(SEARCH({1,2,3,4,5,6,7,8,9,0},A30)),\"Yes\",\"No\")","v":"No"},null,{"$f":"IF(AND(ISERROR(--MID(A30,ROW(INDIRECT(\"1:\"&LEN(A30))),1))),\"No\",\"Yes\")","v":"No"},true,null,null,null,null,null,true,"Alpha",{"$f":"IF(AND(SUBSTITUTE(A30,{1,2,3,4,5,6,7,8,9,0},\"\")=A30),\"Alpha\",\"Numbers\")","v":"Alpha"},{"$f":"BillTry3!B30","v":"Alpha"},true]
["TlnTzkK",{"$f":"IF(AND(SUBSTITUTE(A31,{1,2,3,4,5,6,7,8,9,0},\"\")=A31),\"No\",\"Yes\")","v":"No"},{"$f":"IF(COUNT(SEARCH({1,2,3,4,5,6,7,8,9,0},A31)),\"Yes\",\"No\")","v":"No"},null,{"$f":"IF(AND(ISERROR(--MID(A31,ROW(INDIRECT(\"1:\"&LEN(A31))),1))),\"No\",\"Yes\")","v":"No"},true,null,null,null,null,null,true,"Alpha",{"$f":"IF(AND(SUBSTITUTE(A31,{1,2,3,4,5,6,7,8,9,0},\"\")=A31),\"Alpha\",\"Numbers\")","v":"Alpha"},{"$f":"BillTry3!B31","v":"Alpha"},true]
["Dl3t6EJ",{"$f":"IF(AND(SUBSTITUTE(A32,{1,2,3,4,5,6,7,8,9,0},\"\")=A32),\"No\",\"Yes\")","v":"Yes"},{"$f":"IF(COUNT(SEARCH({1,2,3,4,5,6,7,8,9,0},A32)),\"Yes\",\"No\")","v":"Yes"},null,{"$f":"IF(AND(ISERROR(--MID(A32,ROW(INDIRECT(\"1:\"&LEN(A32))),1))),\"No\",\"Yes\")","v":"Yes"},true,null,null,null,null,null,true,"Numbers",{"$f":"IF(AND(SUBSTITUTE(A32,{1,2,3,4,5,6,7,8,9,0},\"\")=A32),\"Alpha\",\"Numbers\")","v":"Numbers"},{"$f":"BillTry3!B32","v":"Numbers"},true]
["2tI4Dd",{"$f":"IF(AND(SUBSTITUTE(A33,{1,2,3,4,5,6,7,8,9,0},\"\")=A33),\"No\",\"Yes\")","v":"Yes"},{"$f":"IF(COUNT(SEARCH({1,2,3,4,5,6,7,8,9,0},A33)),\"Yes\",\"No\")","v":"Yes"},null,{"$f":"IF(AND(ISERROR(--MID(A33,ROW(INDIRECT(\"1:\"&LEN(A33))),1))),\"No\",\"Yes\")","v":"Yes"},true,null,null,null,null,null,true,"Numbers",{"$f":"IF(AND(SUBSTITUTE(A33,{1,2,3,4,5,6,7,8,9,0},\"\")=A33),\"Alpha\",\"Numbers\")","v":"Numbers"},{"$f":"BillTry3!B33","v":"Numbers"},true]
["DHt1VV7hh",{"$f":"IF(AND(SUBSTITUTE(A34,{1,2,3,4,5,6,7,8,9,0},\"\")=A34),\"No\",\"Yes\")","v":"Yes"},{"$f":"IF(COUNT(SEARCH({1,2,3,4,5,6,7,8,9,0},A34)),\"Yes\",\"No\")","v":"Yes"},null,{"$f":"IF(AND(ISERROR(--MID(A34,ROW(INDIRECT(\"1:\"&LEN(A34))),1))),\"No\",\"Yes\")","v":"Yes"},true,null,null,null,null,null,true,"Numbers",{"$f":"IF(AND(SUBSTITUTE(A34,{1,2,3,4,5,6,7,8,9,0},\"\")=A34),\"Alpha\",\"Numbers\")","v":"Numbers"},{"$f":"BillTry3!B34","v":"Numbers"},true]
["IRpsK",{"$f":"IF(AND(SUBSTITUTE(A35,{1,2,3,4,5,6,7,8,9,0},\"\")=A35),\"No\",\"Yes\")","v":"No"},{"$f":"IF(COUNT(SEARCH({1,2,3,4,5,6,7,8,9,0},A35)),\"Yes\",\"No\")","v":"No"},null,{"$f":"IF(AND(ISERROR(--MID(A35,ROW(INDIRECT(\"1:\"&LEN(A35))),1))),\"No\",\"Yes\")","v":"No"},true,null,null,null,null,null,true,"Alpha",{"$f":"IF(AND(SUBSTITUTE(A35,{1,2,3,4,5,6,7,8,9,0},\"\")=A35),\"Alpha\",\"Numbers\")","v":"Alpha"},{"$f":"BillTry3!B35","v":"Alpha"},true]
["uleVVx",{"$f":"IF(AND(SUBSTITUTE(A36,{1,2,3,4,5,6,7,8,9,0},\"\")=A36),\"No\",\"Yes\")","v":"No"},{"$f":"IF(COUNT(SEARCH({1,2,3,4,5,6,7,8,9,0},A36)),\"Yes\",\"No\")","v":"No"},null,{"$f":"IF(AND(ISERROR(--MID(A36,ROW(INDIRECT(\"1:\"&LEN(A36))),1))),\"No\",\"Yes\")","v":"No"},true,null,null,null,null,null,true,"Alpha",{"$f":"IF(AND(SUBSTITUTE(A36,{1,2,3,4,5,6,7,8,9,0},\"\")=A36),\"Alpha\",\"Numbers\")","v":"Alpha"},{"$f":"BillTry3!B36","v":"Alpha"},true]
["ufuOTKpV",{"$f":"IF(AND(SUBSTITUTE(A37,{1,2,3,4,5,6,7,8,9,0},\"\")=A37),\"No\",\"Yes\")","v":"No"},{"$f":"IF(COUNT(SEARCH({1,2,3,4,5,6,7,8,9,0},A37)),\"Yes\",\"No\")","v":"No"},null,{"$f":"IF(AND(ISERROR(--MID(A37,ROW(INDIRECT(\"1:\"&LEN(A37))),1))),\"No\",\"Yes\")","v":"No"},true,null,null,null,null,null,true,"Alpha",{"$f":"IF(AND(SUBSTITUTE(A37,{1,2,3,4,5,6,7,8,9,0},\"\")=A37),\"Alpha\",\"Numbers\")","v":"Alpha"},{"$f":"BillTry3!B37","v":"Alpha"},true]
["gUjp2C",{"$f":"IF(AND(SUBSTITUTE(A38,{1,2,3,4,5,6,7,8,9,0},\"\")=A38),\"No\",\"Yes\")","v":"Yes"},{"$f":"IF(COUNT(SEARCH({1,2,3,4,5,6,7,8,9,0},A38)),\"Yes\",\"No\")","v":"Yes"},null,{"$f":"IF(AND(ISERROR(--MID(A38,ROW(INDIRECT(\"1:\"&LEN(A38))),1))),\"No\",\"Yes\")","v":"Yes"},true,null,null,null,null,null,true,"Numbers",{"$f":"IF(AND(SUBSTITUTE(A38,{1,2,3,4,5,6,7,8,9,0},\"\")=A38),\"Alpha\",\"Numbers\")","v":"Numbers"},{"$f":"BillTry3!B38","v":"Numbers"},true]
["UBfUp",{"$f":"IF(AND(SUBSTITUTE(A39,{1,2,3,4,5,6,7,8,9,0},\"\")=A39),\"No\",\"Yes\")","v":"No"},{"$f":"IF(COUNT(SEARCH({1,2,3,4,5,6,7,8,9,0},A39)),\"Yes\",\"No\")","v":"No"},null,{"$f":"IF(AND(ISERROR(--MID(A39,ROW(INDIRECT(\"1:\"&LEN(A39))),1))),\"No\",\"Yes\")","v":"No"},true,null,null,null,null,null,true,"Alpha",{"$f":"IF(AND(SUBSTITUTE(A39,{1,2,3,4,5,6,7,8,9,0},\"\")=A39),\"Alpha\",\"Numbers\")","v":"Alpha"},{"$f":"BillTry3!B39","v":"Alpha"},true]
["C5GDH",{"$f":"IF(AND(SUBSTITUTE(A40,{1,2,3,4,5,6,7,8,9,0},\"\")=A40),\"No\",\"Yes\")","v":"Yes"},{"$f":"IF(COUNT(SEARCH({1,2,3,4,5,6,7,8,9,0},A40)),\"Yes\",\"No\")","v":"Yes"},null,{"$f":"IF(AND(ISERROR(--MID(A40,ROW(INDIRECT(\"1:\"&LEN(A40))),1))),\"No\",\"Yes\")","v":"Yes"},true,null,null,null,null,null,true,"Numbers",{"$f":"IF(AND(SUBSTITUTE(A40,{1,2,3,4,5,6,7,8,9,0},\"\")=A40),\"Alpha\",\"Numbers\")","v":"Numbers"},{"$f":"BillTry3!B40","v":"Numbers"},true]
["QDfWg",{"$f":"IF(AND(SUBSTITUTE(A41,{1,2,3,4,5,6,7,8,9,0},\"\")=A41),\"No\",\"Yes\")","v":"No"},{"$f":"IF(COUNT(SEARCH({1,2,3,4,5,6,7,8,9,0},A41)),\"Yes\",\"No\")","v":"No"},null,{"$f":"IF(AND(ISERROR(--MID(A41,ROW(INDIRECT(\"1:\"&LEN(A41))),1))),\"No\",\"Yes\")","v":"No"},true,null,null,null,null,null,true,"Alpha",{"$f":"IF(AND(SUBSTITUTE(A41,{1,2,3,4,5,6,7,8,9,0},\"\")=A41),\"Alpha\",\"Numbers\")","v":"Alpha"},{"$f":"BillTry3!B41","v":"Alpha"},true]
["NO488B1",{"$f":"IF(AND(SUBSTITUTE(A42,{1,2,3,4,5,6,7,8,9,0},\"\")=A42),\"No\",\"Yes\")","v":"Yes"},{"$f":"IF(COUNT(SEARCH({1,2,3,4,5,6,7,8,9,0},A42)),\"Yes\",\"No\")","v":"Yes"},null,{"$f":"IF(AND(ISERROR(--MID(A42,ROW(INDIRECT(\"1:\"&LEN(A42))),1))),\"No\",\"Yes\")","v":"Yes"},true,null,null,null,null,null,true,"Numbers",{"$f":"IF(AND(SUBSTITUTE(A42,{1,2,3,4,5,6,7,8,9,0},\"\")=A42),\"Alpha\",\"Numbers\")","v":"Numbers"},{"$f":"BillTry3!B42","v":"Numbers"},true]
["HpcMQEJKV",{"$f":"IF(AND(SUBSTITUTE(A43,{1,2,3,4,5,6,7,8,9,0},\"\")=A43),\"No\",\"Yes\")","v":"No"},{"$f":"IF(COUNT(SEARCH({1,2,3,4,5,6,7,8,9,0},A43)),\"Yes\",\"No\")","v":"No"},null,{"$f":"IF(AND(ISERROR(--MID(A43,ROW(INDIRECT(\"1:\"&LEN(A43))),1))),\"No\",\"Yes\")","v":"No"},true,null,null,null,null,null,true,"Alpha",{"$f":"IF(AND(SUBSTITUTE(A43,{1,2,3,4,5,6,7,8,9,0},\"\")=A43),\"Alpha\",\"Numbers\")","v":"Alpha"},{"$f":"BillTry3!B43","v":"Alpha"},true]
["640586Xk7",{"$f":"IF(AND(SUBSTITUTE(A44,{1,2,3,4,5,6,7,8,9,0},\"\")=A44),\"No\",\"Yes\")","v":"Yes"},{"$f":"IF(COUNT(SEARCH({1,2,3,4,5,6,7,8,9,0},A44)),\"Yes\",\"No\")","v":"Yes"},null,{"$f":"IF(AND(ISERROR(--MID(A44,ROW(INDIRECT(\"1:\"&LEN(A44))),1))),\"No\",\"Yes\")","v":"Yes"},true,null,null,null,null,null,true,"Numbers",{"$f":"IF(AND(SUBSTITUTE(A44,{1,2,3,4,5,6,7,8,9,0},\"\")=A44),\"Alpha\",\"Numbers\")","v":"Numbers"},{"$f":"BillTry3!B44","v":"Numbers"},true]
["bGKvynJQd",{"$f":"IF(AND(SUBSTITUTE(A45,{1,2,3,4,5,6,7,8,9,0},\"\")=A45),\"No\",\"Yes\")","v":"No"},{"$f":"IF(COUNT(SEARCH({1,2,3,4,5,6,7,8,9,0},A45)),\"Yes\",\"No\")","v":"No"},null,{"$f":"IF(AND(ISERROR(--MID(A45,ROW(INDIRECT(\"1:\"&LEN(A45))),1))),\"No\",\"Yes\")","v":"No"},true,null,null,null,null,null,true,"Alpha",{"$f":"IF(AND(SUBSTITUTE(A45,{1,2,3,4,5,6,7,8,9,0},\"\")=A45),\"Alpha\",\"Numbers\")","v":"Alpha"},{"$f":"BillTry3!B45","v":"Alpha"},true]

{"sheet":"BillTry3","index":4,"n_rows":45,"n_cols":4,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
["Code","Result"]
["BXB0",{"$f":"HasNumbers(A2)","v":"Numbers"},{"$f":"IF(AND(SUBSTITUTE(A2,{1,2,3,4,5,6,7,8,9,0},\"\")),\"Alpha\",\"Numbers\")","v":{"$error":"#VALUE!"}},{"$f":"A2=MikeTry!A2","v":true}]
["wSEP9",{"$f":"HasNumbers(A3)","v":"Numbers"},null,{"$f":"A3=MikeTry!A3","v":true}]
["Hwkj","Alpha",null,{"$f":"A4=MikeTry!A4","v":true}]
["RcdgM","Alpha",null,{"$f":"A5=MikeTry!A5","v":true}]
["lTSc","Alpha",null,{"$f":"A6=MikeTry!A6","v":true}]
["br86Z5tQ","Numbers",null,{"$f":"A7=MikeTry!A7","v":true}]
["EvdnaBTg","Alpha",null,{"$f":"A8=MikeTry!A8","v":true}]
["qn17r89f","Numbers",null,{"$f":"A9=MikeTry!A9","v":true}]
["KsbeLd","Alpha",null,{"$f":"A10=MikeTry!A10","v":true}]
["htagh","Alpha",null,{"$f":"A11=MikeTry!A11","v":true}]
["tjaoEmr","Alpha",null,{"$f":"A12=MikeTry!A12","v":true}]
["wJnv","Alpha",null,{"$f":"A13=MikeTry!A13","v":true}]
["Mdotblh","Alpha",null,{"$f":"A14=MikeTry!A14","v":true}]
["li419","Numbers",null,{"$f":"A15=MikeTry!A15","v":true}]
["S0Hh8","Numbers",null,{"$f":"A16=MikeTry!A16","v":true}]
["0TuW","Numbers",null,{"$f":"A17=MikeTry!A17","v":true}]
["hPdJtAgK","Alpha",null,{"$f":"A18=MikeTry!A18","v":true}]
["gpRqr","Alpha",null,{"$f":"A19=MikeTry!A19","v":true}]
["tXzcZ","Alpha",null,{"$f":"A20=MikeTry!A20","v":true}]
["uQIymo","Alpha",null,{"$f":"A21=MikeTry!A21","v":true}]
["i8v08","Numbers",null,{"$f":"A22=MikeTry!A22","v":true}]
["dLKBb","Alpha",null,{"$f":"A23=MikeTry!A23","v":true}]
["0DeBe1Lb","Numbers",null,{"$f":"A24=MikeTry!A24","v":true}]
["ldwD","Alpha",null,{"$f":"A25=MikeTry!A25","v":true}]
["cycNV","Alpha",null,{"$f":"A26=MikeTry!A26","v":true}]
["xMLGtc","Alpha",null,{"$f":"A27=MikeTry!A27","v":true}]
["VvnP","Alpha",null,{"$f":"A28=MikeTry!A28","v":true}]
["3sFY9Q","Numbers",null,{"$f":"A29=MikeTry!A29","v":true}]
["oBjq","Alpha",null,{"$f":"A30=MikeTry!A30","v":true}]
["TlnTzkK","Alpha",null,{"$f":"A31=MikeTry!A31","v":true}]
["Dl3t6EJ","Numbers",null,{"$f":"A32=MikeTry!A32","v":true}]
["2tI4Dd","Numbers",null,{"$f":"A33=MikeTry!A33","v":true}]
["DHt1VV7hh","Numbers",null,{"$f":"A34=MikeTry!A34","v":true}]
["IRpsK","Alpha",null,{"$f":"A35=MikeTry!A35","v":true}]
["uleVVx","Alpha",null,{"$f":"A36=MikeTry!A36","v":true}]
["ufuOTKpV","Alpha",null,{"$f":"A37=MikeTry!A37","v":true}]
["gUjp2C","Numbers",null,{"$f":"A38=MikeTry!A38","v":true}]
["UBfUp","Alpha",null,{"$f":"A39=MikeTry!A39","v":true}]
["C5GDH","Numbers",null,{"$f":"A40=MikeTry!A40","v":true}]
["QDfWg","Alpha",null,{"$f":"A41=MikeTry!A41","v":true}]
["NO488B1","Numbers",null,{"$f":"A42=MikeTry!A42","v":true}]
["HpcMQEJKV","Alpha",null,{"$f":"A43=MikeTry!A43","v":true}]
["640586Xk7","Numbers",null,{"$f":"A44=MikeTry!A44","v":true}]
["bGKvynJQd","Alpha",null,{"$f":"A45=MikeTry!A45","v":true}]

{"sheet":"Cover","index":5,"n_rows":5,"n_cols":12,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Dueling Excel: Mr Excel & excelisfun"]
["Mr Excel & excelisfun Trick 186 "]
["Does Text Contain Number Digits?"]
[]
[null,"Flash Fill",null,null,null,"Formula",null,null,null,null,null,"VBA"]