Returning Multiple Names in one Column

[Amy Cruse]

My worksheet lists multiple products by numerical code and the names of
customers why buy these products. I want to list the names of each
customer that buys each of my products in one column, separated by commas,
in a second worksheet. The worksheet containing codes and names in a list
would like this:

Column A Column B
Product Code Customer

1234454 Acme
1234454 Brown
1234454 Green
1234454 Smith
2577799 Jump
2577799 Run
2577799 Skip


My goal is to end up with two columns in a second worksheet that look like
this:

Column A Column B
Product Code Customers

1234454 Acme, Brown, Green, Smith
2577799 Jump, Run, Skip


Any help would be appreciated.

Amy

 

[Excel Guru]

Hi Amy,

I highly recommend you not download the program
morefunc.xll as previously suggested. This file burned up
my Excel XP and I had to re purchase the entire Office XP
suite for $500.

 

[Amy Cruse]

Would anyone else care to weigh in - message from Excel Guru obviously gives
me something to worry about. Has anyone else experienced this problem. I
am using Excel 97.

Thanks

 

[Amy Cruse]

Thanks. Will proceed with Aladin suggestion.

AC

Read other posts by Excel Guru - his advice is flawed and he appears to be
here for some form of excitement - similar to a flasher.

First, the addin has been used by thousands without problems.
Second, if something caused software to become flawed, it would be a simple
task to reinstall the software from the CD.
Third, Buying a new copy of Office XP for $500 would show the Guru not be be
a very shrewd shopper.

I have used it for several years with no problems.