{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Dataset","Top Sales Person(April)","Top Sales Person(May)","Top Sales Person(June)","Using Sort & Filter Group","Append1","Use of Power Query","Employing User Defined Function","Applying VBA"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":6,"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],[3,1,3,2]]}
[]
[null,"Creating A List of Unique Values"]
[]
[null,"Top Sales Person in April"]
[null,"Name","Sales"]
[null,"Glenn",500]
[null,"Toni",475]
[null,"Mark",422]
[null,"Bruce",364]
[null,"Lucy",315]

{"sheet":"Top Sales Person(April)","index":1,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2],[3,1,3,2]]}
[]
[null,"Creating A List of Unique Values"]
[]
[null,"Top Sales Person in April"]
[null,"Name","Sales"]
[null,"Glenn",500]
[null,"Toni",475]
[null,"Mark",422]
[null,"Bruce",364]
[null,"Lucy",315]

{"sheet":"Top Sales Person(May)","index":2,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2],[3,1,3,2]]}
[]
[null,"Creating A List of Unique Values"]
[]
[null,"Top Sales Person in May"]
[null,"Name","Sales"]
[null,"Mark",600]
[null,"Geralt",570]
[null,"Toni",500]
[null,"Kim",468]
[null,"Glenn",426]

{"sheet":"Top Sales Person(June)","index":3,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2],[3,1,3,2]]}
[]
[null,"Creating A List of Unique Values"]
[]
[null,"Top Sales Person in June"]
[null,"Name","Sales"]
[null,"Anne",540]
[null,"Geralt",528]
[null,"Lucy",502]
[null,"Mark",495]
[null,"Michael",482]

{"sheet":"Using Sort & Filter Group","index":4,"n_rows":19,"n_cols":6,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Using Sort & Filter Group",null,null,null,"Do it Yourself"]
[]
[null,"Name",null,null,null,"Name"]
[null,"Glenn"]
[null,"Toni"]
[null,"Mark"]
[null,"Bruce"]
[null,"Lucy"]
[null,"Mark"]
[null,"Geralt"]
[null,"Toni"]
[null,"Kim"]
[null,"Glenn"]
[null,"Anne"]
[null,"Geralt"]
[null,"Lucy"]
[null,"Mark"]
[null,"Michael"]

{"sheet":"Append1","index":5,"n_rows":12,"n_cols":2,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Use of Power Query"]
[null,"Name"]
[null,"Glenn"]
[null,"Toni"]
[null,"Mark"]
[null,"Bruce"]
[null,"Lucy"]
[null,"Anne"]
[null,"Geralt"]
[null,"Michael"]
[null,"Kim"]

{"sheet":"Use of Power Query","index":6,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2],[3,1,3,2]]}
[]
[null,"Use of Power Query"]
[]
[null,"Top Sales Person in April"]
[null,"Name","Sales"]
[null,"Glenn",500]
[null,"Toni",475]
[null,"Mark",422]
[null,"Bruce",364]
[null,"Lucy",315]

{"sheet":"Employing User Defined Function","index":7,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Employing User Defined Function",null,null,null,"Do it Yourself"]
[]
[null,"Name",null,null,null,"Name"]
[null,{"$f":"_xlfn.UNIQUE(TRANSPOSE(split_function(_xlfn.TEXTJOIN(\",\",,'Top Sales Person(April):Top Sales Person(June)'!B6:B10))))","v":"Glenn"}]
[null,"Toni"]
[null,"Mark"]
[null,"Bruce"]
[null,"Lucy"]
[null,"Geralt"]
[null,"Kim"]
[null,"Anne"]
[null,"Michael"]

{"sheet":"Applying VBA","index":8,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Applying VBA"]