{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Dataset","Advanced Filter","Filter","Remove Duplicate","VBA","Pivot Table","Power Query","Formula"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":17,"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":"Dataset","index":0,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Sample Dataset"]
[]
[null,"Country","Name","Position"]
[null,"India","Agar","Engineer"]
[null,"China","Amy","Sr. Engineer"]
[null,"China","Lee","Engineer"]
[null,"UK","Robert","Engineer"]
[null,"India","Yoges","Manager"]
[null,"India","Kabir","Sr. Engineer"]
[null,"UK","Jeson","Engineer"]

{"sheet":"Advanced Filter","index":1,"n_rows":11,"n_cols":12,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,9,1,11]]}
[]
[null,"Use of Advanced Filter Feature",null,null,null,null,null,null,null,">>> Do It Yourself <<<"]
[]
[null,"Country","Name","Position",null,"Country",null,null,null,"Country","Name","Position"]
[null,"India","Agar","Engineer",null,"India",null,null,null,"India","Agar","Engineer"]
[null,"China","Amy","Sr. Engineer",null,"China",null,null,null,"China","Amy","Sr. Engineer"]
[null,"China","Lee","Engineer",null,"UK",null,null,null,"China","Lee","Engineer"]
[null,"UK","Robert","Engineer",null,null,null,null,null,"UK","Robert","Engineer"]
[null,"India","Yoges","Manager",null,null,null,null,null,"India","Yoges","Manager"]
[null,"India","Kabir","Sr. Engineer",null,null,null,null,null,"India","Kabir","Sr. Engineer"]
[null,"UK","Jeson","Engineer",null,null,null,null,null,"UK","Jeson","Engineer"]

{"sheet":"Filter","index":2,"n_rows":11,"n_cols":10,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,7,1,9]]}
[]
[null,"Use of Filter Tool",null,null,null,null,null,">>> Do It Yourself <<<"]
[]
[null,"Country","Name","Position","Test",null,null,"Country","Name","Position"]
[null,null,"Lee","Engineer",{"$f":"B5=B6","v":false},null,null,"India","Agar","Engineer"]
[null,"China","Agar","Engineer",{"$f":"B6=B7","v":false},null,null,"China","Amy","Sr. Engineer"]
[null,null,"Amy","Sr. Engineer",true,null,null,"China","Lee","Engineer"]
[null,null,"Kabir","Sr. Engineer",false,null,null,"UK","Robert","Engineer"]
[null,"India","Robert","Engineer",false,null,null,"India","Yoges","Manager"]
[null,null,"Yoges","Manager",false,null,null,"India","Kabir","Sr. Engineer"]
[null,"UK","Jeson","Engineer",false,null,null,"UK","Jeson","Engineer"]

{"sheet":"Remove Duplicate","index":3,"n_rows":11,"n_cols":13,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,10,1,12]]}
[]
[null,"Employing Remove Duplicates Tool",null,null,null,null,null,null,null,null,">>> Do It Yourself <<<"]
[]
[null,"Country","Name","Position",null,"Country",null,null,null,null,"Country","Name","Position"]
[null,"India","Agar","Engineer",null,"India",null,null,null,null,"India","Agar","Engineer"]
[null,"China","Amy","Sr. Engineer",null,"China",null,null,null,null,"China","Amy","Sr. Engineer"]
[null,"China","Lee","Engineer",null,"UK",null,null,null,null,"China","Lee","Engineer"]
[null,"UK","Robert","Engineer",null,null,null,null,null,null,"UK","Robert","Engineer"]
[null,"India","Yoges","Manager",null,null,null,null,null,null,"India","Yoges","Manager"]
[null,"India","Kabir","Sr. Engineer",null,null,null,null,null,null,"India","Kabir","Sr. Engineer"]
[null,"UK","Jeson","Engineer",null,null,null,null,null,null,"UK","Jeson","Engineer"]

{"sheet":"VBA","index":4,"n_rows":11,"n_cols":13,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,8,1,12]]}
[]
[null,"Applying VBA Code",null,null,null,null,null,null,">>> Do It Yourself <<<"]
[]
[null,"Country","Name","Position",null,"Country",null,null,"Country","Name","Position",null,"Country"]
[null,"India","Agar","Engineer",null,"India",null,null,"India","Agar","Engineer",null,"India"]
[null,"China","Amy","Sr. Engineer",null,"China",null,null,"China","Amy","Sr. Engineer",null,"China"]
[null,"China","Lee","Engineer",null,"UK",null,null,"China","Lee","Engineer",null,"China"]
[null,"UK","Robert","Engineer",null,null,null,null,"UK","Robert","Engineer",null,"UK"]
[null,"India","Yoges","Manager",null,null,null,null,"India","Yoges","Manager",null,"India"]
[null,"India","Kabir","Sr. Engineer",null,null,null,null,"India","Kabir","Sr. Engineer",null,"India"]
[null,"UK","Jeson","Engineer",null,null,null,null,"UK","Jeson","Engineer",null,"UK"]

{"sheet":"Pivot Table","index":5,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using Pivot Table Feature"]
[]
[null,"Country","Name","Position",null,"Row Labels"]
[null,"India","Agar","Engineer",null,"China"]
[null,"China","Amy","Sr. Engineer",null,"India"]
[null,"China","Lee","Engineer",null,"UK"]
[null,"UK","Robert","Engineer",null,"Grand Total"]
[null,"India","Yoges","Manager"]
[null,"India","Kabir","Sr. Engineer"]
[null,"UK","Jeson","Engineer"]

{"sheet":"Power Query","index":6,"n_rows":11,"n_cols":10,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,7,1,9]]}
[]
[null,"Inserting Power Query",null,null,null,null,null,">>> Do It Yourself <<<"]
[]
[null,"Country","Name","Position",null,"Country",null,"Country","Name","Position"]
[null,"India","Agar","Engineer",null,"India",null,"India","Agar","Engineer"]
[null,"China","Amy","Sr. Engineer",null,"China",null,"China","Amy","Sr. Engineer"]
[null,"China","Lee","Engineer",null,"UK",null,"China","Lee","Engineer"]
[null,"UK","Robert","Engineer",null,null,null,"UK","Robert","Engineer"]
[null,"India","Yoges","Manager",null,null,null,"India","Yoges","Manager"]
[null,"India","Kabir","Sr. Engineer",null,null,null,"India","Kabir","Sr. Engineer"]
[null,"UK","Jeson","Engineer",null,null,null,"UK","Jeson","Engineer"]

{"sheet":"Formula","index":7,"n_rows":11,"n_cols":9,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,7,1,8]]}
[]
[null,"Applying Formula",null,null,null,null,null,">>> Do It Yourself <<<"]
[]
[null,"Country","Occurance",null,null,null,null,"Country","Occurance"]
[null,"India",{"$f":"COUNTIFS($B$5:B5,B5)","v":1},null,null,null,null,"India"]
[null,"China",{"$f":"COUNTIFS($B$5:B6,B6)","v":1},null,null,null,null,"China"]
[null,null,{"$f":"COUNTIFS($B$5:B7,B7)","v":0},null,null,null,null,"China"]
[null,"UK",{"$f":"COUNTIFS($B$5:B8,B8)","v":1},null,null,null,null,"UK"]
[null,null,{"$f":"COUNTIFS($B$5:B9,B9)","v":0},null,null,null,null,"India"]
[null,null,{"$f":"COUNTIFS($B$5:B10,B10)","v":0},null,null,null,null,"India"]
[null,null,{"$f":"COUNTIFS($B$5:B11,B11)","v":0},null,null,null,null,"UK"]