Dropdown with Unique values from range that contains duplicates

[AYouQueTai]

Hi there,
I am trying to create a dropdown for my dispatch sheet that would use only unique values found in my rates sheet.
as you can see, giraffe, monkey and Bear appears several times in my rate sheet but would like only 1 of each in my Customer dropdown.
Can anyone help?

Internet.xlsx
	F
2
Dispatch

Internet.xlsx
	E
7
Rates

Thanks,

 

[awoohaw]

This is from ExcelIsFun, Excel Magic Trick 759

Mr excel questions 58.xlsm
	A	B	C	D	E	F	G
1	nn		uniquenames		dropdown:
2	Giraffe		Bear
3	Giraffe		Giraffe
4	Bear		Monkey
5	Monkey
6	Monkey
7	Bear
8
9
10
11
12
13
14
15
16
17
AYouQueTai

Cell Formulas
Range	Formula
B5:B7	B5	=IFERROR(INDEX($A$2:$A$14,MATCH(0,COUNTIF($A$2:$A$14,"<"&$A$2:$A$14)-SUM(COUNTIF($A$2:$A$14,C$1:C4)),0)),"")
B8:B9	B8	=IFERROR(INDEX(A8:A20,MATCH(0,COUNTIF(A8:A20,"<"&A8:A20)-SUM(COUNTIF(A8:A20,C$1:C7)),0)),"")
C2:C11	C2	=IFERROR(INDEX($A$2:$A$14,MATCH(0,COUNTIF($A$2:$A$14,"<"&nn)-SUM(COUNTIF($A$2:$A$14,C$1:C1)),0)),"")
C16:C17	C16	=IFERROR(INDEX($A$2:$A$14,MATCH(0,COUNTIF($A$2:$A$14,"<"&nn)-SUM(COUNTIF($A$2:$A$14,C$1:C5)),0)),"")

Named Ranges
Name	Refers To	Cells
nn	=AYouQueTai!$A$2:$A$14	C16:C17, B5:B7, C2:C11
uniquenames	=AYouQueTai!$C$2:$C$9	C16:C17, C3:C11, B5:B9

Cells with Data Validation
Cell	Allow	Criteria
E2	List	=uniquenames

 

[Akuini]

If you're willing to use an add-in, you can use a free Excel add-in called "Search deList" to get searchable data validation. You can find it here:
Search deList

Features:
Get unique, sorted & non-blank list.
Search by multiple keywords.
Several ways to search, like using AND or OR or LIKE operator , with or without keyword order.
Sort the list by original order or ascending order.
Widen or shorten the combobox width at run time.
Insert multiple entries into the cell.