Forum Discussion

Copper Contributor

May 17, 2023

Solved

=FILTER() function returns #NAME error on Mac

Hi, thank you in advance for your help. We have a Mac user with Excel 16.73 via Office 365. He's not able to use our company workbook which leverages the FILTER() function. I believe it should w...

excel

Excel on Mac

Formulas and Functions

RowdieMcD
May 19, 2023
mathetes Thank you!

In our case the user was signed in with a different Microsoft account, not the Office 365 account. We found out by clicking "Find your Office Version" in the error message help.

mathetes

Silver Contributor

May 19, 2023

RowdieMcD

There've been a lot of views, no replies. As another Mac User with Excel l16.73 and Office 365, an avid user of FILTER and some of the other newer functions and capabilities, I too am puzzled.

Is your user able to create formulas from scratch using any of the several Dynamic Array functions?

One could also go through the tried and true methods of uninstall and re-install........

RowdieMcD

Copper Contributor

May 19, 2023

mathetes Thank you!

In our case the user was signed in with a different Microsoft account, not the Office 365 account. We found out by clicking "Find your Office Version" in the error message help.