Unique List

[Ashik]

Hi All,

I have a list of items, say in Column A, with many
duplicates. In cell B1 I want to put validation with a
dropdown list to display the items of column A without
duplicates. Can I do that? I am using Excel 2000. Thanks
foer your help.

Regards
Ashik

 

[Dave Peterson]

I'd use data|filter|advanced filter like the way Debra Dalgleish explains it:
http://www.contextures.com/xladvfilter01.html#FilterUR