Advanced Filter can be used to generate a list of unique values. Select
'Unique records only'. Otherwise, by formula...

D2:

=SUM(IF(FREQUENCY(IF(B2:B10<"",MATCH("~"&B2:B10,B 2:B10&"",0)),ROW(B2:B10
)-ROW(B2)+1),1))

E2, confirmed with CONTROL+SHIFT+ENTER, and copied down:

=IF(ROWS(E$2:E2)<=$D$2,INDEX($B$2:$B$10,SMALL(IF(F REQUENCY(IF($B$2:$B$10<
"",MATCH("~"&$B$2:$B$10,$B$2:$B$10&"",0)),ROW($B$ 2:$B$10)-ROW($B$2)+1),R
OW($B$2:$B$10)-ROW($B$2)+1),ROWS(E$2:E2))),"")

Hope this helps!

In article
,
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?