{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Array Formula"," Unique Function","Non Array Formula","Excluding Duplicate","Advanced Filter","Case Sensitive Distinct Value","Pivot Table","VBA Code","Highlight Unique Items","Hide Duplicate items"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":7,"comments":0,"pivot_tables":1},"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":"Array Formula","index":0,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Product List"]
[]
[null,"Id No","Product Name",null,"Unique Product Using Array Formula"]
[null,101,"Milk",null,{"$f":"IFERROR(INDEX($C$5:$C$12,MATCH(0,COUNTIF($E$4:E4,$C$5:$C$12),0)),\"\")","v":"Milk"}]
[null,102,"Soup",null,{"$f":"IFERROR(INDEX($C$5:$C$12,MATCH(0,COUNTIF($E$4:E5,$C$5:$C$12),0)),\"\")","v":"Soup"}]
[null,103,"Egg",null,{"$f":"IFERROR(INDEX($C$5:$C$12,MATCH(0,COUNTIF($E$4:E6,$C$5:$C$12),0)),\"\")","v":"Egg"}]
[null,104,"Soup",null,{"$f":"IFERROR(INDEX($C$5:$C$12,MATCH(0,COUNTIF($E$4:E7,$C$5:$C$12),0)),\"\")","v":"Paasta"}]
[null,105,"Paasta",null,{"$f":"IFERROR(INDEX($C$5:$C$12,MATCH(0,COUNTIF($E$4:E8,$C$5:$C$12),0)),\"\")","v":"Icecream"}]
[null,106,"Icecream",null,{"$f":"IFERROR(INDEX($C$5:$C$12,MATCH(0,COUNTIF($E$4:E9,$C$5:$C$12),0)),\"\")","v":""}]
[null,107,"Egg",null,{"$f":"IFERROR(INDEX($C$5:$C$12,MATCH(0,COUNTIF($E$4:E10,$C$5:$C$12),0)),\"\")","v":""}]
[null,108,"Milk"]

