Forum Discussion
Solved
Return multiple strings to a single cell based on conditional criteria
Hello, I am trying to create a column that returns strings from multiple columns to a single cell, based on an associated condition from yet another set of columns. Apologies if my language is no...
In I2, if the TRUE values in columns E to G are 'real' TRUE/FALSE values:
=TEXTJOIN(", ", TRUE, FILTER(B2:D2, E2:G2, ""))
If the TRUE values in columns E to G are text values:
=TEXTJOIN(", ", TRUE, FILTER(B2:D2, E2:G2="TRUE", ""))
In I2, if the TRUE values in columns E to G are 'real' TRUE/FALSE values:
=TEXTJOIN(", ", TRUE, FILTER(B2:D2, E2:G2, ""))
If the TRUE values in columns E to G are text values:
=TEXTJOIN(", ", TRUE, FILTER(B2:D2, E2:G2="TRUE", ""))
The first solution worked, amazing!! Thank you for your quick and helpful reply!
