This is really bugging me but I'm sure it can be done...

I want to concantenate all the values from one column that match
given criteria - into one cell. I have tried using workshee
functions but it's getting too complicated - how would I do this usin
VBA?

e.g.

Column A - Column B
1)oranges - box3
2)apples - box2
3)pears - box2
4)bananas - box1
5)peaches - box2

using the above example I would like Column C to show what else is i
the box with the item already shown on that row, e.g.

Column A - Column B - Column C
1)oranges - box3 - sole item
2)apples - box2 - pears, peaches
3)pears - box2 - apples, peaches
4)apples - box1 - sole item
5)peaches- box2 - apples, pears

At this stage I'm not concerned about the order items are shown i
Column C, although if it is possible to sort them from left to right i
alpha order this would be a bonus (e.g. C2 above would then rea
"peaches, pears").

Any Suggestions

--
Message posted from http://www.ExcelForum.com