{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Dataset","FIND Function","Sheet2","Sheet3","Finding and Marking Value","Wildcards in Excel VBA","Maximum Value of Column","Last Value of Column"],"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":"Dataset","index":0,"n_rows":19,"n_cols":6,"rows_kept":19,"cut":false,"hidden":false,"merged":[[3,1,4,1],[3,2,4,2],[1,1,1,5]]}
[]
[null,"Sample Dataset"]
[]
[null,"Find Order ID of this Product ID",null,null,"Match Order ID"]
[]
[]
[null,"Product ID","Brand","Model","Unit Price","Order ID"]
[null,"AP-1122","APPLE","IPHONE 11 PRO",1200,"A-551"]
[null,"SM-1133","SAMSUNG","GALAXY NOTE 10",1100,"A-651"]
[null,"SG-1133","SAMSUNG","GALAXY NOTE 10 LITE",1000,"D-554"]
[null,"SM-1144","SAMSUNG","GALAXY NOTE 9 ",900,"C-555"]
[null,"AP-1155","APPLE ","IPHONE X",1150,"A-657"]
[null,"AP-1166","APPLE","IPHONE XR",850,"G-454"]
[null,"AP-1177","SONY","XPERIA XZ3 ",650,"F-420"]
[null,"OP-1188","ONEPLUS",8,450,"A-588"]
[null,"OP-1199","ONEPLUS","8T",550,"B-599"]
[null,"SM-2200","SAMSUNG","GALAXY NOTE 8",850,"B-330"]
[null,"AP-2211","APPLE","IPHONE 7 Plus",750,"C-890"]
[null,"AP-2222","APPLE","IPHONE 8",890,"B-120"]

{"sheet":"FIND Function","index":1,"n_rows":19,"n_cols":6,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,1,1,5],[3,1,4,1],[3,2,4,2]]}
[]
[null,"Using Find Function in VBA"]
[]
[null,"Find Order ID of this Product ID","AP-1122",null,"Match Order ID"]
[null,null,null,null,"A-551"]
[]
[null,"Product ID","Brand","Model","Unit Price","Order ID"]
[null,"AP-1122","APPLE","IPHONE 11 PRO",1200,"A-551"]
[null,"SM-1133","SAMSUNG","GALAXY NOTE 10",1100,"A-651"]
[null,"SG-1133","SAMSUNG","GALAXY NOTE 10 LITE",1000,"D-554"]
[null,"SM-1144","SAMSUNG","GALAXY NOTE 9 ",900,"C-555"]
[null,"AP-1155","APPLE ","IPHONE X",1150,"A-657"]
[null,"AP-1166","APPLE","IPHONE XR",850,"G-454"]
[null,"AP-1177","SONY","XPERIA XZ3 ",650,"F-420"]
[null,"OP-1188","ONEPLUS",8,450,"A-588"]
[null,"OP-1199","ONEPLUS","8T",550,"B-599"]
[null,"SM-2200","SAMSUNG","GALAXY NOTE 8",850,"B-330"]
[null,"AP-2211","APPLE","IPHONE 7 Plus",750,"C-890"]
[null,"AP-2222","APPLE","IPHONE 8",890,"B-120"]

