{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Title","Data","Replace","VLOOKUP","Wrap Up"],"not_rendered":{"charts":0,"images":7,"macros":1,"external_links":1,"defined_names":49,"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":25,"n_cols":13,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,2088]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Image credit: theforexscorpion / Pixabay"]

{"sheet":"Data","index":1,"n_rows":68,"n_cols":3,"rows_kept":68,"cut":false,"hidden":false,"merged":[]}
["Phrase","Qty","Revenue"]
["only ^ on",200,17800]
["don't # them",400,35600]
["before % i'm",500,44500]
["having # for",200,17800]
["most ! those",300,26700]
["such # until",100,8900]
["by ? he's",300,26700]
["for # further",300,26700]
["they'd ~ for",400,35600]
["some ? during",300,26700]
["few ! for",100,8900]
["can't * i",400,35600]
["over * out",500,44500]
["but * those",500,44500]
["her ? Down",400,35600]
["itself % some",200,17800]
["she'll @ there's",400,35600]
["himself & he",100,8900]
["they'll % once",500,44500]
["below & each",500,44500]
["its ^ down",500,44500]
["been # there",500,44500]
["he'll % hasn't",400,35600]
["until & be",200,17800]
["own @ its",100,8900]
["from @ she'd",500,44500]
["she % those",300,26700]
["no ~ has",500,44500]
["haven't * i",300,26700]
["here's ~ it",200,17800]
["he'd ? he'd",200,17800]
["she'd ^ i'd",400,35600]
["didn't ~ such",200,17800]
["shan't & do",300,26700]
["could ~ during",500,44500]
["i'm @ can't",500,44500]
["more & how",200,17800]
["couldn't ! shan't",200,17800]
["it ~ couldn't",400,35600]
["how's ! they're",500,44500]
["itself # had",100,8900]
["they'll & she'd",200,17800]
["they'll ^ by",200,17800]
["these % once",100,8900]
["until & is",300,26700]
["most & cannot",300,26700]
["that ! such",400,35600]
["its # between",500,44500]
["herself ? only",200,17800]
["they'll # been",300,26700]
["they'll @ there",500,44500]
["both ! itself",100,8900]
["but ~ from",400,35600]
["ourselves ~~ does",300,26700]
["ourselves & there",400,35600]
["had # she's",500,44500]
["some # let's",300,26700]
["such * more",400,35600]
["few ~ under",300,26700]
["did % own",500,44500]
["he'll ^ has",100,8900]
["she'll ! few",200,17800]
["is ~ because",200,17800]
["most * that",400,35600]
["himself ^ they'll",100,8900]
["further * she",500,44500]
["having @ hasn't",500,44500]

{"sheet":"Replace","index":2,"n_rows":68,"n_cols":3,"rows_kept":68,"cut":false,"hidden":false,"merged":[]}
["Phrase","Qty","Revenue"]
["only ^ on",200,17800]
["don't # them",400,35600]
["before % i'm",500,44500]
["having # for",200,17800]
["most ! those",300,26700]
["such # until",100,8900]
["by ~* he's",300,26700]
["for # further",300,26700]
["they'd ~ for",400,35600]
["some ~* during",300,26700]
["few ! for",100,8900]
["can't * i",400,35600]
["over * out",500,44500]
["but * those",500,44500]
["her ~* down",400,35600]
["itself % some",200,17800]
["she'll @ there's",400,35600]
["himself & he",100,8900]
["they'll % once",500,44500]
["below & each",500,44500]
["its ^ down",500,44500]
["been # there",500,44500]
["he'll % hasn't",400,35600]
["until & be",200,17800]
["own @ its",100,8900]
["from @ she'd",500,44500]
["she % those",300,26700]
["no ~ has",500,44500]
["haven't * i",300,26700]
["here's ~ it",200,17800]
["he'd ~* he'd",200,17800]
["she'd ^ i'd",400,35600]
["didn't ~ such",200,17800]
["shan't & do",300,26700]
["could ~ during",500,44500]
["i'm @ can't",500,44500]
["more & how",200,17800]
["couldn't ! shan't",200,17800]
["it ~ couldn't",400,35600]
["how's ! they're",500,44500]
["itself # had",100,8900]
["they'll & she'd",200,17800]
["they'll ^ by",200,17800]
["these % once",100,8900]
["until & is",300,26700]
["most & cannot",300,26700]
["that ! such",400,35600]
["its # between",500,44500]
["herself ~* only",200,17800]
["they'll # been",300,26700]
["they'll @ there",500,44500]
["both ! itself",100,8900]
["but ~ from",400,35600]
["ourselves ~ does",300,26700]
["ourselves & there",400,35600]
["had # she's",500,44500]
["some # let's",300,26700]
["such * more",400,35600]
["few ~ under",300,26700]
["did % own",500,44500]
["he'll ^ has",100,8900]
["she'll ! few",200,17800]
["is ~ because",200,17800]
["most * that",400,35600]
["himself ^ they'll",100,8900]
["further * she",500,44500]
["having @ hasn't",500,44500]

