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

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!
 

Becky

Webmistress
Joined
Mar 25, 2003
Messages
7,424
Reaction score
1,511
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.
 
Joined
Feb 3, 2017
Messages
2
Reaction score
0
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top