Sorry for the confusion. What I have is products used for a certain type of service from different days. The products that are used may be totally different day to day but some times some of the products will be the same. I want to be able to take the products from all the days and summarize them in one column showing all product types used without doubleing up on the ones that have been used more then once. I hope that this clears it up a bit.