{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Dataset","Del_Row_If","Del_Row_And","Del_Row_OR","Del_Row_Exact","Del_Row_VBA","Do_It_Yourself"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":5,"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":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"How to Delete Multiple Rows Using Formula"]
[]
[null,"Car Name","Company \nName","Price","Max. Speed\n(Mph)"]
[null,"Sedan","Ford",225000,215]
[null,"Carrera GT","Porsche",250000,230]
[null,"Aventador","Lamborgini",300000,220]
[null,"McLaren F1","McLaren Cars",250000,240]
[null,"Bugatti Veyron","Bugatti",275000,230]
[null,"Taycan","Porsche",250000,225]
[null,"Cayman GT4","Porsche",220000,225]
[null,"Spyder","Porsche",250000,220]
[null,"Fiesta","Ford",275000,230]
[null,"Roadster","Tesla",280000,250]

{"sheet":"Del_Row_If","index":1,"n_rows":9,"n_cols":6,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Using IF Function to Delete Multiple Rows "]
[]
[null,"Car Name","Company \nName","Price","Max. Speed\n(Mph)","Car\n Selection"]
[null,"Carrera GT","Porsche",250000,230,{"$f":"IF(E5>=230,\"Yes\",\"No\")","v":"Yes"}]
[null,"McLaren F1","McLaren Cars",250000,240,"Yes"]
[null,"Bugatti Veyron","Bugatti",275000,230,"Yes"]
[null,"Fiesta","Ford",275000,230,"Yes"]
[null,"Roadster","Tesla",280000,250,"Yes"]

{"sheet":"Del_Row_And","index":2,"n_rows":8,"n_cols":6,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Using AND Function to Delete Multiple Rows"]
[]
[null,"Car Name","Company \nName","Price","Max. Speed\n(Mph)","Car\n Selection"]
[null,"Carrera GT","Porsche",250000,230,{"$f":"AND(D5<=250000,E5>220)","v":true}]
[null,"McLaren F1","McLaren Cars",250000,240,true]
[null,"Taycan","Porsche",250000,225,true]
[null,"Cayman GT4","Porsche",220000,225,true]

{"sheet":"Del_Row_OR","index":3,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Using OR Function to Delete Multiple Rows"]
[]
[null,"Car Name","Company\n Name","Price","Max. Speed\n(Mph)","Car \nSelection"]
[null,"Sedan","Ford",225000,215,{"$f":"OR(D5<=230000,E5>220)","v":true}]
[null,"Carrera GT","Porsche",250000,230,{"$f":"OR(D6<=230000,E6>220)","v":true}]
[null,"McLaren F1","McLaren Cars",250000,240,true]
[null,"Bugatti Veyron","Bugatti",275000,230,true]
[null,"Taycan","Porsche",250000,225,true]
[null,"Cayman GT4","Porsche",220000,225,true]
[null,"Fiesta","Ford",275000,230,true]
[null,"Roadster","Tesla",280000,250,true]

{"sheet":"Del_Row_Exact","index":4,"n_rows":8,"n_cols":6,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Using EXACT Function To Delete Multiple Rows"]
[]
[null,"Car Name","Company \nName","Price","Max. Speed\n(Mph)","Car Selection"]
[null,"Carrera GT","Porsche",250000,230,{"$f":"EXACT(\"Porsche\",C5)","v":true}]
[null,"Taycan","Porsche",250000,225,true]
[null,"Cayman GT4","Porsche",220000,225,true]
[null,"Spyder","Porsche",250000,220,true]

{"sheet":"Del_Row_VBA","index":5,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Using VBA to Delete Multiple Rows"]
[]
[null,"Car Name","Company \nName","Price","Max. Speed\n(Mph)"]
[null,"Sedan","Ford",225000,215]
[null,"Carrera GT","Porsche",250000,230]
[null,"McLaren F1","McLaren Cars",250000,240]
[null,"Taycan","Porsche",250000,225]
[null,"Cayman GT4","Porsche",220000,225]
[null,"Spyder","Porsche",250000,220]

{"sheet":"Do_It_Yourself","index":6,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Do It Yourself"]
[]
[null,"Car Name","Company \nName","Price","Max. Speed\n(Mph)"]
[null,"Sedan","Ford",225000,215]
[null,"Carrera GT","Porsche",250000,230]
[null,"Aventador","Lamborgini",300000,220]
[null,"McLaren F1","McLaren Cars",250000,240]
[null,"Bugatti Veyron","Bugatti",275000,230]
[null,"Taycan","Porsche",250000,225]
[null,"Cayman GT4","Porsche",220000,225]
[null,"Spyder","Porsche",250000,220]
[null,"Fiesta","Ford",275000,230]
[null,"Roadster","Tesla",280000,250]