Excel Concatenate cell data from column based on criteria in adjacent column

A

Alec

Joined
Feb 3, 2017
Messages
2
Reaction score
0
Hello, I've been fiddling with a udf someone on here designed for a specific question but I can't get it to work for my purposes.

So here is my situation:

Column 1 = Set1 (Values = either "true" or "false")
Column 2 RoutineName (text values)

I want to concatenate into a new cell all the values in column 2 that have a corresponding "true" value in column 1.

Any help on this greatly appreciated!
 
Which version of Excel are you using? If you have Excel 2016 you could use the TEXTJOIN function combined with an IF function to select the data you want.
 
Becky said:
Which version of Excel are you using? If you have Excel 2016 you could use the TEXTJOIN function combined with an IF function to select the data you want.
Click to expand...
ah...of course....no Im using Excel 2007
 
Back
Top