Concatenate every cell in a colum with condition

Occasional Visitor

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

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

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