{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["DataSet","MONTH","MONTH & DATEVALUE","MONTH & LEFT","MONTH & --","MATCH","TEXT ","VBA","VLOOKUP"],"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":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Convert 3 Letter Month to Number"]
[]
[null,"Income","Month"]
[null,80000,"Feb"]
[null,75000,"Apr"]
[null,65000,"Dec"]
[null,85000,"Jan"]
[null,76000,"Oct"]
[null,78000,"Jul"]

{"sheet":"MONTH","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,"Using MONTH Function",null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Income","Month","Number",null,null,null,null,null,"Income","Month","Number"]
[null,80000,"Feb",{"$f":"MONTH(C5&1)","v":2},null,null,null,null,null,80000,"Feb"]
[null,75000,"Apr",{"$f":"MONTH(C6&1)","v":4},null,null,null,null,null,75000,"Apr"]
[null,65000,"Dec",12,null,null,null,null,null,65000,"Dec"]
[null,85000,"Jan",1,null,null,null,null,null,85000,"Jan"]
[null,76000,"Oct",10,null,null,null,null,null,76000,"Oct"]
[null,78000,"Jul",7,null,null,null,null,null,78000,"Jul"]

{"sheet":"MONTH & DATEVALUE","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 MONTH & DATEVALUE Functions",null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Income","Month","Number",null,null,null,null,null,"Income","Month","Number"]
[null,80000,"Feb",{"$f":"MONTH(DATEVALUE(C5&1))","v":2},null,null,null,null,null,80000,"Feb"]
[null,75000,"Apr",{"$f":"MONTH(DATEVALUE(C6&1))","v":4},null,null,null,null,null,75000,"Apr"]
[null,65000,"Dec",12,null,null,null,null,null,65000,"Dec"]
[null,85000,"Jan",1,null,null,null,null,null,85000,"Jan"]
[null,76000,"Oct",10,null,null,null,null,null,76000,"Oct"]
[null,78000,"Jul",7,null,null,null,null,null,78000,"Jul"]

{"sheet":"MONTH & LEFT","index":3,"n_rows":10,"n_cols":12,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,9,1,11]]}
[]
[null,"Using MONTH & LEFT Functions",null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Income","Month","Number",null,null,null,null,null,"Income","Month","Number"]
[null,80000,"Feb",{"$f":"MONTH(1&LEFT(C5,3))","v":2},null,null,null,null,null,80000,"Feb"]
[null,75000,"Apr",{"$f":"MONTH(1&LEFT(C6,3))","v":4},null,null,null,null,null,75000,"Apr"]
[null,65000,"Dec",12,null,null,null,null,null,65000,"Dec"]
[null,85000,"Jan",1,null,null,null,null,null,85000,"Jan"]
[null,76000,"Oct",10,null,null,null,null,null,76000,"Oct"]
[null,78000,"Jul",7,null,null,null,null,null,78000,"Jul"]

{"sheet":"MONTH & --","index":4,"n_rows":10,"n_cols":12,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,9,1,11]]}
[]
[null,"Using MONTH Function & -- Symbol ",null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Income","Month","Number",null,null,null,null,null,"Income","Month","Number"]
[null,80000,"Feb",{"$f":"MONTH(--(C5&1))","v":2},null,null,null,null,null,80000,"Feb"]
[null,75000,"Apr",{"$f":"MONTH(--(C6&1))","v":4},null,null,null,null,null,75000,"Apr"]
[null,65000,"Dec",12,null,null,null,null,null,65000,"Dec"]
[null,85000,"Jan",1,null,null,null,null,null,85000,"Jan"]
[null,76000,"Oct",10,null,null,null,null,null,76000,"Oct"]
[null,78000,"Jul",7,null,null,null,null,null,78000,"Jul"]

{"sheet":"MATCH","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,"Employing MATCH Function",null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Income","Month","Number",null,null,null,null,null,"Income","Month","Number"]
[null,80000,"Feb",{"$f":"MATCH(C5,{\"jan\",\"feb\",\"mar\",\"apr\",\"may\",\"jun\",\"jul\",\"aug\",\"sep\",\"oct\",\"nov\",\"dec\"},0)","v":2},null,null,null,null,null,80000,"Feb"]
[null,75000,"Apr",{"$f":"MATCH(C6,{\"jan\",\"feb\",\"mar\",\"apr\",\"may\",\"jun\",\"jul\",\"aug\",\"sep\",\"oct\",\"nov\",\"dec\"},0)","v":4},null,null,null,null,null,75000,"Apr"]
[null,65000,"Dec",{"$f":"MATCH(C7,{\"jan\",\"feb\",\"mar\",\"apr\",\"may\",\"jun\",\"jul\",\"aug\",\"sep\",\"oct\",\"nov\",\"dec\"},0)","v":12},null,null,null,null,null,65000,"Dec"]
[null,85000,"Jan",{"$f":"MATCH(C8,{\"jan\",\"feb\",\"mar\",\"apr\",\"may\",\"jun\",\"jul\",\"aug\",\"sep\",\"oct\",\"nov\",\"dec\"},0)","v":1},null,null,null,null,null,85000,"Jan"]
[null,76000,"Oct",{"$f":"MATCH(C9,{\"jan\",\"feb\",\"mar\",\"apr\",\"may\",\"jun\",\"jul\",\"aug\",\"sep\",\"oct\",\"nov\",\"dec\"},0)","v":10},null,null,null,null,null,76000,"Oct"]
[null,78000,"Jul",{"$f":"MATCH(C10,{\"jan\",\"feb\",\"mar\",\"apr\",\"may\",\"jun\",\"jul\",\"aug\",\"sep\",\"oct\",\"nov\",\"dec\"},0)","v":7},null,null,null,null,null,78000,"Jul"]

{"sheet":"TEXT ","index":6,"n_rows":10,"n_cols":12,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,9,1,11]]}
[]
[null,"Applying TEXT Function",null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Income","Month","Number",null,null,null,null,null,"Income","Month","Number"]
[null,80000,"Feb",{"$f":"TEXT((C5&1),\"m\")","v":"2"},null,null,null,null,null,80000,"Feb"]
[null,75000,"Apr",{"$f":"TEXT((C6&1),\"m\")","v":"4"},null,null,null,null,null,75000,"Apr"]
[null,65000,"Dec","12",null,null,null,null,null,65000,"Dec"]
[null,85000,"Jan","1",null,null,null,null,null,85000,"Jan"]
[null,76000,"Oct","10",null,null,null,null,null,76000,"Oct"]
[null,78000,"Jul","7",null,null,null,null,null,78000,"Jul"]

{"sheet":"VBA","index":7,"n_rows":10,"n_cols":12,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,9,1,11]]}
[]
[null,"Use of Defined Function",null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Income","Month","Number",null,null,null,null,null,"Income","Month","Number"]
[null,80000,"Feb",{"$f":"ConvertMonth(C5)","v":"2"},null,null,null,null,null,80000,"Feb"]
[null,75000,"Apr",{"$f":"ConvertMonth(C6)","v":"4"},null,null,null,null,null,75000,"Apr"]
[null,65000,"Dec","12",null,null,null,null,null,65000,"Dec"]
[null,85000,"Jan","1",null,null,null,null,null,85000,"Jan"]
[null,76000,"Oct","10",null,null,null,null,null,76000,"Oct"]
[null,78000,"Jul","7",null,null,null,null,null,78000,"Jul"]

{"sheet":"VLOOKUP","index":8,"n_rows":16,"n_cols":12,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,5,1,6],[1,1,1,3],[1,9,1,11]]}
[]
[null,"Applying VLOOKUP Function",null,null,null,"Table Array",null,null,null,"Do It Yourself"]
[]
[null,"Income","Month","Number",null,"Month","Number",null,null,"Income","Month","Number"]
[null,80000,"Feb",{"$f":"VLOOKUP(C5,$F$5:$G$16,2,FALSE)","v":2},null,"Jan",1,null,null,80000,"Feb"]
[null,75000,"Apr",{"$f":"VLOOKUP(C6,$F$5:$G$16,2,FALSE)","v":4},null,"Feb",2,null,null,75000,"Apr"]
[null,65000,"Dec",12,null,"Mar",3,null,null,65000,"Dec"]
[null,85000,"Jan",1,null,"Apr",4,null,null,85000,"Jan"]
[null,76000,"Oct",10,null,"May",5,null,null,76000,"Oct"]
[null,78000,"Jul",7,null,"Jun",6,null,null,78000,"Jul"]
[null,null,null,null,null,"Jul",7]
[null,null,null,null,null,"Aug",8]
[null,null,null,null,null,"Sep ",9]
[null,null,null,null,null,"Oct",10]
[null,null,null,null,null,"Nov",11]
[null,null,null,null,null,"Dec",12]