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...
Here's a simplified version of my spreadsheet.
I wwould like the comments for each group to end up in a single cell on the "test of text" sheet. You can see, I have tried various options, but the only one that works is in col. H where I type in the cell references to be used, and I want Excel to search them out!
Hi Richard,
TEXTJOIN works, you entered it as regular, not array formula (column F). https://support.office.com/en-us/article/create-an-array-formula-e43e12e0-afc6-4a12-bc7f-48361075954d
With additional checks the formula is
=TEXTJOIN(" - ",
TRUE,
IF(_56F9DC9755BA473782653E2940F993863[Group number]=$A2,
IF(LEN(_56F9DC9755BA473782653E2940F993863[Evt bemærkninger til PITCH])>0,
_56F9DC9755BA473782653E2940F993863[Evt bemærkninger til PITCH],""),
"")
)
and in column G of the attached file