Excel - Returning multiple values in a single cell that match criteria

[amazinz2006]

I am trying to find a function that will help me do the following (without using VBA). So suppose i have the following data:

http://i.imgur.com/Ql2Z7yR.jpg

I need it to be the following format:

http://i.imgur.com/OkRsbKE.jpg

Basically, I need to get all the associated sku's (column F) from the parent_sku (column E) into column G comma delimited.

Any help would be GREATLY appreciated!

 

[Aladin Akyurek]

I am trying to find a function that will help me do the following (without using VBA). So suppose i have the following data:

http://i.imgur.com/Ql2Z7yR.jpg

I need it to be the following format:

http://i.imgur.com/OkRsbKE.jpg

Basically, I need to get all the associated sku's (column F) from the parent_sku (column E) into column G comma delimited.

Any help would be GREATLY appreciated!

You need VBA for there is no native function that concatenates a calculated reference. Have a look at "aconcat" examples on this board if interested.