Forum Discussion

Copper Contributor

Jul 22, 2022

Concatenate every cell in a colum with condition

Hi, I need to concatenate the text of every cell that is true to a condition. Anyone managed this?

Formulas and Functions

Bronze Contributor

Jul 22, 2022

Use TEXTJOIN() function like =TEXTJOIN(", ",TRUE,IF(B1:B10=TRUE,A1:A10,""))

Or =TEXTJOIN(", ",TRUE,FILTER(A1:A10,B1:B10=TRUE))

Resources