{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Dataset","Simple Way","Advanced Filter","Advanced Filter 2","Auto Filter","VBA_OR","VBA AND","FILTER Function","FILTER Function1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":7,"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":19,"n_cols":7,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"How to Apply Multiple Filters in Excel"]
[]
[null,"Name of Sites","Category of the Sites","Date","Platforms","Number of Visits","New Subscribers"]
[null,"Site 1","Education","2021-06-01","Web",5089,102]
[null,"Site 2","Sport","2021-06-02","Mobile",6158,150]
[null,"Site 3","Tourism","2021-06-03","Web",7227,198]
[null,"Site 4","Sport","2021-06-04","Mobile",8296,246]
[null,"Site 5","Education","2021-06-07","Web",9365,294]
[null,"Site 6","Sport","2021-06-08","Mobile",10434,342]
[null,"Site 7","Education","2021-06-09","Web",11503,390]
[null,"Site 8","Education","2021-06-10","Mobile",12572,438]
[null,"Site 9","Tourism","2021-06-11","Web",13641,486]
[null,"Site 10","Sport","2021-06-14","Mobile",14710,534]
[null,"Site 11","Tourism","2021-06-15","Web",15779,582]
[null,"Site 12","Education","2021-06-16","Web",16848,630]
[null,"Site 13","Education","2021-06-17","Mobile",17917,678]
[null,"Site 14","Tourism","2021-06-18","Web",18986,726]
[null,"Site 15","Sport","2021-06-19","Mobile",20055,774]

{"sheet":"Simple Way","index":1,"n_rows":19,"n_cols":6,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Number of Visits via Educational Site & Mobile Platform"]
[]
[null,"Name of Sites","Category of the Sites","Date","Platforms","Number of Visits"]
[null,"Site 1","Education","2021-06-01","Web",5089]
[null,"Site 2","Sport","2021-06-02","Mobile",6158]
[null,"Site 3","Tourism","2021-06-03","Web",7227]
[null,"Site 4","Sport","2021-06-04","Mobile",8296]
[null,"Site 5","Education","2021-06-07","Web",9365]
[null,"Site 6","Sport","2021-06-08","Mobile",10434]
[null,"Site 7","Education","2021-06-09","Web",11503]
[null,"Site 8","Education","2021-06-10","Mobile",12572]
[null,"Site 9","Tourism","2021-06-11","Web",13641]
[null,"Site 10","Sport","2021-06-14","Mobile",14710]
[null,"Site 11","Tourism","2021-06-15","Web",15779]
[null,"Site 12","Education","2021-06-09","Web",16848]
[null,"Site 13","Education","2021-06-10","Mobile",17917]
[null,"Site 14","Tourism","2021-06-11","Web",18986]
[null,"Site 15","Sport","2021-06-14","Mobile",20055]

{"sheet":"Advanced Filter","index":2,"n_rows":19,"n_cols":10,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,7,1,9]]}
[]
[null,"Multiple Filters Using Advanced Filter Option",null,null,null,null,null,"Criteria"]
[]
[null,"Name of Sites","Category of the Sites","Platforms","Number of Visits","New Subscribers",null,"Category of the Sites","Number of Visits","New Subscribers"]
[null,"Site 1","Education","Web",5089,102,null,"Education",">10000",">400"]
[null,"Site 2","Sport","Mobile",6158,150]
[null,"Site 3","Tourism","Web",7227,198]
[null,"Site 4","Sport","Mobile",8296,246]
[null,"Site 5","Education","Web",9365,294]
[null,"Site 6","Sport","Mobile",10434,342]
[null,"Site 7","Education","Web",11503,390]
[null,"Site 8","Education","Mobile",12572,438]
[null,"Site 9","Tourism","Web",13641,486]
[null,"Site 10","Sport","Mobile",14710,534]
[null,"Site 11","Tourism","Web",15779,582]
[null,"Site 12","Education","Web",16848,630]
[null,"Site 13","Education","Mobile",17917,678]
[null,"Site 14","Tourism","Web",18986,726]
[null,"Site 15","Sport","Mobile",20055,774]

