Merge value of cells in range if other cell meets criteria. Function or macro...

Hello,

I'm quite familiar with functions, but new to macros, and i have a problem to solve. It would be great if someone could help me!

Maybe its the best if i give you an example about what i need to do.

sku	name	result i need
sku_1	Name1	sku_2, sku_3
sku_2	Name1	sku_1, sku_3
sku_3	Name1	sku_1, sku_2
sku_4	Name2	sku_5
sku_5	Name2	sku_4
sku_6	Name3	sku_7, sku_8, sku_9, sku_10, sku_11
sku_7	Name3	sku_6, sku_8, sku_9, sku_10, sku_11
sku_8	Name3	sku_6, sku_7, sku_9, sku_10, sku_11
sku_9	Name3	sku_6, sku_7, sku_8, sku_10, sku_11
sku_10	Name3	sku_6, sku_7, sku_8, sku_9, sku_11
sku_11	Name3	sku_6, sku_7, sku_8, sku_9, sku_10

So: if name in the table is the same, than merge sku's together (separated by ,) without the sku of that line. Ofc. sku and name can be "any" string.

Extra: it would be great (but not necessary) if it would work with NOT ordered names (e.g. name1 in row 1,2,3 and in row 1342).

If it is possible it would be better with functions... but i don't think it can be done. A macro would be great too!

Thanks is advance!

Originally Posted by Pepe Le Mokko

Please do not cross post without links ! http://www.excelguru.ca/content.php?184

Cross posted at Excelguru and MrExcel

Sorry, i did not know that users from these forum follow other forums too.

I cross posted that on:
http://www.ozgrid.com/forum/showthread.php?t=181164
http://www.excelguru.ca/forums/showt...ction-or-macro
http://www.mrexcel.com/forum/excel-q...ion-macro.html

But thats because i really need some help with that.
Thanks and sorry if i made something wrong.