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 wrote in message
...
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...