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
 

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

Similar Threads

Excel Concatenate with line breaks but ignore blank cells 3
Excel VBA 1
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Excel VBA to move cells to sheet2 based on selection in sheet1 0
Excel Add 60 days to column 1 or column 2 based on whether column 2 has data 1
Trying to run excel vba code when cell value changes from empty to entered value. 1
Excel Applying Code to a Column 0
Excel [VBA] Check from a cell into another sheet and bring back result in MsgBox 0

Back
Top