{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["C(1653)","1653","1653 (an)","Customer"],"not_rendered":{"charts":0,"images":14,"macros":0,"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":"C(1653)","index":0,"n_rows":143,"n_cols":29,"rows_kept":143,"cut":false,"hidden":false,"merged":[[5,4,28,18],[35,4,58,18],[142,4,165,18]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Change First Column in Lookup Table? 4 Examples: INDEX, XLOOKUP, LOOKUP or CHOOSE. EMT 1648"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LEN(AA36)","v":91}]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EMT 1653"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Excel"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Power Query"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Worksheet Formula"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"FILTER Function\nPartial Text Criteria (Contains Criteria)"]

{"sheet":"1653","index":1,"n_rows":29,"n_cols":16,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,null,null,"SEARCH",null,null,null,null,null,"FIND"]
[]
[null,null,null,null,null,null,null,"Filtered Records Based on Partial Text Criteria"]
[]
[null,"Date","Product","Sales",null,"PartialTextCriteria",null,"Date","Product","Sales",null,null,null,"Date","Product","Sales"]
[null,"2021-01-11","Quad",2765.12,null,"Carlota"]
[null,"2021-01-02","Carlota",206.83]
[null,"2021-01-07","Carlota Doublers",641.51]
[null,"2021-01-11","Carlota Trick Catch",2650.23]
[null,"2021-01-14","Quad Doublers",1794.64]
[null,"2021-01-03","Quad Wind MTA",1006.97]
[null,"2021-01-12","Quad Wind MTA",1240.23]
[null,"2021-01-12","Quad Doublers",1486.62]
[null,"2021-01-16","Sunshine",2092.42]
[null,"2021-01-08","Sunspot",621.4]
[null,"2021-01-06","Sunbell",1759.23]
[null,"2021-01-20","Quad Doublers",1216.8399999999999]
[null,"2021-01-23","Carlota",2328.92]
[null,"2021-01-22","Carlota Doublers",1234.81]
[null,"2021-01-12","Quad Trick Catch",834.21]
[null,"2021-01-08","Quad",2661.54]
[null,"2021-01-15","Quad Doublers",628.72]
[null,"2021-01-13","Quad Wind MTA",2771.62]
[null,"2021-01-22","Carlota Trick Catch",1581.06]
[null,"2021-01-20","Sunshine",2864.78]
[null,"2021-01-02","Carlota Doublers",341.46]
[null,"2021-01-27","Sunspot",1024.53]
[null,"2021-01-10","Sunbell",426.58]

