Error Using TEXTJOIN Function in Array Formula to List Non-empty Strings

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

CK76,

It working for you makes me think I've made some "dumb" error but I just spent a little time rechecking and I can't see it.

I've attached the worksheet. The cell I'm using is A8 in sheet "Meeting Comments new". My goal is to replace sheet "Meeting Comments" in which I created a lot of individual cell references manually to achieve the effect I want.

Thanks for looking at this.

Mike

Jacc and CK76,

Thanks for taking the time to look into this.

It looks right now like I'm stuck because I need more than 255 rows.

Does anyone else have any ideas on how to get past this problem? Is there something to change in the TEXTJOIN Function?

Or, is there a different approach I should try?

Thanks,
Mike

Hmm, I think you can do it in two stages. First extract list of responses that meet condition into some range. Then use that range as source for your textjoin range.