Concatenate based on other cell data

[nur2544]

Dear all,
I am having some data in the CELL range A&B which I use as input data and after processing by macro I want to get the result as output in the range D&E.

Please Login or Register  to view this content.

Here CELL A & CELL B is my input data from this I want to get the results (output) as CELL D and CELL E
Here CELL E will be concatenate value of CELL B

Please Login or Register  to view this content.

I would use an UDF to perform my activity but it makes my excel halt , I need help to solve my issue by macro or excel formula except UDF. I have attached my excel sheet for better understanding.

[PaulM100]

You can use a UDF Concat Function and Unique items formula:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

UDF Concat funtion form:

Please Login or Register  to view this content.

EDIT: Forgot to read everything, The UDF part

[Special-K]

I think there's a function that will do this with the MOREFUNC plugin or there's TEXTJOIN if you have Office 365 otherwise it's got to be a macro/UDF.

[MickG]

Try :-

Please Login or Register  to view this content.

Regards Mick

[nur2544]

Hi Mick , your code is working great! It filled my requirements, I appreciated it, it will save my time , thanks for helping me.

[nur2544]

Hi PaulM100, your code is working great! It filled my requirements, I appreciated it, it will save my time , thanks for helping me.

[PaulM100]

Is not my thread, but Mick's code does not work entirely. If you add more data, even if is the same ID, it will create a new line instead of concatenating the values.

Capture.JPG

[MickG]

nur2544:- You're welcome

PaulM100:- The code below will work on your modified data format:-

Please Login or Register  to view this content.

Regards Mick

[nur2544]

Hi PaulM100 , you have written code for helping me , I really appreciated your nice job But earlier I used UDF (I already mention that in my post above) that makes my excel slowness, even some time my whole excel program would gone to halted. What is why I was not interested in UDF. I was disappointed to see your UDF once again although it was working nice. But I was given reputation both of you at the same time.
However, I agree that it was your thread but it was my mistake that not to replay you first, I am sorry for that. I am also agree with you that if I add same id then Mick’s code giving additional id which suppose not to come . this mismatch I didn’t notice that time. Thanks for understanding me.
@ PaulM100 & Mick , I need both of your help to solve my issue.

[nur2544]

Hi MickG , Now it works perfectly , thanks once again.

[nur2544]

Hi Special-K , thanks for your nice idea.