Hi,
I have a spreadsheet that contains survey responses about meetings. Each completed survey form from Survey Monkey is represented in a row in sheet Responses. There are multiple meetings and multiple responses per meeting. Responses!B2:B1000 contains an integer identifying the meeting (e.g. 4 indicates "Mike's talk on image sharpness") and Responses!H2:H1000 contains optional comments on that meeting. I want to list all the comments about a particular meeting in a cell. I thought that this array formula (e.g. with $A$5 = 7 for meeting 7) would do it:
{=TEXTJOIN(CHAR(10),TRUE,IF(Responses!B2:B1000=$A$5,Responses!H2:H1000,""))}
But it doesn't: I get a #VALUE! error. However this array formula (removing the IF conditional expression so comments about EVERY meeting are included) works:
{=TEXTJOIN(CHAR(10),TRUE,IF(TRUE,Responses!H2:H1000,""))}
I don't understand what's wrong with the test. Can anyone tell me how to make this work?
TEXTJOIN isn't included in my Office 2016 so I added it via a User Defined Function as suggested by mehmetcik in topic #1272684 "TEXTJOIN missing from MS Office Home and Student 2016 " above.
Thanks,
Mike
Bookmarks