Datafilteradvanced filter and unique records only, probably easier if you
use copy to another location as well

--

Regards,

Peo Sjoblom


"carl" wrote in message
...
I have a table that lists out all my products:

Product Type
BOX050 ABC
BOX050 ABC
BOX050 ABC
BOX060 EFG
BOX060 EFG
BOX060 EFG
BOX060 EFG
BOX355 HIJ
BOX549 KLM
BOX549 KLM

I would like to create the following table that list out the unique
products.

Product Type
BOX050 ABC
BOX060 EFG
BOX355 HIJ
BOX549 KLM

Is there a formula that I can use in ColB of this table that will look at
the first tabvle and display the Type.

Thank you in advance.