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

[Alec]

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!

 

[Becky]

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.

 

[Alec]

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.

ah...of course....no Im using Excel 2007