{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Dataset","Filter","VBA","Real Time Hiding","Formula","Conditional Formatting"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":6,"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":18,"n_cols":5,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Dataset for Excel Hide Rows Based on Cell Value"]
[]
[null,"Order Date","Region","Product","Quantity"]
[null,"2022-02-05","East","Bran",83]
[null,"2022-02-06","East","Oatmeal Raisin",124]
[null,"2022-02-07","West","Carrot",137]
[null,"2022-02-08","East","Arrowroot",146]
[null,"2022-02-09","East","Chocolate Chip",34]
[null,"2022-02-10","West","Carrot",20]
[null,"2022-02-11","East","Arrowroot",139]
[null,"2022-02-12","East","Chocolate Chip",211]
[null,"2022-02-13","East","Whole Wheat",20]
[null,"2022-02-14","West","Bran",42]
[null,"2022-02-15","West","Oatmeal Raisin",100]
[null,"2022-02-16","East","Carrot",38]
[null,"2022-02-17","East","Whole Wheat",25]
[null,"2022-02-18","West","Chocolate Chip",96]

{"sheet":"Filter","index":1,"n_rows":18,"n_cols":5,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Using Filter Feature"]
[]
[null,"Order Date","Region","Product","Quantity"]
[null,"2022-02-05","East","Bran",83]
[null,"2022-02-06","East","Oatmeal Raisin",124]
[null,"2022-02-07","West","Carrot",137]
[null,"2022-02-08","East","Arrowroot",146]
[null,"2022-02-09","East","Chocolate Chip",34]
[null,"2022-02-10","West","Carrot",20]
[null,"2022-02-11","East","Arrowroot",139]
[null,"2022-02-12","East","Chocolate Chip",211]
[null,"2022-02-13","East","Whole Wheat",20]
[null,"2022-02-14","West","Bran",42]
[null,"2022-02-15","West","Oatmeal Raisin",100]
[null,"2022-02-16","East","Carrot",38]
[null,"2022-02-17","East","Whole Wheat",25]
[null,"2022-02-18","West","Chocolate Chip",96]

{"sheet":"VBA","index":2,"n_rows":15,"n_cols":4,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["Order Date","Region","Product","Quantity"]
["2022-02-05","East","Bran",83]
["2022-02-06","East","Oatmeal Raisin",124]
["2022-02-07","West","Carrot",137]
["2022-02-08","East","Arrowroot",146]
["2022-02-09","East","Chocolate Chip",34]
["2022-02-10","West","Carrot",20]
["2022-02-11","East","Arrowroot",139]
["2022-02-12","East","Chocolate Chip",211]
["2022-02-13","East","Whole Wheat",20]
["2022-02-14","West","Bran",42]
["2022-02-15","West","Oatmeal Raisin",100]
["2022-02-16","East","Carrot",38]
["2022-02-17","East","Whole Wheat",25]
["2022-02-18","West","Chocolate Chip",96]

{"sheet":"Real Time Hiding","index":3,"n_rows":18,"n_cols":4,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["Order Date","Region","Product","Quantity"]
["2022-02-05","East","Bran",83]
["2022-02-06","East","Oatmeal Raisin",124]
["2022-02-07","West","Carrot",137]
["2022-02-08","East","Arrowroot",146]
["2022-02-09","East","Chocolate Chip",34]
["2022-02-10","West","Carrot",20]
["2022-02-11","East","Arrowroot",139]
["2022-02-12","East","Chocolate Chip",211]
["2022-02-13","East","Whole Wheat",20]
["2022-02-14","West","Bran",42]
["2022-02-15","West","Oatmeal Raisin",100]
["2022-02-16","East","Carrot",38]
["2022-02-17","East","Whole Wheat",25]
["2022-02-18","West","Chocolate Chip",96]
[]
["Criteria to Hide Rows"]
["West"]

{"sheet":"Formula","index":4,"n_rows":18,"n_cols":6,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Using Formula to Filter"]
[]
[null,"Order Date","Region","Product","Quantity","Formula to Filter"]
[null,"2022-02-05","East","Bran",83,{"$f":"IF(E5<50,\"Hide\",E5)","v":83}]
[null,"2022-02-06","East","Oatmeal Raisin",124,{"$f":"IF(E6<50,\"Hide\",E6)","v":124}]
[null,"2022-02-07","West","Carrot",137,137]
[null,"2022-02-08","East","Arrowroot",146,146]
[null,"2022-02-09","East","Chocolate Chip",34,"Hide"]
[null,"2022-02-10","West","Carrot",20,"Hide"]
[null,"2022-02-11","East","Arrowroot",139,139]
[null,"2022-02-12","East","Chocolate Chip",211,211]
[null,"2022-02-13","East","Whole Wheat",20,"Hide"]
[null,"2022-02-14","West","Bran",42,"Hide"]
[null,"2022-02-15","West","Oatmeal Raisin",100,100]
[null,"2022-02-16","East","Carrot",38,"Hide"]
[null,"2022-02-17","East","Whole Wheat",25,"Hide"]
[null,"2022-02-18","West","Chocolate Chip",96,96]

{"sheet":"Conditional Formatting","index":5,"n_rows":18,"n_cols":5,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Using Conditional Formatting"]
[]
[null,"Order Date","Region","Product","Quantity"]
[null,"2022-02-05","East","Bran",83]
[null,"2022-02-06","East","Oatmeal Raisin",124]
[null,"2022-02-07","West","Carrot",137]
[null,"2022-02-08","East","Arrowroot",146]
[null,"2022-02-09","East","Chocolate Chip",34]
[null,"2022-02-10","West","Carrot",20]
[null,"2022-02-11","East","Arrowroot",139]
[null,"2022-02-12","East","Chocolate Chip",211]
[null,"2022-02-13","East","Whole Wheat",20]
[null,"2022-02-14","West","Bran",42]
[null,"2022-02-15","West","Oatmeal Raisin",100]
[null,"2022-02-16","East","Carrot",38]
[null,"2022-02-17","East","Whole Wheat",25]
[null,"2022-02-18","West","Chocolate Chip",96]