Forum Discussion
alex2476
Jan 25, 2023Copper Contributor
Excel windows and mac.
I have a workbook with this formula in one of the cells im on a Windows computer:
=TEXTJOIN(", ",TRUE,FILTER($B$27:$B$60,ISNUMBER(SEARCH(", "&B62&", ",", "&$R$27:$R$60&", ")),""))
I need to send this file to colleagues for them to complete it. Half of the team is mac the other pc. when they save on their macbook then send it back. the formula is now:
=_2__xlfn.TEXTJOIN(", ",TRUE,_1__xlfn._xlws.FILTER($B$27:$B$60,ISNUMBER(SEARCH(", "&B62&", ",", "&$R$27:$R$60&", ")),""))
I dont know why this happens. If anyone has a clue it would be appreciated.
Thanks
It depends on the version of Excel the users have.
TEXTJOIN is available in Excel in Microsoft 365, Office 2021 and Office 2019, but not in Office 2016 and earlier versions.
FILTER is available in Excel in Microsoft 365 and Office 2021, but not in Office 2019 and earlier versions.
It depends on the version of Excel the users have.
TEXTJOIN is available in Excel in Microsoft 365, Office 2021 and Office 2019, but not in Office 2016 and earlier versions.
FILTER is available in Excel in Microsoft 365 and Office 2021, but not in Office 2019 and earlier versions.
- alex2476Copper ContributorThanks Hans!