TEXTJOIN and CONCAT

[anthx]

Hi, I have made an Excel function to return all matching results from a column and separate them by a bullet point and two return lines. Is there a way to update the Excel function to not include a bullet point if there is only one returned value from the TEXTJOIN? I know I have the CONCAT a bullet point at the start of the function which would need to be moved, but I can't figure out how to update/order the function to accomplish this, if possible.

I've included a screenshot of my workbook and pasted the current function from the screenshot here. Any help is appreciated.

=CONCAT(CHAR(149)&" ",TEXTJOIN(CHAR(10)&CHAR(10)&CHAR(149)&" ",TRUE,FILTER(I3:I7,G3:G7=L3,"#N/A")))

 

[Fluff]

How about

=LET(a,FILTER(I3:I7,G3:G7=L3,"#N/A"),IF(ROWS(a)>1,CHAR(149)&" ","")&TEXTJOIN(CHAR(10)&CHAR(10)&CHAR(149)&" ",,a))

 

[anthx]

How about

=LET(a,FILTER(I3:I7,G3:G7=L3,"#N/A"),IF(ROWS(a)>1,CHAR(149)&" ","")&TEXTJOIN(CHAR(10)&CHAR(10)&CHAR(149)&" ",,a))

Yes, this worked perfectly! Thank you for the quick answer and solution

 

[Fluff]

You're welcome & thanks for the feedback.