{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Dataset","GoTo Special","Find-Replace","LOOKUP","VBA"],"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":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Sample Dataset"]
[]
[null,"Product ID","Date of Sales","Sales"]
[null,"#1101","2019-09-22",266]
[null,null,"2019-10-15"]
[null,null,"2019-11-20",209]
[null,"#1102","2019-08-15",210]
[null,null,"2019-09-11"]
[null,"#1103","2019-09-19",300]
[null,null,"2019-10-20"]
[null,null,"2019-11-20"]
[null,"#1104","2019-08-10",150]
[null,null,"2019-09-17"]

{"sheet":"GoTo Special","index":1,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using Go To Special Feature"]
[]
[null,"Product ID","Date of Sales","Sales"]
[null,"#1101","2019-09-22",266]
[null,"#1101","2019-10-15",266]
[null,"#1101","2019-11-20",209]
[null,"#1102","2019-08-15",210]
[null,"#1102","2019-09-11",210]
[null,"#1103","2019-09-19",300]
[null,"#1103","2019-10-20",300]
[null,"#1103","2019-11-20",300]
[null,"#1104","2019-08-10",150]
[null,"#1104","2019-09-17",150]

{"sheet":"Find-Replace","index":2,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Utilizing Find & Replace Command"]
[]
[null,"Product ID","Date of Sales","Sales"]
[null,"#1101","2019-09-22",266]
[null,{"$f":"B5","v":"#1101"},"2019-10-15",{"$f":"D5","v":266}]
[null,"#1101","2019-11-20",209]
[null,"#1102","2019-08-15",210]
[null,{"$f":"B8","v":"#1102"},"2019-09-11",{"$f":"D8","v":210}]
[null,"#1103","2019-09-19",300]
[null,{"$f":"B10","v":"#1103"},"2019-10-20",{"$f":"D10","v":300}]
[null,"#1103","2019-11-20",300]
[null,"#1104","2019-08-10",150]
[null,{"$f":"B13","v":"#1104"},"2019-09-17",{"$f":"D13","v":150}]

{"sheet":"LOOKUP","index":3,"n_rows":14,"n_cols":8,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Applying Nested LOOKUP Formula"]
[]
[null,"Product ID","Date of Sales","Sales",null,{"$f":"LOOKUP(ROW(B4:B14), IF(LEN(B4:B14), ROW(B4:B14)), B4:B14)","v":"Product ID"},{"$f":"LOOKUP(ROW(C4:C14), IF(LEN(C4:C14), ROW(C4:C14)), C4:C14)","v":"Date of Sales"},{"$f":"LOOKUP( ROW(D4:D14), IF(LEN(D4:D14),ROW(D4:D14)), D4:D14)","v":"Sales"}]
[null,"#1101","2019-09-22",266,null,"#1101","2019-09-22",266]
[null,null,"2019-10-15",null,null,"#1101","2019-10-15",266]
[null,null,"2019-11-20",209,null,"#1101","2019-11-20",209]
[null,"#1102","2019-08-15",210,null,"#1102","2019-08-15",210]
[null,null,"2019-09-11",null,null,"#1102","2019-09-11",210]
[null,"#1103","2019-09-19",300,null,"#1103","2019-09-19",300]
[null,null,"2019-10-20",null,null,"#1103","2019-10-20",300]
[null,null,"2019-11-20",null,null,"#1103","2019-11-20",300]
[null,"#1104","2019-08-10",150,null,"#1104","2019-08-10",150]
[null,null,"2019-09-17",null,null,"#1104","2019-09-17",150]

{"sheet":"VBA","index":4,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using VBA Code"]
[]
[null,"Product ID","Date of Sales","Sales"]
[null,"#1101","2019-09-22",266]
[null,"#1101","2019-10-15",266]
[null,"#1101","2019-11-20",209]
[null,"#1102","2019-08-15",210]
[null,"#1102","2019-09-11",210]
[null,"#1103","2019-09-19",300]
[null,"#1103","2019-10-20",300]
[null,"#1103","2019-11-20",300]
[null,"#1104","2019-08-10",150]
[null,"#1104","2019-09-17",150]