Forum Discussion
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?
- Use TEXTJOIN() function like =TEXTJOIN(", ",TRUE,IF(B1:B10=TRUE,A1:A10,""))
Or =TEXTJOIN(", ",TRUE,FILTER(A1:A10,B1:B10=TRUE))
