Forum Discussion
Combining text from a large(ish) survey using a search
I have a spreadsheet created from a Form in O365 to help with judging a competition.
It has a column for group number, and another column further along for comments.
Each group will be judged con...
Hi Richard,
That could be array formula (Ctrl+Shift+Enter) like
=TEXTJOIN(",",TRUE,IF(E2:E100=1,I2:I100,""))
for the Group #1 and assuming your groups are in column E, texts in column I
Hi Sergei
Thanks for the speedy reply! I too had tried something like that. Unfortunately it seems to take all the comments in the (in your example) I-column, not just the ones about group 1.