Insert a new worksheet and copy your list from column B of the first
sheet into column A of the new sheet. If you do not have a header then
insert a new row at the top of your data in the new sheet and put
"Material" in A1.

Then highlight all the data and the header from A1 down and click on
Data | Filter | Advanced Filter. In the pop-up you should check Unique
Records only and Copy to another location. Put C1 in the destination
box and click OK.

You will now have a unique list in column C - you can delete columns A
and B.

Hope this helps.

Pete

On Dec 9, 8:18 pm, 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?