{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Dataset","Applying Go To Special","Using Find and Replace","Using Nested LOOKUP Function","Using VBA Macros","Filling Empty Value with Zero","Using IF Function"],"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":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Sample Dataset"]
[]
[null,"Product","Product ID","Date of Sales"]
[null,"Mobile",101,"2022-09-22"]
[null,"Computer",{"$f":"C5+1","v":102}]
[null,"Tablet",{"$f":"C6+1","v":103},"2022-09-23"]
[null,"Charger",104]
[null,"Cables",105,"2022-09-24"]
[null,"Monitor",106]

{"sheet":"Applying Go To Special","index":1,"n_rows":10,"n_cols":12,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,9,1,11]]}
[]
[null,"Applying Go To Special Feature",null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Product","Product ID","Date of Sales",null,null,null,null,null,"Product","Product ID","Date of Sales"]
[null,"Mobile",101,"2022-09-22",null,null,null,null,null,"Mobile",101,"2022-09-22"]
[null,"Computer",{"$f":"C5+1","v":102},{"$f":"D5","v":"2022-09-22"},null,null,null,null,null,"Computer",{"$f":"K5+1","v":102}]
[null,"Tablet",{"$f":"C6+1","v":103},"2022-09-23",null,null,null,null,null,"Tablet",{"$f":"K6+1","v":103},"2022-09-23"]
[null,"Charger",104,{"$f":"D7","v":"2022-09-23"},null,null,null,null,null,"Charger",104]
[null,"Cables",105,"2022-09-24",null,null,null,null,null,"Cables",105,"2022-09-24"]
[null,"Monitor",106,{"$f":"D9","v":"2022-09-24"},null,null,null,null,null,"Monitor",106]

{"sheet":"Using Find and Replace","index":2,"n_rows":10,"n_cols":12,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,9,1,11]]}
[]
[null,"Using Find and Replace",null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Product","Product ID","Date of Sales",null,null,null,null,null,"Product","Product ID","Date of Sales"]
[null,"Mobile",101,"2022-09-22",null,null,null,null,null,"Mobile",101,"2022-09-22"]
[null,"Computer",{"$f":"C5+1","v":102},{"$f":"D5","v":"2022-09-22"},null,null,null,null,null,"Computer",{"$f":"K5+1","v":102}]
[null,"Tablet",{"$f":"C6+1","v":103},"2022-09-23",null,null,null,null,null,"Tablet",{"$f":"K6+1","v":103},"2022-09-23"]
[null,"Charger",104,{"$f":"D7","v":"2022-09-23"},null,null,null,null,null,"Charger",104]
[null,"Cables",105,"2022-09-24",null,null,null,null,null,"Cables",105,"2022-09-24"]
[null,"Monitor",106,{"$f":"D9","v":"2022-09-24"},null,null,null,null,null,"Monitor",106]

{"sheet":"Using Nested LOOKUP Function","index":3,"n_rows":10,"n_cols":14,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,7],[1,11,1,13]]}
[]
[null,"Using Nested LOOKUP Function",null,null,null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Product","Product ID","Date of Sales",null,{"$f":"LOOKUP(ROW(B4:B10),IF(LEN(B4:B10),ROW(B4:B10)),B4:B10)","v":"Product"},{"$f":"LOOKUP(ROW(C4:C10),IF(LEN(C4:C10),ROW(C4:C10)),C4:C10)","v":"Product ID"},{"$f":"LOOKUP(ROW(D4:D10),IF(LEN(D4:D10),ROW(D4:D10)),D4:D10)","v":"Date of Sales"},null,null,null,"Product","Product ID","Date of Sales"]
[null,"Mobile",101,"2022-09-22",null,"Mobile",101,"2022-09-22",null,null,null,"Mobile",101,"2022-09-22"]
[null,"Computer",{"$f":"C5+1","v":102},null,null,"Computer",102,"2022-09-22",null,null,null,"Computer",{"$f":"M5+1","v":102}]
[null,"Tablet",{"$f":"C6+1","v":103},"2022-09-23",null,"Tablet",103,"2022-09-23",null,null,null,"Tablet",{"$f":"M6+1","v":103},"2022-09-23"]
[null,"Charger",104,null,null,"Charger",104,"2022-09-23",null,null,null,"Charger",104]
[null,"Cables",105,"2022-09-24",null,"Cables",105,"2022-09-24",null,null,null,"Cables",105,"2022-09-24"]
[null,"Monitor",106,null,null,"Monitor",106,"2022-09-24",null,null,null,"Monitor",106]

{"sheet":"Using VBA Macros","index":4,"n_rows":10,"n_cols":14,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,11,1,13]]}
[]
[null,"Using VBA Macros",null,null,null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Product","Product ID","Date of Sales",null,null,null,null,null,null,null,"Product","Product ID","Date of Sales"]
[null,"Mobile",101,"2022-09-22",null,null,null,null,null,null,null,"Mobile",101,"2022-09-22"]
[null,"Computer",{"$f":"C5+1","v":102},"2022-09-22",null,null,null,null,null,null,null,"Computer",{"$f":"M5+1","v":102}]
[null,"Tablet",{"$f":"C6+1","v":103},"2022-09-23",null,null,null,null,null,null,null,"Tablet",{"$f":"M6+1","v":103},"2022-09-23"]
[null,"Charger",104,"2022-09-23",null,null,null,null,null,null,null,"Charger",104]
[null,"Cables",105,"2022-09-24",null,null,null,null,null,null,null,"Cables",105,"2022-09-24"]
[null,"Monitor",106,"2022-09-24",null,null,null,null,null,null,null,"Monitor",106]

{"sheet":"Filling Empty Value with Zero","index":5,"n_rows":10,"n_cols":12,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,9,1,11]]}
[]
[null,"Filling Empty Value with Zero",null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Product","Product ID","Date of Sales",null,null,null,null,null,"Product","Product ID","Date of Sales"]
[null,"Mobile",101,"2022-09-22",null,null,null,null,null,"Mobile",101,"2022-09-22"]
[null,0,{"$f":"C5+1","v":102},"2022-09-23",null,null,null,null,null,null,{"$f":"K5+1","v":102},{"$f":"L5","v":"2022-09-22"}]
[null,0,{"$f":"C6+1","v":103},"2022-09-23",null,null,null,null,null,null,{"$f":"K6+1","v":103},"2022-09-23"]
[null,"Charger",104,"2022-09-24",null,null,null,null,null,"Charger",104,{"$f":"L7","v":"2022-09-23"}]
[null,0,105,"2022-09-24",null,null,null,null,null,null,105,"2022-09-24"]
[null,"Monitor",106,"2022-09-25",null,null,null,null,null,"Monitor",106,{"$f":"L9","v":"2022-09-24"}]

{"sheet":"Using IF Function","index":6,"n_rows":11,"n_cols":12,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,9,1,11]]}
[]
[null,"Using IF Function",null,null,null,null,null,null,null,"Using IF Function"]
[]
[null,"Student ID","Attendance","Remarks",null,null,null,null,null,"Student ID","Attendance","Remarks"]
[null,1010,"Present",{"$f":"IF(C5=\"\",\"Missing\",C5)","v":"Present"},null,null,null,null,null,1010,"Present"]
[null,{"$f":"B5+1","v":1011},null,{"$f":"IF(C6=\"\",\"Missing\",C6)","v":"Missing"},null,null,null,null,null,{"$f":"J5+1","v":1011}]
[null,{"$f":"B6+1","v":1012},"Absent","Absent",null,null,null,null,null,{"$f":"J6+1","v":1012},"Absent"]
[null,1013,"Present","Present",null,null,null,null,null,1013,"Present"]
[null,1014,null,"Missing",null,null,null,null,null,1014]
[null,1015,null,"Missing",null,null,null,null,null,1015]
[null,1016,"Present","Present",null,null,null,null,null,1016,"Present"]