{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["1. Duplicate and SUMIF Function","SampleDataset","VBA","2.Consolidation Function","3. Pivot Table"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":1},"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":"1. Duplicate and SUMIF Function","index":0,"n_rows":17,"n_cols":8,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Using Duplicate and SUMIF Function"]
[]
[null,"Date","Customer","Due ",null,"Customer","Total Due"]
[null,"2021-12-01","Smith",250,null,"Smith",{"$f":"SUMIF(C$5:C$17,F5,D$5:D$17)","v":634}]
[null,"2021-12-02","Patrick",345,null,"Patrick",{"$f":"SUMIF(C$5:C$17,F6,D$5:D$17)","v":345}]
[null,"2021-12-03","Kader",390,null,"Kader",390]
[null,"2021-12-04","Manish",233,null,"Manish",395]
[null,"2021-12-05","Ahmed",188,null,"Ahmed",625]
[null,"2021-12-06","Smith",384,null,"Jonas",626]
[null,"2021-12-07","Jonas",363,null,"Tim",377]
[null,"2021-12-08","Tim",377,null,"Stuart",363]
[null,"2021-12-09","Ahmed",337,null,null,null," "]
[null,"2021-12-10","Stuart",363]
[null,"2021-12-11","Jonas",263]
[null,"2021-12-12","Manish",162]
[null,"2021-12-13","Ahmed",100]

{"sheet":"SampleDataset","index":1,"n_rows":17,"n_cols":4,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Consolidating Rows and Sum Data in Excel"]
[]
[null,"Date","Customer","Due "]
[null,"2021-12-01","Smith",250]
[null,"2021-12-02","Patrick",345]
[null,"2021-12-03","Kader",390]
[null,"2021-12-04","Manish",233]
[null,"2021-12-05","Ahmed",188]
[null,"2021-12-06","Smith",384]
[null,"2021-12-07","Jonas",363]
[null,"2021-12-08","Tim",377]
[null,"2021-12-09","Ahmed",337]
[null,"2021-12-10","Stuart",363]
[null,"2021-12-11","Jonas",263]
[null,"2021-12-12","Manish",162]
[null,"2021-12-13","Ahmed",100]

{"sheet":"VBA","index":2,"n_rows":17,"n_cols":6,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using VBA Code"]
[]
[null,"Date",null,null,"Customer","Due "]
[null,"2021-12-01",null,null,"Smith",634]
[null,"2021-12-02",null,null,"Patrick",345]
[null,"2021-12-03",null,null,"Kader",390]
[null,"2021-12-04",null,null,"Manish",395]
[null,"2021-12-05",null,null,"Ahmed",625]
[null,"2021-12-06",null,null,"Jonas",626]
[null,"2021-12-07",null,null,"Tim",377]
[null,"2021-12-08",null,null,"Stuart",363]
[null,"2021-12-09"]
[null,"2021-12-10"]
[null,"2021-12-11"]
[null,"2021-12-12"]
[null,"2021-12-13"]

{"sheet":"2.Consolidation Function","index":3,"n_rows":17,"n_cols":7,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Using Consolidate Function"]
[]
[null,"Date","Customer","Due ",null,"Customer","Due "]
[null,"2021-12-01","Smith",250,null,"Smith",634]
[null,"2021-12-02","Patrick",345,null,"Patrick",345]
[null,"2021-12-03","Kader",390,null,"Kader",390]
[null,"2021-12-04","Manish",233,null,"Manish",395]
[null,"2021-12-05","Ahmed",188,null,"Ahmed",625]
[null,"2021-12-06","Smith",384,null,"Jonas",626]
[null,"2021-12-07","Jonas",363,null,"Tim",377]
[null,"2021-12-08","Tim",377,null,"Stuart",363]
[null,"2021-12-09","Ahmed",337]
[null,"2021-12-10","Stuart",363]
[null,"2021-12-11","Jonas",263]
[null,"2021-12-12","Manish",162]
[null,"2021-12-13","Ahmed",100]

{"sheet":"3. Pivot Table","index":4,"n_rows":17,"n_cols":7,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Using Pivot Table"]
[]
[null,"Date","Customer","Due ",null,"Row Labels","Sum of Due "]
[null,"2021-12-01","Smith",250,null,"Ahmed",625]
[null,"2021-12-02","Patrick",345,null,"Jonas",626]
[null,"2021-12-03","Kader",390,null,"Kader",390]
[null,"2021-12-04","Manish",233,null,"Manish",395]
[null,"2021-12-05","Ahmed",188,null,"Patrick",345]
[null,"2021-12-06","Smith",384,null,"Smith",634]
[null,"2021-12-07","Jonas",363,null,"Stuart",363]
[null,"2021-12-08","Tim",377,null,"Tim",377]
[null,"2021-12-09","Ahmed",337,null,"Grand Total",3755]
[null,"2021-12-10","Stuart",363]
[null,"2021-12-11","Jonas",263]
[null,"2021-12-12","Manish",162]
[null,"2021-12-13","Ahmed",100]