Forum Discussion
FILTER function on Excel for Mac
It should indeed be working. I work on a Mac as well (for what it's worth, there is an update to the software, to 16.70, but I'm sure that's not the cause of your difficulties).
I've attached a very simple file, created at another time to illustrate how FILTER could work. If you open it it should function for you.
It may be that you're not using the correct syntax. So here also is a link explaining FILTER more fully; there's also a YouTube video available, which is where I first learned of it.
mathetes, thanks for the reply. I opened the file you created and it still is not working for me (see screenshots below of what I see). I updated my software yesterday, so my Microsoft AutoUpdate window currently shows that Excel is up-to-date at version 16.68. Any clue why it is still not working?
Clicking on the formula for cell G5, before hitting enter to execute the formula.
After hitting "control + shift + enter" to run the array formula.
I tried running the formula myself in cell G9 and get the message that "the function isn't valid".
Any clue why it is still not working?
The one thing I'd suggest--because something similar did happen to me recently with some other services I was supposed to have--I was told I had to go to the menu under Excel, the one at the very top of your screen, and select "Sign Out"
And then close out of Excel, shut down the computer, turn it back on, and sign in again with your user name and password for the 365 Subscription.
If that doesn't work, I'm out of ideas.
