Data validation list without duplicate value

[Sunil99580]

Hey,

I want to create a data validation list that only contain unique values.

exp i have the below list on A2:A7

SAM
Raviya
juily
Sam
Albert
Raviya



So now i want to create a data validation list at H8 That count sam only once and same as raviya.

Can any one help me out with this..???

 

[Youngdand]

try this thread.

https://www.mrexcel.com/forum/excel-questions/488149-unique-list-use-validation-list.html

Regards,

Dan.