How can I use the '=FILTER' function in Excel for Mac?

Copper Contributor

Hi everyone, I'm newbie here.

I have a doubt along with a issue...

Ive purchased the 365v of Office for Mac, cuz Ive read that it includes the "filter" function ermm but I have updated, I've paid the subscription and still it doesn't let me use the function, it doesnt appear in the cells.

I have updated and joined the beta version, I have downloaded the version that asked me to update and it doesntt work for me either :(

Is that error cuz its on a Mac? ithe online web version it works for me, but not in the Mac application.

Captura de Pantalla 2022-03-24 a la(s) 7.47.23 a.m..png

4 Replies

@andresmqv On a Mac myself, also Beta, with all the Dynamic Array functions, including the 14 new ones that were released last week. This is what I see when I click "Excel", "About Microsoft Excel".

Screenshot 2022-03-24 at 14.01.20.png

Which is your version?

Hey @Riny_van_Eekelen, thanks for reaching out!!


Take a look on this: Captura de Pantalla 2022-03-24 a la(s) 10.53.55 a.m..png

I have installed the version 16.60 on my Mac:

Captura de Pantalla 2022-03-24 a la(s) 10.56.26 a.m..png


but, when I open Excel, I found this:


Captura de Pantalla 2022-03-24 a la(s) 10.58.01 a.m..png

So I need help to fix this :(


I dont quite understand why I can't see the license with "Microsoft 365" either when I have paid for the subscription lol. 


I am facing the same issue. Did you find any solution?

Thank you

@andresmqv I have the same issue, even though my profile shows a Microsoft 365 Subscription. Any answers?