{"sheet":"Advanced Filter 2","index":3,"n_rows":19,"n_cols":10,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Multiple Filters Using Advanced Filter Option"]
[]
[null,"Name of Sites","Category of the Sites","Platforms","Number of Visits","New Subscribers"]
[null,"Site 1","Education","Web",5089,102,null,"Education",">10000",">400"]
[null,"Site 2","Sport","Mobile",6158,150]
[null,"Site 3","Tourism","Web",7227,198]
[null,"Site 4","Sport","Mobile",8296,246]
[null,"Site 5","Education","Web",9365,294]
[null,"Site 6","Sport","Mobile",10434,342]
[null,"Site 7","Education","Web",11503,390]
[null,"Site 8","Education","Mobile",12572,438]
[null,"Site 9","Tourism","Web",13641,486]
[null,"Site 10","Sport","Mobile",14710,534]
[null,"Site 11","Tourism","Web",15779,582]
[null,"Site 12","Education","Web",16848,630]
[null,"Site 13","Education","Mobile",17917,678]
[null,"Site 14","Tourism","Web",18986,726]
[null,"Site 15","Sport","Mobile",20055,774]

{"sheet":"Auto Filter","index":4,"n_rows":23,"n_cols":7,"rows_kept":23,"cut":false,"hidden":false,"merged":[[1,1,1,6],[21,1,21,4],[22,1,22,4],[20,1,20,4]]}
[]
[null,"AutoFilter Option in Excel"]
[]
[null,"Name of Sites","Category of the Sites","Date","Platforms","Number of Visits","New Subscribers"]
[null,"Site 1","Education","2021-06-01","Web",5089,102]
[null,"Site 2","Sport","2021-06-02","Mobile",6158,150]
[null,"Site 3","Tourism","2021-06-03","Web",7227,198]
[null,"Site 4","Sport","2021-06-04","Mobile",8296,246]
[null,"Site 5","Education","2021-06-07","Web",9365,294]
[null,"Site 6","Sport","2021-06-08","Mobile",10434,342]
[null,"Site 7","Education","2021-06-09","Web",11503,390]
[null,"Site 8","Education","2021-06-10","Mobile",12572,438]
[null,"Site 9","Tourism","2021-06-11","Web",13641,486]
[null,"Site 10","Sport","2021-06-14","Mobile",14710,534]
[null,"Site 11","Tourism","2021-06-15","Web",15779,582]
[null,"Site 12","Education","2021-06-16","Web",16848,630]
[null,"Site 13","Education","2021-06-17","Mobile",17917,678]
[null,"Site 14","Tourism","2021-06-18","Web",18986,726]
[null,"Site 15","Sport","2021-06-19","Mobile",20055,774]
[]
[null,"Criteria"]
[null,"Number of Visits: between 5000 and 10000"]
[null,"New Subscribers: Greater than 200"]

{"sheet":"VBA_OR","index":5,"n_rows":23,"n_cols":7,"rows_kept":23,"cut":false,"hidden":false,"merged":[[1,1,1,6],[20,1,20,4],[21,1,21,4],[22,1,22,4]]}
[]
[null,"Multiple Filter Using VBA Code (OR Logic)"]
[]
[null,"Name of Sites","Category of the Sites","Date","Platforms","Number of Visits","New Subscribers"]
[null,"Site 1","Education","2021-06-01","Web",5089,102]
[null,"Site 2","Sport","2021-06-02","Mobile",6158,150]
[null,"Site 3","Tourism","2021-06-03","Web",7227,198]
[null,"Site 4","Sport","2021-06-04","Mobile",8296,246]
[null,"Site 5","Education","2021-06-07","Web",9365,294]
[null,"Site 6","Sport","2021-06-08","Mobile",10434,342]
[null,"Site 7","Education","2021-06-09","Web",11503,390]
[null,"Site 8","Education","2021-06-10","Mobile",12572,438]
[null,"Site 9","Tourism","2021-06-11","Web",13641,486]
[null,"Site 10","Sport","2021-06-14","Mobile",14710,534]
[null,"Site 11","Tourism","2021-06-15","Web",15779,582]
[null,"Site 12","Education","2021-06-16","Web",16848,630]
[null,"Site 13","Education","2021-06-17","Mobile",17917,678]
[null,"Site 14","Tourism","2021-06-18","Web",18986,726]
[null,"Site 15","Sport","2021-06-19","Mobile",20055,774]
[]
[null,"Criteria"]
[null,"Number of Visits: <10000 OR >15000"]
[null,"Sites: Education"]

{"sheet":"VBA AND","index":6,"n_rows":23,"n_cols":7,"rows_kept":23,"cut":false,"hidden":false,"merged":[[1,1,1,6],[20,1,20,4],[21,1,21,4],[22,1,22,4]]}
[]
[null,"Multiple Filter Using VBA Code (AND Logic)"]
[]
[null,"Name of Sites","Category of the Sites","Date","Platforms","Number of Visits","New Subscribers"]
[null,"Site 1","Education","2021-06-01","Web",5089,102]
[null,"Site 2","Sport","2021-06-02","Mobile",6158,150]
[null,"Site 3","Tourism","2021-06-03","Web",7227,198]
[null,"Site 4","Sport","2021-06-04","Mobile",8296,246]
[null,"Site 5","Education","2021-06-07","Web",9365,294]
[null,"Site 6","Sport","2021-06-08","Mobile",10434,342]
[null,"Site 7","Education","2021-06-09","Web",11503,390]
[null,"Site 8","Education","2021-06-10","Mobile",12572,438]
[null,"Site 9","Tourism","2021-06-11","Web",13641,486]
[null,"Site 10","Sport","2021-06-14","Mobile",14710,534]
[null,"Site 11","Tourism","2021-06-15","Web",15779,582]
[null,"Site 12","Education","2021-06-16","Web",16848,630]
[null,"Site 13","Education","2021-06-17","Mobile",17917,678]
[null,"Site 14","Tourism","2021-06-18","Web",18986,726]
[null,"Site 15","Sport","2021-06-19","Mobile",20055,774]
[]
[null,"Criteria"]
[null,"Number of Visits: >=5000 AND <=15000"]
[null,"Sites: Education"]

{"sheet":"FILTER Function","index":7,"n_rows":19,"n_cols":12,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Multiple Filters Using FILTER Function"]
[]
[null,"Name of Sites","Category of the Sites","Date","Platforms","Number of Visits"]
[null,"Site 1","Education","2021-05-01","Web",5089,null,{"$f":"_xlfn._xlws.FILTER(B5:F19,MONTH(D5:D19) > 5,\"No data\")","v":"Site 2"},"Sport",44349,"Mobile",6158]
[null,"Site 2","Sport","2021-06-02","Mobile",6158,null,"Site 3","Tourism",44350,"Web",7227]
[null,"Site 3","Tourism","2021-06-03","Web",7227,null,"Site 5","Education",44354,"Web",9365]
[null,"Site 4","Sport","2021-05-04","Mobile",8296,null,"Site 7","Education",44356,"Web",11503]
[null,"Site 5","Education","2021-06-07","Web",9365,null,"Site 8","Education",44357,"Mobile",12572]
[null,"Site 6","Sport","2021-05-08","Mobile",10434,null,"Site 10","Sport",44361,"Mobile",14710]
[null,"Site 7","Education","2021-06-09","Web",11503,null,"Site 11","Tourism",44362,"Web",15779]
[null,"Site 8","Education","2021-06-10","Mobile",12572,null,"Site 12","Education",44356,"Web",16848]
[null,"Site 9","Tourism","2021-05-11","Web",13641,null,"Site 13","Education",44357,"Mobile",17917]
[null,"Site 10","Sport","2021-06-14","Mobile",14710,null,"Site 15","Sport",44361,"Mobile",20055]
[null,"Site 11","Tourism","2021-06-15","Web",15779]
[null,"Site 12","Education","2021-06-09","Web",16848]
[null,"Site 13","Education","2021-06-10","Mobile",17917]
[null,"Site 14","Tourism","2021-05-11","Web",18986]
[null,"Site 15","Sport","2021-06-14","Mobile",20055]

{"sheet":"FILTER Function1","index":8,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"After Filtering (Using FILTER Function)"]
[]
[null,"Name of Sites","Category of the Sites","Date","Platforms","Number of Visits"]
[null,"Site 2","Sport","2021-06-02","Mobile",6158]
[null,"Site 3","Tourism","2021-06-03","Web",7227]
[null,"Site 5","Education","2021-06-07","Web",9365]
[null,"Site 7","Education","2021-06-09","Web",11503]
[null,"Site 8","Education","2021-06-10","Mobile",12572]
[null,"Site 10","Sport","2021-06-14","Mobile",14710]
[null,"Site 11","Tourism","2021-06-15","Web",15779]
[null,"Site 12","Education","2021-06-09","Web",16848]
[null,"Site 13","Education","2021-06-10","Mobile",17917]
[null,"Site 15","Sport","2021-06-14","Mobile",20055]