Concatenate with Multiple Criteria

[mahesh8498]

Hello,

I have Data in Column A & B. Colum A consists Ticket Numbers & Column B Consists Remarks entered for Ticket Numbers. Each every ticket has Multiple remarks. In C Column I copy all Unique Ticket numbers mentioned in Column A. And in D column I need all remarks mentioned for each ticket.

Please find below example

Ticket Number Remark

123 Mach Down

123 Tested OK

123 Mach Up and working

Now In D Column I want result as Mach Down, Tsted OK, Mach Up and working

I have multiple ticket and Remarks are also multiple

[oeldere]

You get better help if you post an example of your excel file, without confidentional information.

If you also added in the file, the wanted result, it would be great.

[mahesh8498]

I have attached the Sample sheet

[oeldere]

I've seen written (VBA) code for this problem on this forum.

I can't help you enough with your problem.

[duanzhuanming]

hi,
if you want to use VBA. See attached file below.
syntax: Concatenatex(Look_up,Array)