{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Dataset","Two Columns","Row Column","Named Ranges","VBA"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":53,"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":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Month-wise Sales"]
[]
[null,"Sales Rep","Jan","Feb","Mar"]
[null,"Jonas",2140,1646,2470]
[null,"Harry",2639,2022,2442]
[null,"Nick",2172,2497,2194]
[null,"Sara",2856,1512,2212]
[null,"John",2028,2491,2856]
[null,"Leon",2725,1138,2527]
[null,"Tom",2994,1679,2476]
[null,"Hardy",2266,1294,2368]
[null,"Mark",2140,1091,2026]
[null,"Chris",2584,1400,2089]
[null,"Dimik",2470,2279,2639]
[null,"Maxim",2606,2341,2053]

{"sheet":"Two Columns","index":1,"n_rows":16,"n_cols":11,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,8,1,10]]}
[]
[null,"Finding Intersection of Data Sets in Two Columns",null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Sales Rep","Jan","Mar","Intersection",null,null,null,"Sales Rep","Jan","Mar"]
[null,"Jonas",2140,2470,{"$f":"IF(ISERROR(MATCH(C5,$D$5:$D$16,0)),\"\",C5)","v":""},null,null,null,"Jonas",2140,2470]
[null,"Harry",2639,2442,{"$f":"IF(ISERROR(MATCH(C6,$D$5:$D$16,0)),\"\",C6)","v":2639},null,null,null,"Harry",2639,2442]
[null,"Nick",2172,2194,"",null,null,null,"Nick",2172,2194]
[null,"Sara",2856,2212,2856,null,null,null,"Sara",2856,2212]
[null,"John",2028,2856,"",null,null,null,"John",2028,2856]
[null,"Leon",2725,2527,"",null,null,null,"Leon",2725,2527]
[null,"Tom",2994,2476,"",null,null,null,"Tom",2994,2476]
[null,"Hardy",2266,2368,"",null,null,null,"Hardy",2266,2368]
[null,"Mark",2140,2026,"",null,null,null,"Mark",2140,2026]
[null,"Chris",2584,2089,"",null,null,null,"Chris",2584,2089]
[null,"Dimik",2470,2639,2470,null,null,null,"Dimik",2470,2639]
[null,"Maxim",2606,2053,"",null,null,null,"Maxim",2606,2053]

{"sheet":"Row Column","index":2,"n_rows":24,"n_cols":10,"rows_kept":24,"cut":false,"hidden":false,"merged":[[1,1,1,4],[21,2,21,3],[22,2,22,3],[7,9,7,10],[8,9,8,10],[1,8,1,10]]}
[]
[null,"Getting Intersection of Row and Column",null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Sales Rep","Jan","Feb","Mar",null,null,null,"Sales Rep","Sara"]
[null,"Jonas",2140,1646,2470,null,null,null,"Month","Jan"]
[null,"Harry",2639,2022,2442,null,null,null,"Sales"]
[null,"Nick",2172,2497,2194]
[null,"Sara",2856,1512,2212,null,null,null,"Sales Rep","Tom"]
[null,"John",2028,2491,2856,null,null,null,"Month","Jan, Feb"]
[null,"Leon",2725,1138,2527,null,null,null,"Sales"]
[null,"Tom",2994,1679,2476]
[null,"Hardy",2266,1294,2368]
[null,"Mark",2140,1091,2026]
[null,"Chris",2584,1400,2089]
[null,"Dimik",2470,2279,2639]
[null,"Maxim",2606,2341,2053]
[]
[null,"Sales Rep","Harry"]
[null,"Month","Mar"]
[null,"Sales",{"$f":"B6:E6 E4:E16","v":2442}]
[]
[null,"Sales Rep","Harry"]
[null,"Month","Feb, Mar"]
[null,"Sales",{"$f":"B6:E6 D4:E16","v":2022},2442]

{"sheet":"Named Ranges","index":3,"n_rows":20,"n_cols":9,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,8,1,9]]}
[]
[null,"Applying Intersect Operator with Named Ranges",null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Sales Rep","Jan","Feb","Mar",null,null,null,"Sales Rep"]
[null,"Jonas",2140,1646,2470,null,null,null,"Month"]
[null,"Harry",2639,2022,2442,null,null,null,"Sales"]
[null,"Nick",2172,2497,2194]
[null,"Sara",2856,1512,2212]
[null,"John",2028,2491,2856]
[null,"Leon",2725,1138,2527]
[null,"Tom",2994,1679,2476]
[null,"Hardy",2266,1294,2368]
[null,"Mark",2140,1091,2026]
[null,"Chris",2584,1400,2089]
[null,"Dimik",2470,2279,2639]
[null,"Maxim",2606,2341,2053]
[]
[null,"Sales Rep","John"]
[null,"Month","Mar"]
[null,"Sales",{"$f":"INDIRECT(C18) INDIRECT(C19)","v":2856}]

{"sheet":"VBA","index":4,"n_rows":16,"n_cols":12,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,8,1,11]]}
[]
[null,"Employing VBA Code",null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Sales Rep","Jan","Mar","Intersection",null,null,null,"Sales Rep","Jan","Mar","Intersection"]
[null,"Jonas",2140,2470,null,null,null,null,"Jonas",2140,2470]
[null,"Harry",2639,2442,2639,null,null,null,"Harry",2639,2442]
[null,"Nick",2172,2194,null,null,null,null,"Nick",2172,2194]
[null,"Sara",2856,2212,2856,null,null,null,"Sara",2856,2212]
[null,"John",2028,2856,null,null,null,null,"John",2028,2856]
[null,"Leon",2725,2527,null,null,null,null,"Leon",2725,2527]
[null,"Tom",2994,2476,null,null,null,null,"Tom",2994,2476]
[null,"Hardy",2266,2368,null,null,null,null,"Hardy",2266,2368]
[null,"Mark",2140,2026,null,null,null,null,"Mark",2140,2026]
[null,"Chris",2584,2089,null,null,null,null,"Chris",2584,2089]
[null,"Dimik",2470,2639,2470,null,null,null,"Dimik",2470,2639]
[null,"Maxim",2606,2053,null,null,null,null,"Maxim",2606,2053]