{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Dataset","How to use Select Case & Like","For String Value","Condition with Range","Multiple Condition And & OR","Nested Case Statements ","Using Select Case with Number","Select Case for ActiveCell","Select Case with Date","If Vs Select Case Statement","VBA Select Case String Contains"],"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":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Sales Report of ACI Electronics For January"]
[]
[null,"Date","Product Name","Price","Quantity"]
[null,"2022-01-01","Dish Washer",10,100]
[null,"2022-01-03","Heater",15,50]
[null,"2022-01-04","Dish Washer",10,75]
[null,"2022-01-12","Trimmer",20,25]
[null,"2022-01-02","Fan",25,30]
[null,"2022-01-12","Dish Washer",10,150]
[null,"2022-01-01","Heater",15,100]
[null,"2022-01-04","Trimmer",20,50]
[null,"2022-01-03","Fan",25,75]
[null,"2022-01-23","Dish Washer",10,120]
[null,"2022-01-07","Heater",15,25]
[null,"2022-01-12","Trimmer",20,75]

{"sheet":"How to use Select Case & Like","index":1,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"How to use Select Case & Like?"]

{"sheet":"For String Value","index":2,"n_rows":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Checking Text String with Select Case"]
[]
[null,"Date","Product","Price","Quantity"]
[null,"2022-01-01","Dish Washer",10,100]
[null,"2022-01-03","Heater",15,50]
[null,"2022-01-04","Dish Washer",10,75]
[null,"2022-01-12","Trimmer",20,25]
[null,"2022-01-02","Fan",25,30]
[null,"2022-01-12","Dish Washer",10,150]
[null,"2022-01-01","Heater",15,100]
[null,"2022-01-04","Trimmer",20,50]
[null,"2022-01-03","Fan",25,75]
[null,"2022-01-23","Dish Washer",10,120]
[null,"2022-01-07","Heater",15,25]
[null,"2022-01-12","Trimmer",20,75]

{"sheet":"Condition with Range","index":3,"n_rows":16,"n_cols":3,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Select Case Like Operator with a Range of Letter"]
[]
[null,"Product Name","Remark"]
[null,"Dish Washer","Product Name Starts with the Latter between A and E"]
[null,"Heater","Product Name Starts with the Latter between F and R"]
[null,"Dish Washer","Product Name Starts with the Latter between A and E"]
[null,"Trimmer","The string does not match any of the patterns."]
[null,"Fan","Product Name Starts with the Latter between F and R"]
[null,"Dish Washer","Product Name Starts with the Latter between A and E"]
[null,"Heater","Product Name Starts with the Latter between F and R"]
[null,"Trimmer","The string does not match any of the patterns."]
[null,"Fan","Product Name Starts with the Latter between F and R"]
[null,"Dish Washer","Product Name Starts with the Latter between A and E"]
[null,"Heater","Product Name Starts with the Latter between F and R"]
[null,"Trimmer","The string does not match any of the patterns."]

{"sheet":"Multiple Condition And & OR","index":4,"n_rows":16,"n_cols":6,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Select Case Like with Multiple Condition "]
[]
[null,"Date","Product Name","Price","Quantity","Revenue"]
[null,"2022-01-01","Dish Washer",10,100,1000]
[null,"2022-01-03","Heater",15,50]
[null,"2022-01-04","Dish Washer",10,75]
[null,"2022-01-12","Trimmer",20,25]
[null,"2022-01-02","Fan",25,30]
[null,"2022-01-12","Dish Washer",10,150,1500]
[null,"2022-01-01","Heater",15,100]
[null,"2022-01-04","Trimmer",20,50]
[null,"2022-01-03","Fan",25,75]
[null,"2022-01-23","Dish Washer",10,120,1200]
[null,"2022-01-07","Heater",15,25]
[null,"2022-01-12","Trimmer",20,75]

{"sheet":"Nested Case Statements ","index":5,"n_rows":16,"n_cols":6,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Nested Select Case With Like Operator"]
[]
[null,"Date","Product Name","Price","Quantity","Revenue"]
[null,"2022-01-01","Dish Washer",10,100,1000]
[null,"2022-01-03","Heater",15,50]
[null,"2022-01-04","Dish Washer",10,75]
[null,"2022-01-12","Trimmer",20,25]
[null,"2022-01-02","Fan",25,30]
[null,"2022-01-12","Dish Washer",10,150,1500]
[null,"2022-01-01","Heater",15,100,1500]
[null,"2022-01-04","Trimmer",20,50]
[null,"2022-01-03","Fan",25,75]
[null,"2022-01-23","Dish Washer",10,120,1200]
[null,"2022-01-07","Heater",15,25]
[null,"2022-01-12","Trimmer",20,75]

{"sheet":"Using Select Case with Number","index":6,"n_rows":16,"n_cols":6,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Using Select Case with Like Operator for Number"]
[]
[null,"Date","Product Name","Price","Quantity","Revenue"]
[null,"2022-01-01","Dish Washer",10,100]
[null,"2022-01-03","Heater",15,50,750]
[null,"2022-01-04","Dish Washer",10,75,750]
[null,"2022-01-12","Trimmer",20,25]
[null,"2022-01-02","Fan",25,30]
[null,"2022-01-12","Dish Washer",10,150]
[null,"2022-01-01","Heater",15,100]
[null,"2022-01-04","Trimmer",20,50,1000]
[null,"2022-01-03","Fan",25,75,1875]
[null,"2022-01-23","Dish Washer",10,120]
[null,"2022-01-07","Heater",15,25]
[null,"2022-01-12","Trimmer",20,75,1500]

{"sheet":"Select Case for ActiveCell","index":7,"n_rows":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Select Case for ActiveCell "]
[]
[null,"Date","Product Name","Price","Quantity"]
[null,"2022-01-01","Dish Washer",10,100]
[null,"2022-01-03","Heater",15,50]
[null,"2022-01-04","Dish Washer",10,75]
[null,"2022-01-12","Trimmer",20,25]
[null,"2022-01-02","Fan",25,30]
[null,"2022-01-12","Dish Washer",10,150]
[null,"2022-01-01","Heater",15,100]
[null,"2022-01-04","Trimmer",20,50]
[null,"2022-01-03","Fan",25,75]
[null,"2022-01-23","Dish Washer",10,120]
[null,"2022-01-07","Heater",15,25]
[null,"2022-01-12","Trimmer",20,75]

{"sheet":"Select Case with Date","index":8,"n_rows":24,"n_cols":5,"rows_kept":24,"cut":false,"hidden":false,"merged":[[1,1,1,4],[17,2,17,3]]}
[]
[null,"Select Case with Like Operator for Date"]
[]
[null,"Date","Product Name","Price","Quantity"]
[null,"2022-02-01","Dish Washer",10,100]
[null,"2022-01-03","Heater",15,50]
[null,"2022-01-04","Dish Washer",10,75]
[null,"2022-02-12","Trimmer",20,25]
[null,"2022-01-02","Fan",25,30]
[null,"2022-02-12","Dish Washer",10,150]
[null,"2022-01-01","Heater",15,100]
[null,"2022-03-04","Trimmer",20,50]
[null,"2022-01-03","Fan",25,75]
[null,"2022-01-23","Dish Washer",10,120]
[null,"2022-01-07","Heater",15,25]
[null,"2022-04-12","Trimmer",20,75]
[]
[null,null,"Total Sell by Each Month"]
[]
[null,null,"Month","Revenue"]
[null,null,"January",7200]
[null,null,"February",3000]
[null,null,"March",1000]
[null,null,"April",1500]

{"sheet":"If Vs Select Case Statement","index":9,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"If Vs Select Case Statement"]

{"sheet":"VBA Select Case String Contains","index":10,"n_rows":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"VBA Select Case with String Contains"]
[]
[null,null,"Product Name","Price","Quantity"]
[null,"2022-01-01","Dish Washer",10,100]
[null,"2022-01-03","Heater",15,50]
[null,"2022-01-04","Dish Washer",10,75]
[null,"2022-01-12","Trimmer",20,25]
[null,"2022-01-02","Fan",25,30]
[null,"2022-01-12","Dish Washer",10,150]
[null,"2022-01-01","Heater",15,100]
[null,"2022-01-04","Trimmer",20,50]
[null,"2022-01-03","Fan",25,75]
[null,"2022-01-23","Dish Washer",10,120]
[null,"2022-01-07","Heater",15,25]
[null,"2022-01-12","Trimmer",20,75]