{"sheet":"VLOOKUP","index":3,"n_rows":10,"n_cols":7,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Phrase","Qty"]
["Wallingworldmart",{"$f":"(ROW()-1)*10","v":10},null,null,"Wal*Mart",{"$f":"VLOOKUP(E2,$A$2:$B$7,2,FALSE)","v":10},{"$f":"_xlfn.FORMULATEXT(F2)","v":"=VLOOKUP(E2,$A$2:$B$7,2,FALSE)"}]
["Wal*Mart",20,null,null,"Question?Mark",{"$f":"VLOOKUP(E3,$A$2:$B$7,2,FALSE)","v":30},{"$f":"_xlfn.FORMULATEXT(F3)","v":"=VLOOKUP(E3,$A$2:$B$7,2,FALSE)"}]
["QuestionAMark",30,null,null,"Tilde~There",{"$f":"VLOOKUP(E4,$A$2:$B$7,2,FALSE)","v":50},{"$f":"_xlfn.FORMULATEXT(F4)","v":"=VLOOKUP(E4,$A$2:$B$7,2,FALSE)"}]
["Question?Mark",40]
["TildeThere",50]
["Tilde~There",60]
[null,null,null,null,"Wal~*Mart",{"$f":"VLOOKUP(E8,$A$2:$B$7,2,FALSE)","v":20},{"$f":"_xlfn.FORMULATEXT(F8)","v":"=VLOOKUP(E8,$A$2:$B$7,2,FALSE)"}]
[null,null,null,null,"Question~?Mark",{"$f":"VLOOKUP(E9,$A$2:$B$7,2,FALSE)","v":40},{"$f":"_xlfn.FORMULATEXT(F9)","v":"=VLOOKUP(E9,$A$2:$B$7,2,FALSE)"}]
[null,null,null,null,"Tilde~~There",{"$f":"VLOOKUP(E10,$A$2:$B$7,2,FALSE)","v":60},{"$f":"_xlfn.FORMULATEXT(F10)","v":"=VLOOKUP(E10,$A$2:$B$7,2,FALSE)"}]

{"sheet":"Wrap Up","index":4,"n_rows":14,"n_cols":2,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["Topics in this Episode"]
[]
[null,"Search box in Filter lets you look for # or @"]
[null,"But if fails when you try to search for * or ~ or ?"]
[null,"Using the Search box in Filter, you want to find an asterisk *"]
[null,"Using the Search box in Filter, you want to find a tilde ~"]
[null,"Using the Search box in Filter, you want to find a ?"]
[null,"Excel returns everything for the * and nothing for ? ~"]
[null,"To search for an asterisk, search for ~*"]
[null,"To search for a tilde, search for ~~"]
[null,"To search for question mark, search for ~?"]
[null,"To search for ~?*, search for ~~~?~*"]
[null,"In the Find/Replace dialog, use ~~, ~*, ~? In the Find box, but not Replace"]
[null,"When using VLOOKUP or MATCH, use ~~ ~* or ~?"]