{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Dataset","Cell Value","Drop-down list","Or Operator","And Operator"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":4,"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":15,"n_cols":5,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Dataset"]
[]
[null,"Name of Sites","Category of the Sites","Platforms","Number of Visits"]
[null,"Site 1","Education","Web",5089]
[null,"Site 2","Sport","Mobile",6158]
[null,"Site 3","Tourism","Web",7227]
[null,"Site 4","Sport","Mobile",8296]
[null,"Site 5","Education","Web",9365]
[null,"Site 6","Sport","Mobile",10434]
[null,"Site 7","Education","Web",11503]
[null,"Site 8","Education","Mobile",12572]
[null,"Site 9","Tourism","Web",13641]
[null,"Site 10","Sport","Mobile",14710]
[null,"Site 11","Tourism","Web",15779]

{"sheet":"Cell Value","index":1,"n_rows":15,"n_cols":7,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,4],[5,6,6,6]]}
[]
[null,"Excel VBA: Filter Based on Cell Value"]
[]
[null,"Name of Sites","Category of the Sites","Platforms","Number of Visits",null,"Category of the Sites"]
[null,"Site 1","Education","Web",5089,null,"Education"]
[null,"Site 2","Sport","Mobile",6158,null,"Location: Cells(5,7).Value"]
[null,"Site 3","Tourism","Web",7227]
[null,"Site 4","Sport","Mobile",8296]
[null,"Site 5","Education","Web",9365]
[null,"Site 6","Sport","Mobile",10434]
[null,"Site 7","Education","Web",11503]
[null,"Site 8","Education","Mobile",12572]
[null,"Site 9","Tourism","Web",13641]
[null,"Site 10","Sport","Mobile",14710]
[null,"Site 11","Tourism","Web",15779]

{"sheet":"Drop-down list","index":2,"n_rows":15,"n_cols":7,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Excel VBA: Filter Using a Drop-down List "]
[]
[null,"Name of Sites","Category of the Sites","Platforms","Number of Visits",null,"Platforms"]
[null,"Site 1","Education","Web",5089,null,"Web"]
[null,"Site 2","Sport","Mobile",6158]
[null,"Site 3","Tourism","Web",7227]
[null,"Site 4","Sport","Mobile",8296]
[null,"Site 5","Education","Web",9365]
[null,"Site 6","Sport","Mobile",10434]
[null,"Site 7","Education","Web",11503]
[null,"Site 8","Education","Mobile",12572]
[null,"Site 9","Tourism","Web",13641]
[null,"Site 10","Sport","Mobile",14710]
[null,"Site 11","Tourism","Web",15779]

{"sheet":"Or Operator","index":3,"n_rows":15,"n_cols":8,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,"Excel VBA: Multiple Criteria Using OR Logic"]
[]
[null,"Name of Sites","Category of the Sites","Platforms","Number of Visits",null,"Category1","Category2 "]
[null,"Site 1","Sport","Web",5089,null,"Entertainment","Sport"]
[null,"Site 2","Sport","Mobile",6158]
[null,"Site 3","Tourism","Web",7227]
[null,"Site 4","Sport","Mobile",8296]
[null,"Site 5","Education","Web",9365]
[null,"Site 6","Sport","Mobile",10434]
[null,"Site 7","Education","Web",11503]
[null,"Site 8","Education","Mobile",12572]
[null,"Site 9","Tourism","Web",13641]
[null,"Site 10","Sport","Mobile",14710]
[null,"Site 11","Tourism","Web",15779]

{"sheet":"And Operator","index":4,"n_rows":15,"n_cols":8,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,"Excel VBA: Multiple Criteria Using AND Logic"]
[]
[null,"Name of Sites","Category of the Sites","Platforms","Number of Visits",null,"Platforms","Number of Visits"]
[null,"Site 1","Education","Web",5089,null,"Web",">=5000 & <=15000"]
[null,"Site 2","Sport","Mobile",6158]
[null,"Site 3","Tourism","Web",7227]
[null,"Site 4","Sport","Mobile",8296]
[null,"Site 5","Education","Web",9365]
[null,"Site 6","Sport","Mobile",10434]
[null,"Site 7","Education","Web",11503]
[null,"Site 8","Education","Mobile",12572]
[null,"Site 9","Tourism","Web",13641]
[null,"Site 10","Sport","Mobile",14710]
[null,"Site 11","Tourism","Web",15779]