{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Hide","Go To Special","Filter","VBA Code","Sort Unique Items","Sort with Conditon"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":4,"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":"Hide","index":0,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Product Price List"]
[]
[null,"Category","Product","Quantity","Price"]
[null,"Biscuit","Cookies Cracker",15,219]
[null,"Biscuit","Favorite Cookies",25,580]
[]
[null,"Candies","Karakum",20,540]
[]
[null,"Cereals","Hercules",20,650]
[]
[null,"Pasta","Spaghetti",20,500]
[null,"Wafer","Vanilla Wafers",25,587.5]

{"sheet":"Go To Special","index":1,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Usage of Go To Special"]
[]
[null,"Category","Product","Quantity","Price"]
[null,"Biscuit","Cookies Cracker",15,219]
[null,"Biscuit","Favorite Cookies",25,580]
[null," "]
[null,"Candies","Karakum",20,540]
[]
[null,"Cereals","Hercules",20,650]
[]
[null,"Pasta","Spaghetti",20,500]
[null,"Wafer","Vanilla Wafers",25,587.5]

{"sheet":"Filter","index":2,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Usage of Filter"]
[]
[null,"Category","Product","Quantity","Price"]
[null,"Biscuit","Cookies Cracker",15,219]
[null,"Biscuit","Favorite Cookies",25,580]
[]
[null,"Candies","Karakum",20,540]
[]
[null,"Cereals","Hercules",20,650]
[]
[null,"Pasta","Spaghetti",20,500]
[null,"Wafer","Vanilla Wafers",25,587.5]

{"sheet":"VBA Code","index":3,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Usage of VBA Code"]
[]
[null,"Category","Product","Quantity","Price"]
[null,"Biscuit","Cookies Cracker",15,219]
[null,"Biscuit","Favorite Cookies",25,580]
[]
[null,"Candies","Karakum",20,540]
[]
[null,"Cereals","Hercules",20,650]
[]
[null,"Pasta","Spaghetti",20,500]
[null,"Wafer","Vanilla Wafers",25,587.5]

{"sheet":"Sort Unique Items","index":4,"n_rows":15,"n_cols":4,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Sort Unique Items Ignoring the Blanks"]
[]
[null,"Before",null,"After"]
[null,"USA",null,{"$f":"IFERROR(SMALL(IF((COUNTIF($D$4:D4,$B$5:$B$15)=0)*ISNUMBER($B$5:$B$15),$B$5:$B$15,\"A\"),1),INDEX($B$5:$B$15,MATCH(SMALL(IF(ISTEXT($B$5:$B$15)*(COUNTIF(D4:$D$4,$B$5:$B$15)=0),COUNTIF($B$5:$B$15,\"<\"&$B$5:$B$15),\"\"),1),IF(ISTEXT($B$5:$B$15),COUNTIF($B$5:$B$15,\"<\"&$B$5:$B$15),\"\"),0)))","v":5}]
[null,7,null,{"$f":"IFERROR(SMALL(IF((COUNTIF($D$4:D5,$B$5:$B$15)=0)*ISNUMBER($B$5:$B$15),$B$5:$B$15,\"A\"),1),INDEX($B$5:$B$15,MATCH(SMALL(IF(ISTEXT($B$5:$B$15)*(COUNTIF(D$4:$D5,$B$5:$B$15)=0),COUNTIF($B$5:$B$15,\"<\"&$B$5:$B$15),\"\"),1),IF(ISTEXT($B$5:$B$15),COUNTIF($B$5:$B$15,\"<\"&$B$5:$B$15),\"\"),0)))","v":7}]
[null,"USA",null,{"$f":"IFERROR(SMALL(IF((COUNTIF($D$4:D6,$B$5:$B$15)=0)*ISNUMBER($B$5:$B$15),$B$5:$B$15,\"A\"),1),INDEX($B$5:$B$15,MATCH(SMALL(IF(ISTEXT($B$5:$B$15)*(COUNTIF(D$4:$D6,$B$5:$B$15)=0),COUNTIF($B$5:$B$15,\"<\"&$B$5:$B$15),\"\"),1),IF(ISTEXT($B$5:$B$15),COUNTIF($B$5:$B$15,\"<\"&$B$5:$B$15),\"\"),0)))","v":"Afganistan"}]
[null,null,null,{"$f":"IFERROR(SMALL(IF((COUNTIF($D$4:D7,$B$5:$B$15)=0)*ISNUMBER($B$5:$B$15),$B$5:$B$15,\"A\"),1),INDEX($B$5:$B$15,MATCH(SMALL(IF(ISTEXT($B$5:$B$15)*(COUNTIF(D$4:$D7,$B$5:$B$15)=0),COUNTIF($B$5:$B$15,\"<\"&$B$5:$B$15),\"\"),1),IF(ISTEXT($B$5:$B$15),COUNTIF($B$5:$B$15,\"<\"&$B$5:$B$15),\"\"),0)))","v":"Colombia"}]
[null,"France",null,{"$f":"IFERROR(SMALL(IF((COUNTIF($D$4:D8,$B$5:$B$15)=0)*ISNUMBER($B$5:$B$15),$B$5:$B$15,\"A\"),1),INDEX($B$5:$B$15,MATCH(SMALL(IF(ISTEXT($B$5:$B$15)*(COUNTIF(D$4:$D8,$B$5:$B$15)=0),COUNTIF($B$5:$B$15,\"<\"&$B$5:$B$15),\"\"),1),IF(ISTEXT($B$5:$B$15),COUNTIF($B$5:$B$15,\"<\"&$B$5:$B$15),\"\"),0)))","v":"France"}]
[null,"Korea",null,{"$f":"IFERROR(SMALL(IF((COUNTIF($D$4:D9,$B$5:$B$15)=0)*ISNUMBER($B$5:$B$15),$B$5:$B$15,\"A\"),1),INDEX($B$5:$B$15,MATCH(SMALL(IF(ISTEXT($B$5:$B$15)*(COUNTIF(D$4:$D9,$B$5:$B$15)=0),COUNTIF($B$5:$B$15,\"<\"&$B$5:$B$15),\"\"),1),IF(ISTEXT($B$5:$B$15),COUNTIF($B$5:$B$15,\"<\"&$B$5:$B$15),\"\"),0)))","v":"Korea"}]
[null,5,null,{"$f":"IFERROR(SMALL(IF((COUNTIF($D$4:D10,$B$5:$B$15)=0)*ISNUMBER($B$5:$B$15),$B$5:$B$15,\"A\"),1),INDEX($B$5:$B$15,MATCH(SMALL(IF(ISTEXT($B$5:$B$15)*(COUNTIF(D$4:$D10,$B$5:$B$15)=0),COUNTIF($B$5:$B$15,\"<\"&$B$5:$B$15),\"\"),1),IF(ISTEXT($B$5:$B$15),COUNTIF($B$5:$B$15,\"<\"&$B$5:$B$15),\"\"),0)))","v":"USA"}]
[null,"Colombia"]
[]
[null,5]
[null,"Afganistan"]

{"sheet":"Sort with Conditon","index":5,"n_rows":16,"n_cols":6,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Sort Unique Items Ignoring the Blanks with Condition"]
[]
[null,"Items","Fact",null,"Fact:",false]
[null,"Chocolate",true]
[null,null,null,null,null,"Sorted Data:"]
[null,"Biscuit",true,null,null,{"$f":"IFERROR(INDEX(Table1[Items],MATCH(SMALL(IF(Table1[Fact]=$F$4,IF(ISBLANK(Table1[Items]),\"\",IF(COUNTIF($F$6:F6,Table1[Items])=0,IF(ISNUMBER(Table1[Items]),COUNTIF(Table1[Items],\"<\"&Table1[Items]),COUNTIF(Table1[Items],\"<\"&Table1[Items])+SUM(1*ISNUMBER(Table1[Items]))+1),\"\")),\"\"),1),IF(Table1[Fact]=$F$4,IF(ISBLANK(Table1[Items]),\"\",IF(COUNTIF($F$6:F6,Table1[Items])=0,IF(ISNUMBER(Table1[Items]),COUNTIF(Table1[Items],\"<\"&Table1[Items]),COUNTIF(Table1[Items],\"<\"&Table1[Items])+SUM(1*ISNUMBER(Table1[Items]))+1),\"\")),\"\"),0)),\"\")","v":5}]
[null,"Ice Cream",false,null,null,{"$f":"IFERROR(INDEX(Table1[Items],MATCH(SMALL(IF(Table1[Fact]=$F$4,IF(ISBLANK(Table1[Items]),\"\",IF(COUNTIF($F$6:F7,Table1[Items])=0,IF(ISNUMBER(Table1[Items]),COUNTIF(Table1[Items],\"<\"&Table1[Items]),COUNTIF(Table1[Items],\"<\"&Table1[Items])+SUM(1*ISNUMBER(Table1[Items]))+1),\"\")),\"\"),1),IF(Table1[Fact]=$F$4,IF(ISBLANK(Table1[Items]),\"\",IF(COUNTIF($F$6:F7,Table1[Items])=0,IF(ISNUMBER(Table1[Items]),COUNTIF(Table1[Items],\"<\"&Table1[Items]),COUNTIF(Table1[Items],\"<\"&Table1[Items])+SUM(1*ISNUMBER(Table1[Items]))+1),\"\")),\"\"),0)),\"\")","v":6}]
[null,"Cake",true,null,null,{"$f":"IFERROR(INDEX(Table1[Items],MATCH(SMALL(IF(Table1[Fact]=$F$4,IF(ISBLANK(Table1[Items]),\"\",IF(COUNTIF($F$6:F8,Table1[Items])=0,IF(ISNUMBER(Table1[Items]),COUNTIF(Table1[Items],\"<\"&Table1[Items]),COUNTIF(Table1[Items],\"<\"&Table1[Items])+SUM(1*ISNUMBER(Table1[Items]))+1),\"\")),\"\"),1),IF(Table1[Fact]=$F$4,IF(ISBLANK(Table1[Items]),\"\",IF(COUNTIF($F$6:F8,Table1[Items])=0,IF(ISNUMBER(Table1[Items]),COUNTIF(Table1[Items],\"<\"&Table1[Items]),COUNTIF(Table1[Items],\"<\"&Table1[Items])+SUM(1*ISNUMBER(Table1[Items]))+1),\"\")),\"\"),0)),\"\")","v":"Ice Cream"}]
[null,null,null,null,null,{"$f":"IFERROR(INDEX(Table1[Items],MATCH(SMALL(IF(Table1[Fact]=$F$4,IF(ISBLANK(Table1[Items]),\"\",IF(COUNTIF($F$6:F9,Table1[Items])=0,IF(ISNUMBER(Table1[Items]),COUNTIF(Table1[Items],\"<\"&Table1[Items]),COUNTIF(Table1[Items],\"<\"&Table1[Items])+SUM(1*ISNUMBER(Table1[Items]))+1),\"\")),\"\"),1),IF(Table1[Fact]=$F$4,IF(ISBLANK(Table1[Items]),\"\",IF(COUNTIF($F$6:F9,Table1[Items])=0,IF(ISNUMBER(Table1[Items]),COUNTIF(Table1[Items],\"<\"&Table1[Items]),COUNTIF(Table1[Items],\"<\"&Table1[Items])+SUM(1*ISNUMBER(Table1[Items]))+1),\"\")),\"\"),0)),\"\")","v":"Juice"}]
[null,"Juice",false]
[null,"Chips",true]
[null,5,false,null,null,{"$f":"IFERROR(INDEX(Table1[Items],MATCH(SMALL(IF(Table1[Fact]=$F$4,IF(ISBLANK(Table1[Items]),\"\",IF(COUNTIF($F$6:F12,Table1[Items])=0,IF(ISNUMBER(Table1[Items]),COUNTIF(Table1[Items],\"<\"&Table1[Items]),COUNTIF(Table1[Items],\"<\"&Table1[Items])+SUM(1*ISNUMBER(Table1[Items]))+1),\"\")),\"\"),1),IF(Table1[Fact]=$F$4,IF(ISBLANK(Table1[Items]),\"\",IF(COUNTIF($F$6:F12,Table1[Items])=0,IF(ISNUMBER(Table1[Items]),COUNTIF(Table1[Items],\"<\"&Table1[Items]),COUNTIF(Table1[Items],\"<\"&Table1[Items])+SUM(1*ISNUMBER(Table1[Items]))+1),\"\")),\"\"),0)),\"\")","v":""}]
[null,5,true]
[null,6,false]
[null,6,true]