{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Unique Values","Advanced Filter","INDEX & MATCH","LOOKUP & COUNTIF","UNIQUE ","VBA Macro","Remove Duplicate"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":13,"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":"Unique Values","index":0,"n_rows":20,"n_cols":4,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Get Unique Values from Range in Excel "]
[]
[null,"Product","Amount","Country"]
[null,"Apple",2818,"Canada"]
[null,"Blueberry",4964,"Spain"]
[null,"Carrot",3412,"Denmark"]
[null,"Banana",3769,"Canada"]
[null,"Cabbage",1366,"France"]
[null,"Orange",1412,"Spain"]
[null,"Broccoli",4658,"Denmark"]
[null,"Banana",3382,"France"]
[null,"Grape",2295,"Canada"]
[null,"Cabbage",3762,"Spain"]
[null,"Grape",1830,"Denmark"]
[null,"Blueberry",4004,"Canada"]
[null,"Broccoli",1111,"France"]
[null,"Orange",2025,"Canada"]
[null,"Carrot",3558,"Denmark"]
[null,"Apple",4206,"Spain"]

{"sheet":"Advanced Filter","index":1,"n_rows":20,"n_cols":5,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Advanced Filter to Get Unique Values from Range "]
[]
[null,"Product","Amount","Country","Unique Products"]
[null,"Apple",2818,"Canada","Apple"]
[null,"Blueberry",4964,"Spain","Blueberry"]
[null,"Carrot",3412,"Denmark","Carrot"]
[null,"Banana",3769,"Canada","Banana"]
[null,"Cabbage",1366,"France","Cabbage"]
[null,"Orange",1412,"Spain","Orange"]
[null,"Broccoli",4658,"Denmark","Broccoli"]
[null,"Banana",3382,"France","Grape"]
[null,"Grape",2295,"Canada"]
[null,"Cabbage",3762,"Spain"]
[null,"Grape",1830,"Denmark"]
[null,"Blueberry",4004,"Canada"]
[null,"Broccoli",1111,"France"]
[null,"Orange",2025,"Canada"]
[null,"Carrot",3558,"Denmark"]
[null,"Apple",4206,"Spain"]

{"sheet":"INDEX & MATCH","index":2,"n_rows":20,"n_cols":21,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"INDEX & MATCH to Get Unique Values from Range "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Product"]
[null,"Product","Amount","Country","Unique Products",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Apple"]
[null,"Apple",2818,"Canada",{"$f":"INDEX(B5:B20,MATCH(0,COUNTIF($E$4:E4,B5:B20),0))","v":"Apple"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Blueberry"]
[null,"Blueberry",4964,"Spain",{"$f":"INDEX(B6:B21,MATCH(0,COUNTIF($E$4:E5,B6:B21),0))","v":"Blueberry"}]
[null,"Carrot",3412,"Denmark",{"$f":"INDEX(B7:B22,MATCH(0,COUNTIF($E$4:E6,B7:B22),0))","v":"Carrot"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Banana"]
[null,"Banana",3769,"Canada",{"$f":"INDEX(B8:B23,MATCH(0,COUNTIF($E$4:E7,B8:B23),0))","v":"Banana"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cabbage"]
[null,"Cabbage",1366,"France",{"$f":"INDEX(B9:B24,MATCH(0,COUNTIF($E$4:E8,B9:B24),0))","v":"Cabbage"}]
[null,"Orange",1412,"Spain",{"$f":"INDEX(B10:B25,MATCH(0,COUNTIF($E$4:E9,B10:B25),0))","v":"Orange"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Broccoli"]
[null,"Broccoli",4658,"Denmark",{"$f":"INDEX(B11:B26,MATCH(0,COUNTIF($E$4:E10,B11:B26),0))","v":"Broccoli"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Banana"]
[null,"Banana",3382,"France",{"$f":"INDEX(B12:B27,MATCH(0,COUNTIF($E$4:E11,B12:B27),0))","v":"Grape"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Grape"]
[null,"Grape",2295,"Canada"]
[null,"Cabbage",3762,"Spain",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Grape"]
[null,"Grape",1830,"Denmark",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Blueberry"]
[null,"Blueberry",4004,"Canada"]
[null,"Broccoli",1111,"France",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Orange"]
[null,"Orange",2025,"Canada",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Carrot"]
[null,"Carrot",3558,"Denmark",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Apple"]
[null,"Apple",4206,"Spain"]

{"sheet":"LOOKUP & COUNTIF","index":3,"n_rows":20,"n_cols":5,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"LOOKUP & COUNTIF to Get Unique Values from Range "]
[]
[null,"Product","Amount","Country","Unique Products"]
[null,"Apple",2818,"Canada",{"$f":"LOOKUP(2,1/((COUNTIF($E$4:E4,$B$5:$B$20)=0)*(COUNTIF($B$5:$B$20,$B$5:$B$20)=1)),$B$5:$B$20)","v":"Carrot"}]
[null,"Blueberry",4964,"Spain",{"$f":"LOOKUP(2,1/((COUNTIF($E$4:E5,$B$5:$B$20)=0)*(COUNTIF($B$5:$B$20,$B$5:$B$20)=1)),$B$5:$B$20)","v":"Blueberry"}]
[null,"Carrot",3412,"Denmark"]
[null,"Banana",3769,"Canada"]
[null,"Cabbage",1366,"France"]
[null,"Orange",1412,"Spain"]
[null,"Broccoli",4658,"Denmark"]
[null,"Banana",3382,"France"]
[null,"Grape",2295,"Canada"]
[null,"Cabbage",3762,"Spain"]
[null,"Grape",1830,"Denmark"]
[null,"Orange",4004,"Canada"]
[null,"Broccoli",1111,"France"]
[null,"Orange",2025,"Canada"]
[null,"Broccoli",3558,"Denmark"]
[null,"Apple",4206,"Spain"]

{"sheet":"UNIQUE ","index":4,"n_rows":20,"n_cols":5,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"UNIQUE Function to Get Unique Values from Range "]
[]
[null,"Product","Amount","Country","Unique Country"]
[null,"Apple",2818,"Canada","Canada"]
[null,"Blueberry",2818,"Spain","Spain"]
[null,"Carrot",2818,"Denmark","Denmark"]
[null,"Banana",2818,"Canada","France"]
[null,"Cabbage",2818,"France"]
[null,"Orange",2818,"Spain"]
[null,"Broccoli",2818,"Denmark"]
[null,"Banana",2818,"France"]
[null,"Grape",2818,"Canada"]
[null,"Cabbage",2818,"Spain"]
[null,"Grape",2818,"Denmark"]
[null,"Blueberry",4004,"Canada"]
[null,"Broccoli",1111,"France"]
[null,"Orange",2025,"Canada"]
[null,"Carrot",3558,"Denmark"]
[null,"Apple",4206,"Spain"]

{"sheet":"VBA Macro","index":5,"n_rows":20,"n_cols":5,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"VBA Macro to Get Unique Values from Range "]
[]
[null,"Product","Amount","Country","Unique Products"]
[null,"Apple",2818,"Canada","Apple"]
[null,"Blueberry",4964,"Spain","Blueberry"]
[null,"Carrot",3412,"Denmark","Carrot"]
[null,"Banana",3769,"Canada","Banana"]
[null,"Cabbage",1366,"France","Cabbage"]
[null,"Orange",1412,"Spain","Orange"]
[null,"Broccoli",4658,"Denmark","Broccoli"]
[null,"Banana",3382,"France","Grape"]
[null,"Grape",2295,"Canada"]
[null,"Cabbage",3762,"Spain"]
[null,"Grape",1830,"Denmark"]
[null,"Blueberry",4004,"Canada"]
[null,"Broccoli",1111,"France"]
[null,"Orange",2025,"Canada"]
[null,"Carrot",3558,"Denmark"]
[null,"Apple",4206,"Spain"]

{"sheet":"Remove Duplicate","index":6,"n_rows":20,"n_cols":5,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Remove Duplicates to Get Unique Values from Range "]
[]
[null,"Product","Amount","Country","Unique Country"]
[null,"Apple",2818,"Canada","Canada"]
[null,"Blueberry",4964,"Spain","Spain"]
[null,"Carrot",3412,"Denmark","Denmark"]
[null,"Banana",3769,"Canada","France"]
[null,"Cabbage",1366,"France"]
[null,"Orange",1412,"Spain"]
[null,"Broccoli",4658,"Denmark"]
[null,"Banana",3382,"France"]
[null,"Grape",2295,"Canada"]
[null,"Cabbage",3762,"Spain"]
[null,"Grape",1830,"Denmark"]
[null,"Blueberry",4004,"Canada"]
[null,"Broccoli",1111,"France"]
[null,"Orange",2025,"Canada"]
[null,"Carrot",3558,"Denmark"]
[null,"Apple",4206,"Spain"]