{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Data Tab","Home Tab","Right-click","Shortcut","Drop Down Filter","Clear From a Column","Clear From Multiple Columns","VBA","Clear Filter From a Worksheet"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":9,"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":"Data Tab","index":0,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Product Price List"]
[]
[null,"Category","Product","Quantity","Price"]
[null,"Cereals","Hercules",20,650]
[null,"Biscuit","Cookies Cracker",15,219]
[null,"Wafer","Wafer Chocolate",40,600]
[null,"Wafer","Vanilla Wafers",25,587.5]
[null,"Biscuit","Favorite Cookies",25,580]
[null,"Pasta","Ravioli",45,936]
[null,"Pasta","Spaghetti",20,500]
[null,"Candies","Karakum",20,540]

{"sheet":"Home Tab","index":1,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Product Price List"]
[]
[null,"Category","Product","Quantity","Price"]
[null,"Cereals","Hercules",20,650]
[null,"Biscuit","Cookies Cracker",15,219]
[null,"Wafer","Wafer Chocolate",40,600]
[null,"Wafer","Vanilla Wafers",25,587.5]
[null,"Biscuit","Favorite Cookies",25,580]
[null,"Pasta","Ravioli",45,936]
[null,"Pasta","Spaghetti",20,500]
[null,"Candies","Karakum",20,540]

{"sheet":"Right-click","index":2,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Product Price List"]
[]
[null,"Category","Product","Quantity","Price"]
[null,"Cereals","Hercules",20,650]
[null,"Biscuit","Cookies Cracker",15,219]
[null,"Wafer","Wafer Chocolate",40,600]
[null,"Wafer","Vanilla Wafers",25,587.5]
[null,"Biscuit","Favorite Cookies",25,580]
[null,"Pasta","Ravioli",45,936]
[null,"Pasta","Spaghetti",20,500]
[null,"Candies","Karakum",20,540]

{"sheet":"Shortcut","index":3,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Product Price List"]
[]
[null,"Category","Product","Quantity","Price"]
[null,"Cereals","Hercules",20,650]
[null,"Biscuit","Cookies Cracker",15,219]
[null,"Wafer","Wafer Chocolate",40,600]
[null,"Wafer","Vanilla Wafers",25,587.5]
[null,"Biscuit","Favorite Cookies",25,580]
[null,"Pasta","Ravioli",45,936]
[null,"Pasta","Spaghetti",20,500]
[null,"Candies","Karakum",20,540]

{"sheet":"Drop Down Filter","index":4,"n_rows":12,"n_cols":16,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,7],[1,12,1,15]]}
[]
[null,"Product Price List",null,null,null,null,null,null,null,null,null,null,"Product Price List"]
[]
[null,"Category","Product","Quantity","Price","Row SL.","Matched","Ordered",null,null,"Biscuit",null,"Category","Product","Quantity","Price"]
[null,"Cereals","Hercules",20,650,{"$f":"ROWS($E$5:E5)","v":1},{"$f":"IF(B5=$K$4,F5,\"\")","v":""},{"$f":"IFERROR(SMALL($G$5:$G$12,F5),\"\")","v":2},null,"Cereals",null,null,{"$f":"IFERROR(INDEX($B$5:$E$12,$G5,COLUMNS($M$5:M5)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$5:$E$12,$G5,COLUMNS($M$5:N5)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$5:$E$12,$G5,COLUMNS($M$5:O5)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$5:$E$12,$G5,COLUMNS($M$5:P5)),\"\")","v":""}]
[null,"Biscuit","Cookies Cracker",15,219,{"$f":"ROWS($E$5:E6)","v":2},{"$f":"IF(B6=$K$4,F6,\"\")","v":2},{"$f":"IFERROR(SMALL($G$5:$G$12,F6),\"\")","v":5},null,"Biscuit",null,null,{"$f":"IFERROR(INDEX($B$5:$E$12,$G6,COLUMNS($M$5:M6)),\"\")","v":"Biscuit"},{"$f":"IFERROR(INDEX($B$5:$E$12,$G6,COLUMNS($M$5:N6)),\"\")","v":"Cookies Cracker"},{"$f":"IFERROR(INDEX($B$5:$E$12,$G6,COLUMNS($M$5:O6)),\"\")","v":15},{"$f":"IFERROR(INDEX($B$5:$E$12,$G6,COLUMNS($M$5:P6)),\"\")","v":219}]
[null,"Wafer","Wafer Chocolate",40,600,{"$f":"ROWS($E$5:E7)","v":3},"","",null,"Wafer",null,null,{"$f":"IFERROR(INDEX($B$5:$E$12,$G7,COLUMNS($M$5:M7)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$5:$E$12,$G7,COLUMNS($M$5:N7)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$5:$E$12,$G7,COLUMNS($M$5:O7)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$5:$E$12,$G7,COLUMNS($M$5:P7)),\"\")","v":""}]
[null,"Wafer","Vanilla Wafers",25,587.5,{"$f":"ROWS($E$5:E8)","v":4},"","",null,"Pasta",null,null,{"$f":"IFERROR(INDEX($B$5:$E$12,$G8,COLUMNS($M$5:M8)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$5:$E$12,$G8,COLUMNS($M$5:N8)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$5:$E$12,$G8,COLUMNS($M$5:O8)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$5:$E$12,$G8,COLUMNS($M$5:P8)),\"\")","v":""}]
[null,"Biscuit","Favorite Cookies",25,580,{"$f":"ROWS($E$5:E9)","v":5},5,"",null,"Candies",null,null,{"$f":"IFERROR(INDEX($B$5:$E$12,$G9,COLUMNS($M$5:M9)),\"\")","v":"Biscuit"},{"$f":"IFERROR(INDEX($B$5:$E$12,$G9,COLUMNS($M$5:N9)),\"\")","v":"Favorite Cookies"},{"$f":"IFERROR(INDEX($B$5:$E$12,$G9,COLUMNS($M$5:O9)),\"\")","v":25},{"$f":"IFERROR(INDEX($B$5:$E$12,$G9,COLUMNS($M$5:P9)),\"\")","v":580}]
[null,"Pasta","Ravioli",45,936,{"$f":"ROWS($E$5:E10)","v":6},"","",null,null,null,null,{"$f":"IFERROR(INDEX($B$5:$E$12,$G10,COLUMNS($M$5:M10)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$5:$E$12,$G10,COLUMNS($M$5:N10)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$5:$E$12,$G10,COLUMNS($M$5:O10)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$5:$E$12,$G10,COLUMNS($M$5:P10)),\"\")","v":""}]
[null,"Pasta","Spaghetti",20,500,{"$f":"ROWS($E$5:E11)","v":7},"","",null,null,null,null,{"$f":"IFERROR(INDEX($B$5:$E$12,$G11,COLUMNS($M$5:M11)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$5:$E$12,$G11,COLUMNS($M$5:N11)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$5:$E$12,$G11,COLUMNS($M$5:O11)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$5:$E$12,$G11,COLUMNS($M$5:P11)),\"\")","v":""}]
[null,"Candies","Karakum",20,540,{"$f":"ROWS($E$5:E12)","v":8},"","",null,null,null,null,{"$f":"IFERROR(INDEX($B$5:$E$12,$G12,COLUMNS($M$5:M12)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$5:$E$12,$G12,COLUMNS($M$5:N12)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$5:$E$12,$G12,COLUMNS($M$5:O12)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$5:$E$12,$G12,COLUMNS($M$5:P12)),\"\")","v":""}]

{"sheet":"Clear From a Column","index":5,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Product Price List"]
[]
[null,"Category","Product","Quantity","Price"]
[null,"Cereals","Hercules",20,650]
[null,"Biscuit","Cookies Cracker",15,219]
[null,"Wafer","Wafer Chocolate",40,600]
[null,"Wafer","Vanilla Wafers",25,587.5]
[null,"Biscuit","Favorite Cookies",25,580]
[null,"Pasta","Ravioli",45,936]
[null,"Pasta","Spaghetti",20,500]
[null,"Candies","Karakum",20,540]

{"sheet":"Clear From Multiple Columns","index":6,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Product Price List"]
[]
[null,"Category","Product","Quantity","Price"]
[null,"Cereals","Hercules",20,650]
[null,"Biscuit","Cookies Cracker",15,219]
[null,"Wafer","Wafer Chocolate",40,600]
[null,"Wafer","Vanilla Wafers",25,587.5]
[null,"Biscuit","Favorite Cookies",25,580]
[null,"Pasta","Ravioli",45,936]
[null,"Pasta","Spaghetti",20,500]
[null,"Candies","Karakum",20,540]

{"sheet":"VBA","index":7,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Product Price List"]
[]
[null,"Category","Product","Quantity","Price"]
[null,"Cereals","Hercules",20,650]
[null,"Biscuit","Cookies Cracker",15,219]
[null,"Wafer","Wafer Chocolate",40,600]
[null,"Wafer","Vanilla Wafers",25,587.5]
[null,"Biscuit","Favorite Cookies",25,580]
[null,"Pasta","Ravioli",45,936]
[null,"Pasta","Spaghetti",20,500]
[null,"Candies","Karakum",20,540]

{"sheet":"Clear Filter From a Worksheet","index":8,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Product Price List"]
[]
[null,"Category","Product","Quantity","Price"]
[null,"Cereals","Hercules",20,650]
[null,"Biscuit","Cookies Cracker",15,219]
[null,"Wafer","Wafer Chocolate",40,600]
[null,"Wafer","Vanilla Wafers",25,587.5]
[null,"Biscuit","Favorite Cookies",25,580]
[null,"Pasta","Ravioli",45,936]
[null,"Pasta","Spaghetti",20,500]
[null,"Candies","Karakum",20,540]