On Dec 9, 3:58 pm, Gord Dibben <gorddibbATshawDOTca wrote:
See Debra Dalgleish's site for copying Unique Values to another sheet.

http://www.contextures.on.ca/xladvfi....html#FilterUR

Gord Dibben MS Excel MVP



On Sun, 9 Dec 2007 12:18:39 -0800 (PST), rpick60 wrote:
I have a list of materials in column B that may have the same material
listed several times, I would like to create a list of all materials
used in another column without duplicating the same material. I have
tried lists but I can get one material at a time or all of them.
Can anyone help with just a single list of material types?- Hide quoted text -

- Show quoted text -

Thaks for the quick reponse I will give it a try.