Replace FILTER function for use on older versions of Excel

[jbarrick007]

So I have an extensive file, which after all the work realized I was using new functions.

I know how to redo the TEXTJOIN using CONCATENATE. But what about the FILTER, are there option I have for replacing this modern function? Ideally I need to make this work on excel 2010, but I can live with 2019.

Current Formula:
=IF(ISNUMBER(FIND(".",A5)),TEXTJOIN(CHAR(10),TRUE,"#"&TEXT([@[Workflow '# ]],"#0.00")&" "&[@[Milestone Name ]]," - Duration: "&(TEXT([@Start],"m/d/yy"))&" ("&[@Duration]&")",FILTER(I5:I$1000,(LEFT(B5:B$1000,LEN(A5)+1)=A5&".")*ISNUMBER(SEARCH("x",BE5:BE$1000))," • No Assigned Tasks")),"")

Returns Result:

#1.02 | INFORM INVESTIGATION - Duration: 5/19/20 (1 wk) • Send investigation meeting assignment (FRINV) to BFR through ACU • Send FRINV assignment to FRP through ACU and notify oversight

I apologize for some reason my XL2Bb has stopped working.

 

[Fluff]

Duplicate Backwards compatibility for excel 2010. Replacing TEXTJOIN with CONCATENATE

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).