Hi Saliha,

I'm not sure I follow your question. Do you want a text string that joins together the different styles in column C? If so, you can use this formula if you have Microsoft 365:

=TEXTJOIN("/",TRUE,UNIQUE(C4:C24))

If you're expecting more item codes, you can insert FILTER like so:

=TEXTJOIN("/",TRUE,UNIQUE(FILTER(C4:C24,D4:D24=I8)))

Mynda

Hi Mynda

I am using 2016 office i used this formula which is you given above but showing error.

Hi Saliha,

You're getting an error because you don't have Microsoft 365. Excel 2016 doesn't have these functions. 

I don't know of an easy way to do this with the formulas available in Excel 2016. There are so many steps required to get to the end result that any formula you build will be extremely complex and likely to run very slowly. e.g. first you need to extract a list of styles that match the item code. Then you need to remove duplicates, then you need to concatenate them with a forward slash delimiter, all the while you don't know how long the list will be or how many delimiters are required.

You could use Advanced Filter to extract the list and then use CONCAT to join the text, but this is still a bit manual. Alternatively, you could post your question in the VBA forum and see if someone is willing to write you some code to do it.

Sorry I'm not more help.

Mynda