Macro for Concatenate the names basis of multiple conditions

**Manish_Gupta** · 09-19-2016, 01:59 AM

Hello Guys,

I need help in creating a one logic in Macro.

The column A and B each cell conatins single or mutiple names of the customers which I want to concatenate in Column C basis of following conditions:

1. If there is a different names in Column A and B then in Column C they will be concatenate with separated by comma.

2. If there is any common name or names is present in Column A and Column B then in Colummn C only that unique name should appear instead of concatenating all names.

For more understanding please refer the attached sample file.

Any help will be appreciated a lot.

Regards,

**jindon** · 09-19-2016, 02:38 AM

Try

Please Login or Register  to view this content.

**millz** · 09-19-2016, 03:42 AM

Another way:

Please Login or Register  to view this content.

Note for jindon's code, if column 3 is not empty, result may have errors. Or you can fix by changing this line

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

Macro for Concatenate the names basis of multiple conditions

LinkBack

Thread Tools

Rate This Thread

Display

Macro for Concatenate the names basis of multiple conditions

Re: Macro for Concatenate the names basis of multiple conditions

Re: Macro for Concatenate the names basis of multiple conditions

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Formula to pick the value between 2 columns basis of different conditions

[SOLVED] Need a Macro to send email from excel through Outlook basis of different conditions

Macro to remove duplicate entries basis of different conditions

Macro to separate, concatenate, and change sheet names

[SOLVED] Ideas for Replacing Names on Monthly Basis

[SOLVED] Need to create a Concatenate formula that displays on a conditional basis

enable/disable start button on basis of chkbox conditions

Bookmarks

Bookmarks

Posting Permissions