{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Home Page","VBA-Filter for Top N Values","Filter with Drop-Down List"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":3,"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":"Home Page","index":0,"n_rows":19,"n_cols":3,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,"How to Filter Data Based on Cell Value in Excel"]
[]
[null,"Learn the methods to filter data based on cell value in Excel. Read the article we provided and practice these in practice section."]
[]
[null,"Prepared By","Md. Sourov Hossain Mithun"]
[null,"Reviewed By","A.N.M. Mohaimen Shanto"]
[null,"Last Update","2023-10-23"]
[null,"Article Link","How to Filter Data Based on Cell Value in Excel"]
[]
[null,"Method"]
[null,"4. VBA Code to Filter Data Based on Cell Value"]
[null,null,"Case 1. Filter for Top N Values"]
[null,null,"Case 2. Filter with Drop-Down List"]
[]
[null,"Copyright © 2013-2023 ExcelDemy.com | All rights reserved."]

{"sheet":"VBA-Filter for Top N Values","index":1,"n_rows":35,"n_cols":28,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
[null,"How to Filter Data Based on Cell Value in Excel"]
[]
[null,"Applying VBA to Filter Based on Cell Value: Filter for Top N Values"]
[]
[null,"Brand","Device","Model","Origin","Release Date","Price"]
[null,"Gamind","Notebook","GNN-876","USA","2021-02-17",620,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"List 1","List 2",null,"Count"]
[null,"Gamind","Desktop","GND-967","USA","2021-04-12",800,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Philip","Mike"]
[null,"Omicron","Notebook","OCN-114","USA","2021-05-19",860,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Max","Max"]
[null,"Gamind","Desktop","GND-995","USA","2021-01-19",870,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Josh","Malcom"]
[null,"Omicron","Desktop","OCD-052","USA","2021-05-25",880,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Andrew","Sam"]
[null,"Omicron","Desktop","OCD-065","USA","2021-02-15",920,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Malcom","Austin"]
[null,"Omicron","Desktop","OCD-041","USA","2021-03-24",980]
[null,"Omicron","Notebook","OCN-116","USA","2021-02-04",1000]
[null,"Codemy","Desktop","CMD-360","Taiwan","2021-06-16",490,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cooper","Cooper"]
[null,"Codemy","Notebook","CMN-550","Taiwan","2021-07-07",650,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ricky","Lily"]
[null,"Codemy","Notebook","CMN-860","Taiwan","2021-01-01",1200]
[]
[]
[]
[null,"Back to Home Page"]
[]
[null,"Practice Yourself"]
[]
[null,"Brand","Device","Model","Origin","Release Date","Price"]
[null,"Gamind","Notebook","GNN876","USA","2021-02-17",620]
[null,"Gamind","Desktop","GND967","USA","2021-04-12",800]
[null,"Omicron","Notebook","OCN114","USA","2021-05-19",860]
[null,"Gamind","Desktop","GND995","USA","2021-01-19",870]
[null,"Omicron","Desktop","OCD052","USA","2021-05-25",880]
[null,"Omicron","Desktop","OCD065","USA","2021-02-15",920]
[null,"Omicron","Desktop","OCD041","USA","2021-03-24",980]
[null,"Omicron","Notebook","OCN116","USA","2021-02-04",1000]
[null,"Codemy","Desktop","CMD360","Taiwan","2021-06-16",490]
[null,"Codemy","Notebook","CMN550","Taiwan","2021-07-07",650]
[null,"Codemy","Notebook","CMN860","Taiwan","2021-01-01",1200]

{"sheet":"Filter with Drop-Down List","index":2,"n_rows":40,"n_cols":7,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
[null,"How to Filter Data Based on Cell Value in Excel"]
[]
[null,"Applying VBA to Filter Based on Cell Value: Filter with Drop-Down List"]
[]
[null,"Brand","Device","Model","Origin","Release Date","Price"]
[null,"Gamind","Notebook","GNN-876","USA","2021-02-17",620]
[null,"Gamind","Desktop","GND-967","USA","2021-04-12",800]
[null,"Omicron","Notebook","OCN-114","USA","2021-05-19",860]
[null,"Gamind","Desktop","GND-995","USA","2021-01-19",870]
[null,"Omicron","Desktop","OCD-052","USA","2021-05-25",880]
[null,"Omicron","Desktop","OCD-065","USA","2021-02-15",920]
[null,"Omicron","Desktop","OCD-041","USA","2021-03-24",980]
[null,"Omicron","Notebook","OCN-116","USA","2021-02-04",1000]
[null,"Codemy","Desktop","CMD-360","Taiwan","2021-06-16",490]
[null,"Codemy","Notebook","CMN-550","Taiwan","2021-07-07",650]
[null,"Codemy","Notebook","CMN-860","Taiwan","2021-01-01",1200]
[]
[null,"Device"]
[null,"Desktop"]
[]
[]
[]
[null,"Back to Home Page"]
[]
[null,"Practice Yourself"]
[]
[null,"Brand","Device","Model","Origin","Release Date","Price"]
[null,"Gamind","Notebook","GNN876","USA","2021-02-17",620]
[null,"Gamind","Desktop","GND967","USA","2021-04-12",800]
[null,"Omicron","Notebook","OCN114","USA","2021-05-19",860]
[null,"Gamind","Desktop","GND995","USA","2021-01-19",870]
[null,"Omicron","Desktop","OCD052","USA","2021-05-25",880]
[null,"Omicron","Desktop","OCD065","USA","2021-02-15",920]
[null,"Omicron","Desktop","OCD041","USA","2021-03-24",980]
[null,"Omicron","Notebook","OCN116","USA","2021-02-04",1000]
[null,"Codemy","Desktop","CMD360","Taiwan","2021-06-16",490]
[null,"Codemy","Notebook","CMN550","Taiwan","2021-07-07",650]
[null,"Codemy","Notebook","CMN860","Taiwan","2021-01-01",1200]
[]
[null,"Device"]