{"sheet":"Sheet2","index":2,"n_rows":16,"n_cols":6,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Finding Value From Different Worksheets"]
[]
[null,"Product ID","Brand","Model","Unit Price","Order ID"]
[null,"AP-1122","APPLE","IPHONE 11 PRO",1200,"A-551"]
[null,"SM-1133","SAMSUNG","GALAXY NOTE 10",1100,"A-651"]
[null,"SG-1133","SAMSUNG","GALAXY NOTE 10 LITE",1000,"D-554"]
[null,"SM-1144","SAMSUNG","GALAXY NOTE 9 ",900,"C-555"]
[null,"AP-1155","APPLE ","IPHONE X",1150,"A-657"]
[null,"AP-1166","APPLE","IPHONE XR",850,"G-454"]
[null,"AP-1177","SONY","XPERIA XZ3 ",650,"F-420"]
[null,"OP-1188","ONEPLUS",8,450,"A-588"]
[null,"OP-1199","ONEPLUS","8T",550,"B-599"]
[null,"SM-2200","SAMSUNG","GALAXY NOTE 8",850,"B-330"]
[null,"AP-2211","APPLE","IPHONE 7 Plus",750,"C-890"]
[null,"AP-2222","APPLE","IPHONE 8",890,"B-120"]

{"sheet":"Sheet3","index":3,"n_rows":5,"n_cols":5,"rows_kept":5,"cut":false,"hidden":false,"merged":[[3,1,4,1],[3,2,4,2],[1,1,1,4]]}
[]
[null,"Finding Value From Different Worksheets (2)"]
[]
[null,"Find Order ID of this Product ID","OP-1188",null,"Match Order ID"]
[null,null,null,null,"A-588"]

{"sheet":"Finding and Marking Value","index":4,"n_rows":16,"n_cols":7,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Finding and Marking Value"]
[]
[null,"Product ID","Brand","Model","Unit Price","Order ID","Delivery Status"]
[null,"AP-1122","APPLE","IPHONE 11 PRO",1200,"A-551","Delivered"]
[null,"SM-1133","SAMSUNG","GALAXY NOTE 10",1100,"A-651","Delivered"]
[null,"SG-1133","SAMSUNG","GALAXY NOTE 10 LITE",1000,"D-554","Delivered"]
[null,"SM-1144","SAMSUNG","GALAXY NOTE 9 ",900,"C-555","Processing"]
[null,"AP-1155","APPLE ","IPHONE X",1150,"A-657","Pending"]
[null,"AP-1166","APPLE","IPHONE XR",850,"G-454","Processing"]
[null,"AP-1177","SONY","XPERIA XZ3 ",650,"F-420","Processing"]
[null,"OP-1188","ONEPLUS",8,450,"A-588","Pending"]
[null,"OP-1199","ONEPLUS","8T",550,"B-599","Delivered"]
[null,"SM-2200","SAMSUNG","GALAXY NOTE 8",850,"B-330","Delivered"]
[null,"AP-2211","APPLE","IPHONE 7 Plus",750,"C-890","Pending"]
[null,"AP-2222","APPLE","IPHONE 8",890,"B-120","Processing"]

{"sheet":"Wildcards in Excel VBA","index":5,"n_rows":20,"n_cols":7,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,1,1,6],[18,2,19,2],[18,3,19,3]]}
[]
[null,"Finding Values Using Wildcards"]
[]
[null,"Product ID","Brand","Model","Unit Price","Order ID","Delivery Status"]
[null,"AP-1122","APPLE","IPHONE 11 PRO",1200,"A-551","Delivered"]
[null,"SM-1133","SAMSUNG","GALAXY NOTE 10",1100,"A-651","Delivered"]
[null,"SG-1133","SAMSUNG","GALAXY NOTE 10 LITE",1000,"D-554","Delivered"]
[null,"SM-1144","SAMSUNG","GALAXY NOTE 9 ",900,"C-555","Processing"]
[null,"AP-1155","APPLE ","IPHONE X",1150,"A-657","Pending"]
[null,"AP-1166","APPLE","IPHONE XR",850,"G-454","Processing"]
[null,"AP-1177","SONY","XPERIA XZ3 ",650,"F-420","Processing"]
[null,"OP-1188","ONEPLUS",8,450,"A-588","Pending"]
[null,"OP-1199","ONEPLUS","8T",550,"B-599","Delivered"]
[null,"SM-2200","SAMSUNG","GALAXY NOTE 8",850,"B-330","Delivered"]
[null,"AP-2211","APPLE","IPHONE 7 Plus",750,"C-890","Pending"]
[null,"AP-2222","APPLE","IPHONE 8",890,"B-120","Processing"]
[]
[]
[null,null,"Find Order ID of this Product ID",1133,null,"Match Order ID"]
[null,null,null,null,null,1100]

{"sheet":"Maximum Value of Column","index":6,"n_rows":16,"n_cols":6,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Finding Maximum Value"]
[]
[null,"Product ID","Brand","Model","Unit Price","Order ID"]
[null,"AP-1122","APPLE","IPHONE 11 PRO",1200,"A-551"]
[null,"SM-1133","SAMSUNG","GALAXY NOTE 10",1100,"A-651"]
[null,"SG-1133","SAMSUNG","GALAXY NOTE 10 LITE",1000,"D-554"]
[null,"SM-1144","SAMSUNG","GALAXY NOTE 9 ",900,"C-555"]
[null,"AP-1155","APPLE ","IPHONE X",1150,"A-657"]
[null,"AP-1166","APPLE","IPHONE XR",850,"G-454"]
[null,"AP-1177","SONY","XPERIA XZ3 ",650,"F-420"]
[null,"OP-1188","ONEPLUS",8,450,"A-588"]
[null,"OP-1199","ONEPLUS","8T",550,"B-599"]
[null,"SM-2200","SAMSUNG","GALAXY NOTE 8",850,"B-330"]
[null,"AP-2211","APPLE","IPHONE 7 Plus",750,"C-890"]
[null,"AP-2222","APPLE","IPHONE 8",890,"B-120"]

{"sheet":"Last Value of Column","index":7,"n_rows":16,"n_cols":6,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[null,0]
[null,"Finding Last Value"]
[]
[null,"Product ID","Brand","Model","Unit Price","Order ID"]
[null,"AP-1122","APPLE","IPHONE 11 PRO",1200,"A-551"]
[null,"SM-1133","SAMSUNG","GALAXY NOTE 10",1100,"A-651"]
[null,"SG-1133","SAMSUNG","GALAXY NOTE 10 LITE",1000,"D-554"]
[null,"SM-1144","SAMSUNG","GALAXY NOTE 9 ",900,"C-555"]
[null,"AP-1155","APPLE ","IPHONE X",1150,"A-657"]
[null,"AP-1166","APPLE","IPHONE XR",850,"G-454"]
[null,"AP-1177","SONY","XPERIA XZ3 ",650,"F-420"]
[null,"OP-1188","ONEPLUS",8,450,"A-588"]
[null,"OP-1199","ONEPLUS","8T",550,"B-599"]
[null,"SM-2200","SAMSUNG","GALAXY NOTE 8",850,"B-330"]
[null,"AP-2211","APPLE","IPHONE 7 Plus",750,"C-890"]
[null,"AP-2222","APPLE","IPHONE 8",890,"B-120"]