Data Validation Unique List Drop Down

[Jhon Mustofa]

hi all..

how to make formula in Data Validation|List, with unique list name criteria..
animal - dog, tiger, cat
fruits --apple, mangoes, banana

please, check my attachment file...

any help is greatly appreciated

john m

[JohnTopley]

In F3

=IFERROR(LOOKUP(2,1/(COUNTIF($F$2:$F2,$B$4:$B$9)=0),$B$4:$B$9),"")

will give you unique list from Column B

[Jhon Mustofa]

hi John thanks...but i want the formula used in Data Validation - List ....

[JohnTopley]

You need to define the list in the way I provided, name it ("NamedLIst")and the in DV use List , =NamedList