Google Sheets - How to concatenate values from different rows and columns if the cells meet certain-CodePudding

Home > Blockchain > Google Sheets - How to concatenate values from different rows and columns if the cells meet certain

Google Sheets - How to concatenate values from different rows and columns if the cells meet certain

Time：11-25

I am trying to create a formula that concatenates cell values if the ticked box is TRUE Please see attached image

CodePudding user response：

You can try this sheet formula first.

=IF(A4="","",IF(A4=TRUE,TEXTJOIN(",",True,B4,C4),""))

This formula has nested IF's just for additional checker to check if the first column has a value and would return blank just for it to be dynamic. You can drag the formula down to adjust the cells.

Sheet sample:

Page link：https//www.codepudding.com/Blockchain/204058.html

Prev:Get Cell Drop Box - not just values

Next:How to query count of unique features in google sheets?

Tags：

google-sheets

concatenation

google-sheets-formula

Links：
CodePudding