Hey guys, here's another one that's driving me up the wall

We have series of item numbers in a particular column, I need some way
to find matching item numbers, and, when it finds the match, to
concatenate from a different cell within the same row.

The items in question are necklaces, and we have them organized as
parent and child, the parent has no length listed, But each child is a
different available length for that item, a parent item can have any
number if children, so the listing would look something like this:


parent item column Length
006-001 -
006-001 18 inches
006-001 20 inches
006-001 22 inches
006-002 -
006-002 18 inches
006-002 22 inches

An example of what I need would be

parent item column Length
006-001 18 inches, 20 inches, 22 inches
006-001 18 inches
006-001 20 inches
006-001 22 inches
006-002 18 inches, 22 inches
006-002 18 inches
006-002 22 inches

So, I would need it to look in the parent item column, and see which
ones match, and to take the lengths of all the matches and put them
into another cell.

Thanks for all your help!


--
method373
------------------------------------------------------------------------
method373's Profile: http://www.excelforum.com/member.php...o&userid=29888
View this thread: http://www.excelforum.com/showthread...hreadid=512490