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

[radoqu]

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

<tbody>
</tbody>

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 "anything".

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!

 

[radoqu]

bump

Anyone, please?

 

[arthurbr]

Cross posted at EF and excelguru

 

[radoqu]

Cross posted at EF and excelguru

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

I cross posted that on:
ozgrid - Merge value of cells in range if other cell meets criteria. Function or macro...
excelguru - Merge value of cells in range if other cell meets criteria. Function or macro...
excelforum - Merge value of cells in range if other cell meets criteria. Function or macro...

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