Extract Unique List

Giganews Newsgroups
Subject: Extract Unique List
Posted by:  ZootRot (NoSp…@AntiSpamEmail.com)
Date: Tue, 4 May 2004

Excel 2002

From a list of multiple entries, how do I extract to another list of unique
entries, prefereably without a macro.  Similar to what appears in a data
filter.

For example:
list contains:
    dog
    cat
    pig
    monkey
    dog
    dog
    pig
    monkey

I want to extract only: dog, cat, pig, monkey and use it in a data
validation list.

Thanks for your help.

Replies