Hello,

I have an expanding column of text data that I need excel to select particular items from (based on a text entry in an adjacent column) and collect them in to a named range (that can subsequently be used as a drop down list). I also want excel to automatically remove duplicates and order the named range alphabetically.

Example:
Rose Liquids
Cedarwood Liquids
10ml Round Bottles
Rose Liquids
Syringe Equiptment
Sandalwood Liquids
Coconut Oil Oils
20ml Square Bottles
Ambrette Liquids
50ml Beaker Equiptment

To Clarify.... From The above set of data, I need to extract 4 named ranges (Liquids, Oils, Bottles & Equiptment).

The named range "Liquids" for example will need to return a result of {Ambrette, Cedarwood, Rose, Sandalwood} (duplicate "Rose" removed and all alphabetically ordered).

I also need to ensure that as the data set grows excel is able to update and expand all four of the named ranges.

Any help would be greatly appreciated.
Matt.