{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Find_Replace","Filter","Advanced_Filter","Defined_Table","FILTER_function","INDEX","VBA_UDF","Single_Cell","Dataset"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"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":"Find_Replace","index":0,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Use of Find & Replace Tool"]
[]
[null,"Name","Hobby"]
[null,"Emily","Photography"]
[null,"Jenifer","Dance"]
[null,"Sheryl","Cooking"]
[null,"Emily","Painting"]
[null,"Michel","Writing"]
[null,"Donald","Handicraft"]
[null,"Emily","Hiking"]

{"sheet":"Filter","index":1,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Use of Filter Option"]
[]
[null,"Name","Hobby"]
[null,"Emily","Photography"]
[null,"Jenifer","Dance"]
[null,"Sheryl","Cooking"]
[null,"Emily","Painting"]
[null,"Michel","Writing"]
[null,"Donald","Handicraft"]
[null,"Emily","Hiking"]

{"sheet":"Advanced_Filter","index":2,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Use of Advanced Filter"]
[]
[null,"Name","Hobby"]
[null,"Emily","Photography"]
[null,"Jenifer","Dance"]
[null,"Sheryl","Cooking"]
[null,"Emily","Painting"]
[null,"Michel","Writing"]
[null,"Donald","Handicraft"]
[null,"Emily","Hiking"]
[]
[null,"Name","Hobby"]
[null,"Emily"]

{"sheet":"Defined_Table","index":3,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Use of Excel Defined Table"]
[]
[null,"Name","Hobby"]
[null,"Emily","Photography"]
[null,"Jenifer","Dance"]
[null,"Sheryl","Cooking"]
[null,"Emily","Painting"]
[null,"Michel","Writing"]
[null,"Donald","Handicraft"]
[null,"Emily","Hiking"]

{"sheet":"FILTER_function","index":4,"n_rows":16,"n_cols":12,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,10,1,11]]}
[]
[null,"Use of FILTER Function",null,null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Name","Hobby",null,null,null,null,null,null,null,"Name","Hobby"]
[null,"Emily","Photography",null,null,null,null,null,null,null,"Emily","Photography"]
[null,"Jenifer","Dance",null,null,null,null,null,null,null,"Jenifer","Dance"]
[null,"Sheryl","Cooking",null,null,null,null,null,null,null,"Sheryl","Cooking"]
[null,"Emily","Painting",null,null,null,null,null,null,null,"Emily","Painting"]
[null,"Michel","Writing",null,null,null,null,null,null,null,"Michel","Writing"]
[null,"Donald","Handicraft",null,null,null,null,null,null,null,"Donald","Handicraft"]
[null,"Emily","Hiking",null,null,null,null,null,null,null,"Emily","Hiking"]
[]
[null,"Name","Hobby",null,null,null,null,null,null,null,"Name","Hobby"]
[null,"Emily",{"$f":"_xlfn._xlws.FILTER(C5:C11,B5:B11=B14)","v":"Photography"},null,null,null,null,null,null,null,"Emily"]
[null,null,"Painting"]
[null,null,"Hiking"]

{"sheet":"INDEX","index":5,"n_rows":17,"n_cols":12,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,10,1,11]]}
[]
[null,"Use of INDEX Function",null,null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Name","Hobby",null,null,null,null,null,null,null,"Name","Hobby"]
[null,"Emily","Photography",null,null,null,null,null,null,null,"Emily","Photography"]
[null,"Jenifer","Dance",null,null,null,null,null,null,null,"Jenifer","Dance"]
[null,"Sheryl","Cooking",null,null,null,null,null,null,null,"Sheryl","Cooking"]
[null,"Emily","Painting",null,null,null,null,null,null,null,"Emily","Painting"]
[null,"Michel","Writing",null,null,null,null,null,null,null,"Michel","Writing"]
[null,"Donald","Handicraft",null,null,null,null,null,null,null,"Donald","Handicraft"]
[null,"Emily","Hiking",null,null,null,null,null,null,null,"Emily","Hiking"]
[]
[null,"Name","Hobby",null,null,null,null,null,null,null,"Name","Hobby"]
[null,"Emily",{"$f":"IF(ISERROR(INDEX($B$5:$C$11,SMALL(IF($B$5:$B$11=$B$14,ROW($B$5:$B$11)),ROW(1:1))-4,2)),\"\",INDEX($B$5:$C$11,SMALL(IF($B$5:$B$11=$B$14,ROW($B$5:$B$11)),ROW(1:1))-4,2))","v":"Photography"},null,null,null,null,null,null,null,"Emily"]
[null,null,{"$f":"IF(ISERROR(INDEX($B$5:$C$11,SMALL(IF($B$5:$B$11=$B$14,ROW($B$5:$B$11)),ROW(2:2))-4,2)),\"\",INDEX($B$5:$C$11,SMALL(IF($B$5:$B$11=$B$14,ROW($B$5:$B$11)),ROW(2:2))-4,2))","v":"Painting"}]
[null,null,{"$f":"IF(ISERROR(INDEX($B$5:$C$11,SMALL(IF($B$5:$B$11=$B$14,ROW($B$5:$B$11)),ROW(3:3))-4,2)),\"\",INDEX($B$5:$C$11,SMALL(IF($B$5:$B$11=$B$14,ROW($B$5:$B$11)),ROW(3:3))-4,2))","v":"Hiking"}]
[null,null,{"$f":"IF(ISERROR(INDEX($B$5:$C$11,SMALL(IF($B$5:$B$11=$B$14,ROW($B$5:$B$11)),ROW(4:4))-4,2)),\"\",INDEX($B$5:$C$11,SMALL(IF($B$5:$B$11=$B$14,ROW($B$5:$B$11)),ROW(4:4))-4,2))","v":""},{"$f":"IF(ISERROR(INDEX($B$5:$C$11,SMALL(IF($B$5:$B$11=$B$14,ROW($B$5:$B$11)),ROW(4:4))-4,2)),\"\",INDEX($B$5:$C$11,SMALL(IF($B$5:$B$11=$B$14,ROW($B$5:$B$11)),ROW(4:4))-4,2))","v":""}]

{"sheet":"VBA_UDF","index":6,"n_rows":16,"n_cols":12,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,10,1,11]]}
[]
[null,"User Defined Function",null,null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Name","Hobby",null,null,null,null,null,null,null,"Name","Hobby"]
[null,"Emily","Photography",null,null,null,null,null,null,null,"Emily","Photography"]
[null,"Jenifer","Dance",null,null,null,null,null,null,null,"Jenifer","Dance"]
[null,"Sheryl","Cooking",null,null,null,null,null,null,null,"Sheryl","Cooking"]
[null,"Emily","Painting",null,null,null,null,null,null,null,"Emily","Painting"]
[null,"Michel","Writing",null,null,null,null,null,null,null,"Michel","Writing"]
[null,"Donald","Handicraft",null,null,null,null,null,null,null,"Donald","Handicraft"]
[null,"Emily","Hiking",null,null,null,null,null,null,null,"Emily","Hiking"]
[]
[null,"Name","Hobby",null,null,null,null,null,null,null,"Name","Hobby"]
[null,"Emily",{"$f":"vbaVlookup(B14,B5:B11,2)","v":"Photography"},null,null,null,null,null,null,null,"Emily"]
[null,null,"Painting"]
[null,null,"Hiking"]

{"sheet":"Single_Cell","index":7,"n_rows":14,"n_cols":12,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,10,1,11]]}
[]
[null,"Multiple Values in Single Cell",null,null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Name","Hobby",null,null,null,null,null,null,null,"Name","Hobby"]
[null,"Emily","Photography",null,null,null,null,null,null,null,"Emily","Photography"]
[null,"Jenifer","Dance",null,null,null,null,null,null,null,"Jenifer","Dance"]
[null,"Sheryl","Cooking",null,null,null,null,null,null,null,"Sheryl","Cooking"]
[null,"Emily","Painting",null,null,null,null,null,null,null,"Emily","Painting"]
[null,"Michel","Writing",null,null,null,null,null,null,null,"Michel","Writing"]
[null,"Donald","Handicraft",null,null,null,null,null,null,null,"Donald","Handicraft"]
[null,"Emily","Hiking",null,null,null,null,null,null,null,"Emily","Hiking"]
[]
[null,"Name","Hobby",null,null,null,null,null,null,null,"Name","Hobby"]
[null,"Emily",{"$f":"_xlfn.TEXTJOIN(\",\",TRUE, _xlfn._xlws.FILTER(C5:C11, B5:B11=B14))","v":"Photography,Painting,Hiking"},null,null,null,null,null,null,null,"Emily"]

{"sheet":"Dataset","index":8,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Dataset"]
[]
[null,"Name","Hobby"]
[null,"Emily","Photography"]
[null,"Jenifer","Dance"]
[null,"Sheryl","Cooking"]
[null,"Emily","Painting"]
[null,"Michel","Writing"]
[null,"Donald","Handicraft"]
[null,"Emily","Hiking"]