Get multiple cells in the same cell including a if function

Hi,

I have a list of products.
Column A = Unique SKUS
Column B = Product Name
Column C= Product Family

ei:
Sku Name Family
123 Galileo Pendant Light Galileo
124 Galileo Wall Light Galileo
125 Galileo Floor Lamp Galileo
234 Unika Pendant Light Unika
431 Zara Pendant Light Zara
432 Zara Pendant 2 Light Zara

On a new column, I want to figure out a formula where I could get all the Sku of the same family separated by /

So the result would be:

Sku Name Family Related Sku
123 Galileo Pendant Light Galileo 124/125
124 Galileo Wall Light Galileo 123/125
125 Galileo Floor Lamp Galileo 124/123
234 Unika Pendant Light Unika N/A
431 Zara Pendant Light Zara 432
432 Zara Pendant 2 Light Zara 431


I have 6000+ products to sort out.
Can someone please help?
I tried:
=if(C1=C:C,A1,if(C1=C:C,A2,if(C1=C/C,A3,"N/A")))

But I know I am completely out of the mark.

Hi,

Can you attached excel sample file for the same.

Imran.

here is a sample file
https://docs.google.com/spreadsheets...it?usp=sharing

Sample product list.xlsx

Cheers!

Hi,

Thanks a million! But still having a small issue....

I am entering a slightly modified formula and I have a mac.

=ConcatAll(IF(IF($C$2:$C$5975=C2,$A$2:$A$5975,"")=A2,"",IF($C$2:$C$5975=C2,$A$2:$A$5975,"")),"|")
After inserting the new module code and pasting this formula, I pressed Shift+Command+Return, but the cell is blank.

If I click through the cell, the formula is there but nothing comes up.
What am I doing wrong?
Screen Shot 2016-02-11 at 10.43.25 AM.pngScreen Shot 2016-02-11 at 10.43.04 AM.png

Got it! It was only command enter.

Works amazing.

Well done and thanks a million for the help )))))))))))