{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Data Intro","Subtotal","If and Subtotal","Aggregate","Row","CountA","Fill Series","VBA","Practice"],"not_rendered":{"charts":0,"images":0,"macros":1,"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":"Data Intro","index":0,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Auto Number or Renumber after Filter"]
[]
[null,"Serial","Name","Department","Joining Date"]
[null,5,"Malan","Operations","2021-10-07"]
[null,4,"Dan","HR","2021-08-03"]
[null,10,"Robin","Finance","2021-07-21"]
[null,8,"John","Marketing","2021-06-17"]
[null,7,"Cameroon","HR","2021-04-25"]
[null,1,"Alice","Marketing","2021-03-25"]
[null,3,"David","Operations","2021-03-01"]
[null,2,"Bob","Finance","2021-01-17"]
[null,9,"Emanuel","Finance","2020-08-25"]
[null,6,"James","Finance","2020-08-24"]

{"sheet":"Subtotal","index":1,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Auto Number or Renumber after Filter"]
[]
[null,"Serial","Name","Department","Joining Date"]
[null,{"$f":"SUBTOTAL(3,$C$5:C5)","v":0},"Malan","Operations","2021-10-07"]
[null,{"$f":"SUBTOTAL(3,$C$5:C6)","v":0},"Dan","HR","2021-08-03"]
[null,{"$f":"SUBTOTAL(3,$C$5:C7)","v":1},"Robin","Finance","2021-07-21"]
[null,{"$f":"SUBTOTAL(3,$C$5:C8)","v":1},"John","Marketing","2021-06-17"]
[null,{"$f":"SUBTOTAL(3,$C$5:C9)","v":1},"Cameroon","HR","2021-04-25"]
[null,{"$f":"SUBTOTAL(3,$C$5:C10)","v":1},"Alice","Marketing","2021-03-25"]
[null,{"$f":"SUBTOTAL(3,$C$5:C11)","v":1},"David","Operations","2021-03-01"]
[null,{"$f":"SUBTOTAL(3,$C$5:C12)","v":2},"Bob","Finance","2021-01-17"]
[null,{"$f":"SUBTOTAL(3,$C$5:C13)","v":3},"Emanuel","Finance","2020-08-25"]
[null,{"$f":"SUBTOTAL(3,$C$5:C14)","v":4},"James","Finance","2020-08-24"]

{"sheet":"If and Subtotal","index":2,"n_rows":18,"n_cols":6,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Auto Number or Renumber after Filter"]
[]
[null,"Serial","Name","Joining Date",null,"Person?"]
[null,{"$f":"IF(F5=\"\",\"\",SUBTOTAL(3,$F$5:F5)-1)","v":""},"  Marketing",null,null,{"$f":"IF(LEFT(C5,2)=\"  \",\"\",1)","v":""}]
[null,{"$f":"IF(F6=\"\",\"\",SUBTOTAL(3,$F$5:F6)-1)","v":1},"Alice","2021-03-25",null,{"$f":"IF(LEFT(C6,2)=\"  \",\"\",1)","v":1}]
[null,{"$f":"IF(F7=\"\",\"\",SUBTOTAL(3,$F$5:F7)-1)","v":2},"John","2021-06-17",null,1]
[null,{"$f":"IF(F8=\"\",\"\",SUBTOTAL(3,$F$8:F8)-1)","v":""},"  Finance",null,null,""]
[null,{"$f":"IF(F9=\"\",\"\",SUBTOTAL(3,$F$8:F9)-1)","v":1},"Bob","2021-01-17",null,1]
[null,{"$f":"IF(F10=\"\",\"\",SUBTOTAL(3,$F$8:F10)-1)","v":2},"James","2020-08-24",null,1]
[null,{"$f":"IF(F11=\"\",\"\",SUBTOTAL(3,$F$8:F11)-1)","v":3},"Emanuel","2020-08-25",null,1]
[null,{"$f":"IF(F12=\"\",\"\",SUBTOTAL(3,$F$8:F12)-1)","v":4},"Robin","2021-07-21",null,1]
[null,{"$f":"IF(F13=\"\",\"\",SUBTOTAL(3,$F$13:F13)-1)","v":""},"  HR",null,null,""]
[null,{"$f":"IF(F14=\"\",\"\",SUBTOTAL(3,$F$13:F14)-1)","v":1},"Cameroon","2021-04-25",null,1]
[null,{"$f":"IF(F15=\"\",\"\",SUBTOTAL(3,$F$13:F15)-1)","v":2},"Dan","2021-08-03",null,1]
[null,{"$f":"IF(F16=\"\",\"\",SUBTOTAL(3,$F$16:F16)-1)","v":""},"  Operations",null,null,""]
[null,{"$f":"IF(F17=\"\",\"\",SUBTOTAL(3,$F$16:F17)-1)","v":1},"David","2021-03-01",null,1]
[null,{"$f":"IF(F18=\"\",\"\",SUBTOTAL(3,$F$16:F18)-1)","v":2},"Malan","2021-10-07",null,1]

{"sheet":"Aggregate","index":3,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Auto Number or Renumber after Filter"]
[]
[null,"Serial","Name","Department","Joining Date"]
[null,{"$f":"_xlfn.AGGREGATE(3,7,$D$5:D5)","v":1},"David","Operations","2021-03-01"]
[null,{"$f":"_xlfn.AGGREGATE(3,7,$D$5:D6)","v":2},"Malan","Operations","2021-10-07"]
[null,{"$f":"_xlfn.AGGREGATE(3,7,$D$5:D7)","v":3},"Alice","Marketing","2021-03-25"]
[null,{"$f":"_xlfn.AGGREGATE(3,7,$D$5:D8)","v":4},"John","Marketing","2021-06-17"]
[null,{"$f":"_xlfn.AGGREGATE(3,7,$D$5:D9)","v":5},"Dan","HR","2021-08-03"]
[null,{"$f":"_xlfn.AGGREGATE(3,7,$D$5:D10)","v":6},"Cameroon","HR","2021-04-25"]
[null,{"$f":"_xlfn.AGGREGATE(3,7,$D$5:D11)","v":7},"Bob","Finance","2021-01-17"]
[null,{"$f":"_xlfn.AGGREGATE(3,7,$D$5:D12)","v":8},"James","Finance","2020-08-24"]
[null,{"$f":"_xlfn.AGGREGATE(3,7,$D$5:D13)","v":9},"Emanuel","Finance","2020-08-25"]
[null,{"$f":"_xlfn.AGGREGATE(3,7,$D$5:D14)","v":10},"Robin","Finance","2021-07-21"]

{"sheet":"Row","index":4,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Auto Number or Renumber after Filter"]
[]
[null,"Serial","Name","Department","Joining Date"]
[null,{"$f":"ROW()-4","v":1},"Alice","Marketing","2021-03-25"]
[null,2,"Bob","Finance","2021-01-17"]
[null,3,"David","Operations","2021-03-01"]
[null,4,"Dan","HR","2021-08-03"]
[null,5,"Malan","Operations","2021-10-07"]
[null,6,"James","Finance","2020-08-24"]
[null,7,"Cameroon","HR","2021-04-25"]
[null,8,"John","Marketing","2021-06-17"]
[null,9,"Emanuel","Finance","2020-08-25"]
[null,10,"Robin","Finance","2021-07-21"]

{"sheet":"CountA","index":5,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Auto Number or Renumber after Filter"]
[]
[null,"Serial","Name","Department","Joining Date"]
[null,{"$f":"COUNTIF($D$5:D5,D5)","v":1},"James","Finance","2020-08-24"]
[null,{"$f":"COUNTIF($D$5:D6,D6)","v":2},"Emanuel","Finance","2020-08-25"]
[null,{"$f":"COUNTIF($D$5:D7,D7)","v":3},"Bob","Finance","2021-01-17"]
[null,{"$f":"COUNTIF($D$5:D8,D8)","v":1},"David","Operations","2021-03-01"]
[null,{"$f":"COUNTIF($D$5:D9,D9)","v":1},"Alice","Marketing","2021-03-25"]
[null,{"$f":"COUNTIF($D$5:D10,D10)","v":1},"Cameroon","HR","2021-04-25"]
[null,{"$f":"COUNTIF($D$5:D11,D11)","v":2},"John","Marketing","2021-06-17"]
[null,{"$f":"COUNTIF($D$5:D12,D12)","v":4},"Robin","Finance","2021-07-21"]
[null,{"$f":"COUNTIF($D$5:D13,D13)","v":2},"Dan","HR","2021-08-03"]
[null,{"$f":"COUNTIF($D$5:D14,D14)","v":2},"Malan","Operations","2021-10-07"]

{"sheet":"Fill Series","index":6,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Auto Number or Renumber after Filter"]
[]
[null,"Serial","Name","Department","Joining Date"]
[null,1,"Alice","Marketing","2021-03-25"]
[null,2,"Bob","Finance","2021-01-17"]
[null,3,"David","Operations","2021-03-01"]
[null,4,"Dan","HR","2021-08-03"]
[null,5,"Malan","Operations","2021-10-07"]
[null,6,"James","Finance","2020-08-24"]
[null,7,"Cameroon","HR","2021-04-25"]
[null,8,"John","Marketing","2021-06-17"]
[null,9,"Emanuel","Finance","2020-08-25"]
[null,10,"Robin","Finance","2021-07-21"]

{"sheet":"VBA","index":7,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Auto Number or Renumber after Filter"]
[]
[null,"Serial","Name","Department","Joining Date"]
[null,1,"James","Finance","2020-08-24"]
[null,2,"Emanuel","Finance","2020-08-25"]
[null,3,"Bob","Finance","2021-01-17"]
[null,4,"David","Operations","2021-03-01"]
[null,5,"Alice","Marketing","2021-03-25"]
[null,6,"Cameroon","HR","2021-04-25"]
[null,7,"John","Marketing","2021-06-17"]
[null,8,"Robin","Finance","2021-07-21"]
[null,9,"Dan","HR","2021-08-03"]
[null,10,"Malan","Operations","2021-10-07"]

{"sheet":"Practice","index":8,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Do It Yourself!"]
[]
[null,"Serial","Name","Department","Joining Date"]
[null,1,"Alice","Marketing","2021-03-25"]
[null,2,"Bob","Finance","2021-01-17"]
[null,3,"David","Operations","2021-03-01"]
[null,4,"Dan","HR","2021-08-03"]
[null,5,"Malan","Operations","2021-10-07"]
[null,6,"James","Finance","2020-08-24"]
[null,7,"Cameroon","HR","2021-04-25"]
[null,8,"John","Marketing","2021-06-17"]
[null,9,"Emanuel","Finance","2020-08-25"]
[null,10,"Robin","Finance","2021-07-21"]