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...

excel

Excel on Mac

Formulas and Functions

HansVogelaar
Jan 25, 2023
alex2476

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.