Forum Discussion

Copper Contributor

May 31, 2021

Solved

Text Join - Return Unique Values Only

Hello, I have a textjoin field that looks up a field in a column and matches it to a static field. Example, if Column B contains any instances of the word RED then return the values in Column C. Th...

excel

HansVogelaar
May 31, 2021
Mossad076

Press Alt+F11 to activate the Visual Basic Editor.

Select Insert > Module.

Copy/paste the code from my previous reply into the new module.

Switch back to Excel.

Create the following formula for column C:

=ConcatenateIf($B$2:$B$48,$P$1,C$2:C$48,", ")

This can be filled or copied to the right for columns D, E, etc.

Save the workbook as a macro-enabled workbook (*.xlsm)

Make sure that you allow macros when you open it.

Mossad076

Copper Contributor

May 31, 2021

Thanks so much, however, now you are getting very complex for me haha. I setup "Developer tab". Would you mind telling me what steps in VBA to create a file? I'll then copy and paste this. Also, since we are going into this, the C2:C48 is just one column, i also need to return answers for D to M. They should each return their own answer. So column C returns answers in a cell, D in a different cell, etc.

I hate to ask and really do appreciate it all!

HansVogelaar

MVP

May 31, 2021

Mossad076

Press Alt+F11 to activate the Visual Basic Editor.

Select Insert > Module.

Copy/paste the code from my previous reply into the new module.

Switch back to Excel.

Create the following formula for column C:

=ConcatenateIf($B$2:$B$48,$P$1,C$2:C$48,", ")

This can be filled or copied to the right for columns D, E, etc.

Save the workbook as a macro-enabled workbook (*.xlsm)