New answers tagged


You can first FILTER your range so that you're just left with the rows that you want. This would look like this =FILTER(C2:D6, C2:C6 = 1). Then you'd need to somehow join the values in cells you've filtered. You could use TEXTJOIN for this =TEXTJOIN(",", TRUE, TO_TEXT(F6), TO_TEXT(F7)). I have cells from column F in my TEXTJOIN because that is ...

Top 50 recent answers are included