{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Dataset","OFFSETFunction","Find and Replace","Excel VBA"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2],[11,1,11,2],[12,1,12,2]]}
[]
[null,"Dataset"]
[]
[null,"Product","Area"]
[null,"Keyboard","Florida"]
[null,"Mouse","Louisiana"]
[null,"Headset"]
[null,"Laptop","Delaware"]
[null,"Webcam"]
[null,"Printer","California"]
[]
[null,"Select Area"]

{"sheet":"OFFSETFunction","index":1,"n_rows":12,"n_cols":14,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,12,1,13],[1,1,1,3],[11,1,11,3],[12,1,12,3]]}
[]
[null,"Combining FILTER and OFFSET Functions",null,null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Product","Area","Area for Drop Down",null,null,null,null,null,null,null,null,"Product","Area"]
[null,"Keyboard","Florida",{"$f":"_xlfn._xlws.FILTER(C5:C10,\nC5:C10<>\"\")","v":"Florida"},null,null,null,null,null,null,null,null,"Keyboard","Florida"]
[null,"Mouse","Louisiana","Louisiana",null,null,null,null,null,null,null,null,"Mouse","Louisiana"]
[null,"Headset",null,"Delaware",null,null,null,null,null,null,null,null,"Headset"]
[null,"Laptop","Delaware","California",null,null,null,null,null,null,null,null,"Laptop","Delaware"]
[null,"Webcam",null,null,null,null,null,null,null,null,null,null,"Webcam"]
[null,"Printer","California",null,null,null,null,null,null,null,null,null,"Printer","California"]
[]
[null,"Select Area"]

{"sheet":"Find and Replace","index":2,"n_rows":10,"n_cols":15,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,13,1,14],[1,1,1,4]]}
[]
[null,"Using Find & Select Feature",null,null,null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Product","Area",null,"Select Area",null,null,null,null,null,null,null,null,"Product","Area"]
[null,"Keyboard","Florida",null,null,null,null,null,null,null,null,null,null,"Keyboard","Florida"]
[null,"Mouse","Louisiana",null,null,null,null,null,null,null,null,null,null,"Mouse","Louisiana"]
[null,"Headset","Delaware",null,null,null,null,null,null,null,null,null,null,"Headset"]
[null,"Laptop","California",null,null,null,null,null,null,null,null,null,null,"Laptop","Delaware"]
[null,"Webcam",null,null,null,null,null,null,null,null,null,null,null,"Webcam"]
[null,"Printer",null,null,null,null,null,null,null,null,null,null,null,"Printer","California"]

{"sheet":"Excel VBA","index":3,"n_rows":12,"n_cols":14,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,12,1,13],[1,1,1,3],[11,1,11,3],[12,1,12,3]]}
[]
[null,"Running Excel VBA Code",null,null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Product","Area","Area for Drop Down",null,null,null,null,null,null,null,null,"Product","Area"]
[null,"Keyboard","Florida",{"$f":"_xlfn._xlws.FILTER(C5:C10,C5:C10<>\"\")","v":"Florida"},null,null,null,null,null,null,null,null,"Keyboard","Florida"]
[null,"Mouse","Louisiana","Louisiana",null,null,null,null,null,null,null,null,"Mouse","Louisiana"]
[null,"Headset",null,"Delaware",null,null,null,null,null,null,null,null,"Headset"]
[null,"Laptop","Delaware","California",null,null,null,null,null,null,null,null,"Laptop","Delaware"]
[null,"Webcam",null,null,null,null,null,null,null,null,null,null,"Webcam"]
[null,"Printer","California",null,null,null,null,null,null,null,null,null,"Printer","California"]
[]
[null,"Select Area"]