{"sheet":" Unique Function","index":1,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Product List"]
[]
[null,"Id No","Product Name",null,"Unique Product List Using Unique Function"]
[null,101,"Milk",null,{"$f":"_xlfn.UNIQUE(C5:C12,FALSE)","v":"Milk"}]
[null,102,"Soup",null,"Soup"]
[null,103,"Egg",null,"Egg"]
[null,104,"Soup",null,"Paasta"]
[null,105,"Paasta",null,"Icecream"]
[null,106,"Icecream"]
[null,107,"Egg"]
[null,108,"Milk"]

{"sheet":"Non Array Formula","index":2,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Product List"]
[]
[null,"Id No","Product Name",null,"Unique Product Using  Non Array Formula"]
[null,101,"Milk",null,{"$f":"LOOKUP(2,1/(COUNTIF($E$4:E4,$C$5:$C$12)=0),$C$5:$C$12)","v":"Milk"}]
[null,102,"Soup",null,{"$f":"LOOKUP(2,1/(COUNTIF($E$4:E5,$C$5:$C$12)=0),$C$5:$C$12)","v":"Egg"}]
[null,103,"Egg",null,{"$f":"LOOKUP(2,1/(COUNTIF($E$4:E6,$C$5:$C$12)=0),$C$5:$C$12)","v":"Icecream"}]
[null,104,"Soup",null,{"$f":"LOOKUP(2,1/(COUNTIF($E$4:E7,$C$5:$C$12)=0),$C$5:$C$12)","v":"Paasta"}]
[null,105,"Paasta",null,{"$f":"LOOKUP(2,1/(COUNTIF($E$4:E8,$C$5:$C$12)=0),$C$5:$C$12)","v":"Soup"}]
[null,106,"Icecream"]
[null,107,"Egg"]
[null,108,"Milk"]

{"sheet":"Excluding Duplicate","index":3,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Product List"]
[]
[null,"Id No","Product Name",null,"Unique Product Excluding Duplicates"]
[null,101,"Milk",null,{"$f":"INDEX(List,MATCH(0,INDEX(COUNTIF(E4:$E$4,List)+(COUNTIF(List,List)<>1),0,0),0))","v":"Paasta"}]
[null,102,"Soup",null,{"$f":"INDEX(List,MATCH(0,INDEX(COUNTIF(E$4:$E5,List)+(COUNTIF(List,List)<>1),0,0),0))","v":"Icecream"}]
[null,103,"Egg"]
[null,104,"Soup"]
[null,105,"Paasta"]
[null,106,"Icecream"]
[null,107,"Egg"]
[null,108,"Milk"]

{"sheet":"Advanced Filter","index":4,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Product List"]
[]
[null,"Id No","Product Name",null,"Unique Product Using Advanved Filter"]
[null,101,"Milk",null,"Milk"]
[null,102,"Soup",null,"Soup"]
[null,103,"Egg",null,"Egg"]
[null,104,"Soup",null,"Paasta"]
[null,105,"Paasta",null,"Icecream"]
[null,106,"Icecream"]
[null,107,"Egg"]
[null,108,"Milk"]

{"sheet":"Case Sensitive Distinct Value","index":5,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[null,"List ",null,"Case Sensitive Distinct Values"]
[null,"Product 1",null,{"$f":"IFERROR(INDEX($B$3:$B$10, MATCH(0, FREQUENCY(IF(EXACT($B$3:$B$10,TRANSPOSE($D$2:D2)), MATCH(ROW($B$3:$B$10), ROW($B$3:$B$10)), \"\"), MATCH(ROW($B$3:$B$10), ROW($B$3:$B$10))), 0)), \"\")","v":"Product 1"}]
[null,"product 1",null,{"$f":"IFERROR(INDEX($B$3:$B$10, MATCH(0, FREQUENCY(IF(EXACT($B$3:$B$10,TRANSPOSE($D$2:D3)), MATCH(ROW($B$3:$B$10), ROW($B$3:$B$10)), \"\"), MATCH(ROW($B$3:$B$10), ROW($B$3:$B$10))), 0)), \"\")","v":"product 1"}]
[null,"pRoduct2",null,{"$f":"IFERROR(INDEX($B$3:$B$10, MATCH(0, FREQUENCY(IF(EXACT($B$3:$B$10,TRANSPOSE($D$2:D4)), MATCH(ROW($B$3:$B$10), ROW($B$3:$B$10)), \"\"), MATCH(ROW($B$3:$B$10), ROW($B$3:$B$10))), 0)), \"\")","v":"pRoduct2"}]
[null,"PRODUCT 2",null,{"$f":"IFERROR(INDEX($B$3:$B$10, MATCH(0, FREQUENCY(IF(EXACT($B$3:$B$10,TRANSPOSE($D$2:D5)), MATCH(ROW($B$3:$B$10), ROW($B$3:$B$10)), \"\"), MATCH(ROW($B$3:$B$10), ROW($B$3:$B$10))), 0)), \"\")","v":"PRODUCT 2"}]
[null,"proDuct2",null,{"$f":"IFERROR(INDEX($B$3:$B$10, MATCH(0, FREQUENCY(IF(EXACT($B$3:$B$10,TRANSPOSE($D$2:D6)), MATCH(ROW($B$3:$B$10), ROW($B$3:$B$10)), \"\"), MATCH(ROW($B$3:$B$10), ROW($B$3:$B$10))), 0)), \"\")","v":"proDuct2"}]
[null,"Product 1",null,{"$f":"IFERROR(INDEX($B$3:$B$10, MATCH(0, FREQUENCY(IF(EXACT($B$3:$B$10,TRANSPOSE($D$2:D7)), MATCH(ROW($B$3:$B$10), ROW($B$3:$B$10)), \"\"), MATCH(ROW($B$3:$B$10), ROW($B$3:$B$10))), 0)), \"\")","v":"Product 12"}]
[null,"pRoduct2",null,{"$f":"IFERROR(INDEX($B$3:$B$10, MATCH(0, FREQUENCY(IF(EXACT($B$3:$B$10,TRANSPOSE($D$2:D8)), MATCH(ROW($B$3:$B$10), ROW($B$3:$B$10)), \"\"), MATCH(ROW($B$3:$B$10), ROW($B$3:$B$10))), 0)), \"\")","v":""}]
[null,"Product 12",null,{"$f":"IFERROR(INDEX($B$3:$B$10, MATCH(0, FREQUENCY(IF(EXACT($B$3:$B$10,TRANSPOSE($D$2:D9)), MATCH(ROW($B$3:$B$10), ROW($B$3:$B$10)), \"\"), MATCH(ROW($B$3:$B$10), ROW($B$3:$B$10))), 0)), \"\")","v":""}]

{"sheet":"Pivot Table","index":6,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Product List"]
[]
[null,"Id No","Product Name",null,"Row Labels"]
[null,101,"Milk",null,"Egg"]
[null,102,"Soup",null,"Icecream"]
[null,103,"Egg",null,"Milk"]
[null,104,"Soup",null,"Paasta"]
[null,105,"Paasta",null,"Soup"]
[null,106,"Icecream",null,"Grand Total"]
[null,107,"Egg"]
[null,108,"Milk"]

{"sheet":"VBA Code","index":7,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Product List"]
[]
[null,"Id No","Product Name",null,"Product Name"]
[null,101,"Milk",null,"Milk"]
[null,102,"Soup",null,"Soup"]
[null,103,"Egg",null,"Egg"]
[null,104,"Soup",null,"Paasta"]
[null,105,"Paasta",null,"Icecream"]
[null,106,"Icecream"]
[null,107,"Egg"]
[null,108,"Milk"]

{"sheet":"Highlight Unique Items","index":8,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Product List"]
[]
[null,"Id No","Product Name"]
[null,101,"Milk"]
[null,102,"Soup"]
[null,103,"Egg"]
[null,104,"Soup"]
[null,105,"Paasta"]
[null,106,"Icecream"]
[null,107,"Egg"]
[null,108,"Milk"]

{"sheet":"Hide Duplicate items","index":9,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Product List"]
[]
[null,"Id No","Product Name"]
[null,101,"Milk"]
[null,102,"Soup"]
[null,103,"Egg"]
[null,104,"Soup"]
[null,105,"Paasta"]
[null,106,"Icecream"]
[null,107,"Egg"]
[null,108,"Milk"]