{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Dataset","Simple Way","Auto Filter","Advanced Filter","VBA_OR","VBA AND","FILTER Function","Table","Custom Filter"],"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,"Site Name","Category","Date","Platforms","Visits Number","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":47,"n_cols":7,"rows_kept":47,"cut":false,"hidden":false,"merged":[[1,1,1,5],[20,1,20,2],[25,1,25,6],[44,1,44,2]]}
[]
[null,"Applying Filter Feature"]
[]
[null,"Site Name","Category","Date","Platforms","Visits Number"]
[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]
[]
[null,"Criteria"]
[null,"Category","Education"]
[null,"Platforms","Mobile"]
[]
[]
[null,"Do It Yourself"]
[]
[null,"Site Name","Category","Date","Platforms","Visits Number","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,"Category","Education"]
[null,"Platforms","Mobile"]

{"sheet":"Auto Filter","index":2,"n_rows":47,"n_cols":7,"rows_kept":47,"cut":false,"hidden":false,"merged":[[1,1,1,6],[20,1,20,2],[25,1,25,6],[44,1,44,2]]}
[]
[null,"Employing AutoFilter Option"]
[]
[null,"Site Name","Category","Date","Platforms","Visits Number","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,"Visits Number","Between 5000 and 10000"]
[null,"New Subscribers"," Greater than 200"]
[]
[]
[null,"Do It Yourself"]
[]
[null,"Site Name","Category","Date","Platforms","Visits Number","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,"Visits Number","Between 5000 and 10000"]
[null,"New Subscribers"," Greater than 200"]

{"sheet":"Advanced Filter","index":3,"n_rows":47,"n_cols":6,"rows_kept":47,"cut":false,"hidden":false,"merged":[[1,1,1,5],[20,1,20,3],[25,1,25,5],[44,1,44,3]]}
[]
[null,"Applying Advanced Filter Option"]
[]
[null,"Site Name","Category","Platforms","Visits Number","New Subscribers"]
[null,"Site 1","Education","Web",5089,102]
[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]
[]
[null,"Criteria"]
[null,"Category","Visits Number","New Subscribers"]
[null,"Education",">10000",">400"]
[]
[]
[null,"Do It Yourself"]
[]
[null,"Site Name","Category","Platforms","Visits Number","New Subscribers"]
[null,"Site 1","Education","Web",5089,102]
[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]
[]
[null,"Criteria"]
[null,"Category","Visits Number","New Subscribers"]
[null,"Education",">10000",">400"]

{"sheet":"VBA_OR","index":4,"n_rows":23,"n_cols":7,"rows_kept":23,"cut":false,"hidden":false,"merged":[[1,1,1,6],[20,1,20,2]]}
[]
[null,"Use of VBA Code (OR Logic)"]
[]
[null,"Site Name","Category","Date","Platforms","Visits Number","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,"Visits Number","<10000 OR >15000"]
[null,"Sites"," Education"]

{"sheet":"VBA AND","index":5,"n_rows":23,"n_cols":7,"rows_kept":23,"cut":false,"hidden":false,"merged":[[1,1,1,6],[20,1,20,2]]}
[]
[null,"Using VBA Code (AND Logic)"]
[]
[null,"Site Name","Category","Date","Platforms","Visits Number","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,"Visits Number"," >=5000 AND <=15000"]
[null,"Sites","Education"]

{"sheet":"FILTER Function","index":6,"n_rows":19,"n_cols":12,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,7,1,11]]}
[]
[null,"Using FILTER Function",null,null,null,null,null,"After Filtering (Using FILTER Function)"]
[]
[null,"Site Name","Category","Date","Platforms","Visits Number",null,"Site Name","Category","Date","Platforms","Visits Number"]
[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","2021-06-02","Mobile",6158]
[null,"Site 2","Sport","2021-06-02","Mobile",6158,null,"Site 3","Tourism","2021-06-03","Web",7227]
[null,"Site 3","Tourism","2021-06-03","Web",7227,null,"Site 5","Education","2021-06-07","Web",9365]
[null,"Site 4","Sport","2021-05-04","Mobile",8296,null,"Site 7","Education","2021-06-09","Web",11503]
[null,"Site 5","Education","2021-06-07","Web",9365,null,"Site 8","Education","2021-06-10","Mobile",12572]
[null,"Site 6","Sport","2021-05-08","Mobile",10434,null,"Site 10","Sport","2021-06-14","Mobile",14710]
[null,"Site 7","Education","2021-06-09","Web",11503,null,"Site 11","Tourism","2021-06-15","Web",15779]
[null,"Site 8","Education","2021-06-10","Mobile",12572,null,"Site 12","Education","2021-06-09","Web",16848]
[null,"Site 9","Tourism","2021-05-11","Web",13641,null,"Site 13","Education","2021-06-10","Mobile",17917]
[null,"Site 10","Sport","2021-06-14","Mobile",14710,null,"Site 15","Sport","2021-06-14","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":"Table","index":7,"n_rows":47,"n_cols":7,"rows_kept":47,"cut":false,"hidden":false,"merged":[[1,1,1,6],[20,1,20,2],[25,1,25,6],[44,1,44,2]]}
[]
[null,"Use of Excel Table"]
[]
[null,"Site Name","Category","Date","Platforms","Visits Number","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,"Category","Education"]
[null,"Platforms","Mobile"]
[]
[]
[null,"Do It Yourself"]
[]
[null,"Site Name","Category","Date","Platforms","Visits Number","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,"Category","Education"]
[null,"Platforms","Mobile"]

{"sheet":"Custom Filter","index":8,"n_rows":47,"n_cols":5,"rows_kept":47,"cut":false,"hidden":false,"merged":[[1,1,1,4],[20,1,20,2],[25,1,25,4],[44,1,44,2]]}
[]
[null,"Use of Custom Filter Feature"]
[]
[null,"Site Name","Category","Visits Number","Platforms"]
[null,"Site 1","Education, Sport, Tourism",5089,"Web"]
[null,"Site 2","Sport, Tourism",6158,"Mobile"]
[null,"Site 3","Tourism, Corporate",7227,"Web"]
[null,"Site 4","Sport, Media",8296,"Mobile"]
[null,"Site 5","Education, Sport",9365,"Mobile"]
[null,"Site 6","Sport, Tourism",10434,"Mobile"]
[null,"Site 7","Business, Corporate",11503,"Web"]
[null,"Site 8","Media, Corporate",12572,"Mobile"]
[null,"Site 9","Sport, Tourism",13641,"Web"]
[null,"Site 10","E-Commerce, Business",14710,"Mobile"]
[null,"Site 11","Sport, Media",15779,"Web"]
[null,"Site 12","Education, Non-Profit",16848,"Web"]
[null,"Site 13","E-Commerce, Business",17917,"Mobile"]
[null,"Site 14","E-Commerce, Business",18986,"Web"]
[null,"Site 15","Sport, Media",20055,"Mobile"]
[]
[null,"Criteria"]
[null,"Category","Education"]
[null,"Platforms","Mobile"]
[]
[]
[null,"Do It Yourself"]
[]
[null,"Site Name","Category","Visits Number","Platforms"]
[null,"Site 1","Education, Sport, Tourism",5089,"Web"]
[null,"Site 2","Sport, Tourism",6158,"Mobile"]
[null,"Site 3","Tourism, Corporate",7227,"Web"]
[null,"Site 4","Sport, Media",8296,"Mobile"]
[null,"Site 5","Education, Sport",9365,"Mobile"]
[null,"Site 6","Sport, Tourism",10434,"Mobile"]
[null,"Site 7","Business, Corporate",11503,"Web"]
[null,"Site 8","Media, Corporate",12572,"Mobile"]
[null,"Site 9","Sport, Tourism",13641,"Web"]
[null,"Site 10","E-Commerce, Business",14710,"Mobile"]
[null,"Site 11","Sport, Media",15779,"Web"]
[null,"Site 12","Education, Non-Profit",16848,"Web"]
[null,"Site 13","E-Commerce, Business",17917,"Mobile"]
[null,"Site 14","E-Commerce, Business",18986,"Web"]
[null,"Site 15","Sport, Media",20055,"Mobile"]
[]
[null,"Criteria"]
[null,"Category","Education"]
[null,"Platforms","Mobile"]