Hi Rasheed

Use advanced filter to create a unique list and use that list in Data > Validation > List

http://www.contextures.com/xladvfilter01.html#FilterUR


--
Regards Ron de Bruin
http://www.rondebruin.nl



"Rasheed Ahmed" <Rasheed Ahmed@discussions.microsoft.com> wrote in message
news:1B410BCA-D2DC-4A53-80B8-64D15ACF1E20@microsoft.com...
> Hello! Friends
>
> I have a list of names containing duplicate names and empty cells.
>
> Using Data > Validation > List
>
> I want get a drop down list of unique entries having no empty cells.
>
> How can do this??? Please help me...