{"sheet":"1653 (an)","index":2,"n_rows":29,"n_cols":21,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sumit Bansal, Excel MVP,  YouTube Channel"]
[null,null,null,null,null,null,null,"SEARCH",null,null,null,null,null,"FIND",null,null,null,"Dynamic Filter in Excel - Filter As You Type (with & without VBA)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"https://www.youtube.com/watch?v=xBRkCv6RWcE"]
[null,null,null,null,null,null,null,"Filtered Records Based on Partial Text Criteria"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"sun",null,null,"<<= Type in Box To Filter Based on Text Column"]
[null,"Date","Product","Sales",null,"PartialTextCriteria",null,"Date","Product","Sales",null,null,null,"Date","Product","Sales"]
[null,"2021-01-11","Quad",2765.12,null,"c",null,{"$f":"_xlfn._xlws.FILTER(fSalesAnswer[],ISNUMBER(SEARCH(PartialTextCriteria,fSalesAnswer[Product])))","v":"2021-01-02"},"Carlota",206.83,null,null,null,{"$f":"_xlfn._xlws.FILTER(fSalesAnswer[],ISNUMBER(FIND(PartialTextCriteria,fSalesAnswer[Product])))","v":"2021-01-11"},"Carlota Trick Catch",2650.23,null,{"$f":"fSalesAnswer[#Headers]","v":"Date"},"Product","Sales"]
[null,"2021-01-02","Carlota",206.83,null,null,null,"2021-01-07","Carlota Doublers",641.51,null,null,null,"2021-01-12","Quad Trick Catch",834.21,null,{"$f":"_xlfn._xlws.FILTER(fSalesAnswer[],ISNUMBER(SEARCH(R5,fSalesAnswer[Product])),\"Not Found\")","v":"2021-01-16"},"Sunshine",2092.42]
[null,"2021-01-07","Carlota Doublers",641.51,null,null,null,"2021-01-11","Carlota Trick Catch",2650.23,null,null,null,"2021-01-22","Carlota Trick Catch",1581.06,null,"2021-01-08","Sunspot",621.4]
[null,"2021-01-11","Carlota Trick Catch",2650.23,null,null,null,"2021-01-23","Carlota",2328.92,null,null,null,null,null,null,null,"2021-01-06","Sunbell",1759.23]
[null,"2021-01-14","Quad Doublers",1794.64,null,null,null,"2021-01-22","Carlota Doublers",1234.81,null,null,null,null,null,null,null,"2021-01-20","Sunshine",2864.78]
[null,"2021-01-03","Quad Wind MTA",1006.97,null,null,null,"2021-01-12","Quad Trick Catch",834.21,null,null,null,null,null,null,null,"2021-01-27","Sunspot",1024.53]
[null,"2021-01-12","Quad Wind MTA",1240.23,null,null,null,"2021-01-22","Carlota Trick Catch",1581.06,null,null,null,null,null,null,null,"2021-01-10","Sunbell",426.58]
[null,"2021-01-12","Quad Doublers",1486.62,null,null,null,"2021-01-02","Carlota Doublers",341.46]
[null,"2021-01-16","Sunshine",2092.42]
[null,"2021-01-08","Sunspot",621.4]
[null,"2021-01-06","Sunbell",1759.23]
[null,"2021-01-20","Quad Doublers",1216.8399999999999]
[null,"2021-01-23","Carlota",2328.92]
[null,"2021-01-22","Carlota Doublers",1234.81]
[null,"2021-01-12","Quad Trick Catch",834.21]
[null,"2021-01-08","Quad",2661.54]
[null,"2021-01-15","Quad Doublers",628.72]
[null,"2021-01-13","Quad Wind MTA",2771.62]
[null,"2021-01-22","Carlota Trick Catch",1581.06]
[null,"2021-01-20","Sunshine",2864.78]
[null,"2021-01-02","Carlota Doublers",341.46]
[null,"2021-01-27","Sunspot",1024.53]
[null,"2021-01-10","Sunbell",426.58]

{"sheet":"Customer","index":3,"n_rows":18,"n_cols":18,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[]
[null,"ID","Name","Address",null,"Street",null,"ID","Name","Address",null,null,null,null,null,null,null,"Street"]
[null,1,"Sioux","32 San Pablo Ave.",null,"College Ave.",null,{"$f":"_xlfn._xlws.FILTER(dCustomer[],ISNUMBER(SEARCH(F3,dCustomer[Address])))","v":4},"Chantel","7836 College Ave.",null,null,null,null,null,null,null,"San Pablo Ave."]
[null,2,"Chin","43 Birch St.",null,null,null,5,"Shaneka","43 College Ave.",null,null,null,null,null,null,null,"Birch St."]
[null,3,"Ty","4534 San Pablo",null,null,null,9,"Pops","2231College Ave.",null,null,null,null,null,null,null,"San Pablo"]
[null,4,"Chantel","7836 College Ave.",null,null,null,12,"Mops","3459 College Ave.",null,null,null,null,null,null,null,"College Ave."]
[null,5,"Shaneka","43 College Ave.",null,null,null,15,"Mo"," 88 College Ave.",null,null,null,null,null,null,null,"Telegraph Ave."]
[null,6,"Pham","11895 Telegraph Ave.",null,null,null,null,null,null,null,null,null,null,null,null,null,"Birch Ct."]
[null,7,"Gigi","9965 San Pablo Ave."]
[null,8,"Timmy","15 San Pablo Ave."]
[null,9,"Pops","2231College Ave."]
[null,10,"Tyrone","5834 Birch St."]
[null,11,"Miki","1171 San Pablo Ave."]
[null,12,"Mops","3459 College Ave."]
[null,13,"Fran","5822 Birch St."]
[null,14,"Abdi","6943 San Pablo Ave."]
[null,15,"Mo"," 88 College Ave."]
[null,16,"Fender","5834 Birch Ct."]