{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Dataset","Filter Function","Combination of Functions","Excel VBA"],"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,"Dataset"]
[]
[null,"Area","Sales Rep"]
[null,"California","Olivia"]
[null,"Texas","Emma"]
[null,"Alaska"]
[null,"Massachusetts","Oliver"]
[null,"Washington"]
[null,"Virginia","Charlotte"]

{"sheet":"Filter Function","index":1,"n_rows":10,"n_cols":12,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,10,1,11],[1,1,1,3]]}
[]
[null,"Utilizing FILTER Function",null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Area","Sales Rep","Sales Rep List",null,null,null,null,null,null,"Area","Sales Rep"]
[null,"California","Olivia",{"$f":"_xlfn._xlws.FILTER($C$5:$C$10,\n$C$5:$C$10 <> \"\")","v":"Olivia"},null,null,null,null,null,null,"California","Olivia"]
[null,"Texas","Emma","Emma",null,null,null,null,null,null,"Texas","Emma"]
[null,"Alaska",null,"Oliver",null,null,null,null,null,null,"Alaska"]
[null,"Massachusetts","Oliver","Charlotte",null,null,null,null,null,null,"Massachusetts","Oliver"]
[null,"Washington",null,null,null,null,null,null,null,null,"Washington"]
[null,"Virginia","Charlotte",null,null,null,null,null,null,null,"Virginia","Charlotte"]

{"sheet":"Combination of Functions","index":2,"n_rows":10,"n_cols":12,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,10,1,11],[1,1,1,3]]}
[]
[null,"Combining IFERROR, INDEX, SMALL, and ROW Functions",null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Area","Sales Rep","Sales Rep List",null,null,null,null,null,null,"Area","Sales Rep"]
[null,"California","Olivia",{"$f":"IFERROR(INDEX($C$5:$C$10,SMALL(IF($C$5:$C$10<>\"\",\nROW($C$5:$C$10)-ROW($C$5)+1),ROWS($C$5:$C5))),\"\")","v":"Olivia"},null,null,null,null,null,null,"California","Olivia"]
[null,"Texas","Emma",{"$f":"IFERROR(INDEX($C$5:$C$10,SMALL(IF($C$5:$C$10<>\"\",\nROW($C$5:$C$10)-ROW($C$5)+1),ROWS($C$5:$C6))),\"\")","v":"Emma"},null,null,null,null,null,null,"Texas","Emma"]
[null,"Alaska",null,{"$f":"IFERROR(INDEX($C$5:$C$10,SMALL(IF($C$5:$C$10<>\"\",\nROW($C$5:$C$10)-ROW($C$5)+1),ROWS($C$5:$C7))),\"\")","v":"Oliver"},null,null,null,null,null,null,"Alaska"]
[null,"Massachusetts","Oliver",{"$f":"IFERROR(INDEX($C$5:$C$10,SMALL(IF($C$5:$C$10<>\"\",\nROW($C$5:$C$10)-ROW($C$5)+1),ROWS($C$5:$C8))),\"\")","v":"Charlotte"},null,null,null,null,null,null,"Massachusetts","Oliver"]
[null,"Washington",null,{"$f":"IFERROR(INDEX($C$5:$C$10,SMALL(IF($C$5:$C$10<>\"\",\nROW($C$5:$C$10)-ROW($C$5)+1),ROWS($C$5:$C9))),\"\")","v":""},null,null,null,null,null,null,"Washington"]
[null,"Virginia","Charlotte",{"$f":"IFERROR(INDEX($C$5:$C$10,SMALL(IF($C$5:$C$10<>\"\",\nROW($C$5:$C$10)-ROW($C$5)+1),ROWS($C$5:$C10))),\"\")","v":""},null,null,null,null,null,null,"Virginia","Charlotte"]

{"sheet":"Excel VBA","index":3,"n_rows":10,"n_cols":12,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,10,1,11],[1,1,1,3]]}
[]
[null,"Running Excel VBA Code",null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Area","Sales Rep","Sales Rep List",null,null,null,null,null,null,"Area","Sales Rep"]
[null,"California","Olivia",{"$f":"_xlfn._xlws.FILTER($C$5:$C$10,\n$C$5:$C$10 <> \"\")","v":"Olivia"},null,null,null,null,null,null,"California","Olivia"]
[null,"Texas","Emma","Emma",null,null,null,null,null,null,"Texas","Emma"]
[null,"Alaska",null,"Oliver",null,null,null,null,null,null,"Alaska"]
[null,"Massachusetts","Oliver","Charlotte",null,null,null,null,null,null,"Massachusetts","Oliver"]
[null,"Washington",null,null,null,null,null,null,null,null,"Washington"]
[null,"Virginia","Charlotte",null,null,null,null,null,null,null,"Virginia","Charlotte"]