Forum Discussion

ar620360's avatar
ar620360
Copper Contributor
Jan 02, 2023

FILTER function on Excel for Mac

Hi, I have the desktop app Microsoft Excel for Mac with Microsoft 365. According to the Microsoft website for the FILTER function, I should be able to use this function with my current license; howe...
Excel on Mac
Formulas and Functions
ar620360's avatar
ar620360
Copper Contributor
Jan 02, 2023

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

 

 

 

mathetes's avatar
mathetes
Gold Contributor
Jan 02, 2023

ar620360 

 

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.

  • ffx855's avatar
    ffx855
    Copper Contributor
    Jul 29, 2024

    mathetes I have the same issue. Filter function is not listed as available. I have performed the suggested steps loging off and re-starting and still didn't work.

    Excel Version 16.87 (24071426)

    • mathetes's avatar
      mathetes
      Gold Contributor
      Jul 29, 2024
      As noted above, if that doesn't work, I'm out of ideas.

Resources