MrExcel Publishing
Your One Stop for Excel Tips & Solutions

merge sub-suplicates

Posted by Kevin James on May 04, 2001 11:01 AM

Well, I did a complete search on the message board looking for "duplicate", "group", "match" and other words. I didn't quite see what I'm looking for, even though I am sure I saw a posting within the last two weeks that asked a similar question.

Copy the following into a CSV file and then open it into Excel:

What I want is a formula (not VBA) that will render:
Column A ColumnB
fruit apples,oranges,bananas
nuts walnut,pecan,penanut,cashew

I am not tracking food, this is just an oversimplified example. In each instance the ProductLine will have been sorted so that all "fruits" and "nuts" are within a contiguous range of rows. I don't care that Item is sorted, it can be concat'd in sequential order.


Posted by Aladin Akyurek on May 04, 2001 11:14 AM


Maybe you're referring to:



Posted by Kevin James on May 04, 2001 11:38 AM

Re: merge sub-duplicates

Hi Aladin,

That was indeed the message I was thinking of, but the results are not what I need. I only tried suggestion #2 but it seemed like the most likely candidate to give the results.

I was thinking that through some combination of the use of INDEX, MATCH, and OFFSET I might create the results I want. For some reason, I find the MS-Help on this functions difficult to follow and even harder to extrapolate how I would use them for my particular need.

Much thanks for the posting though!!!