Forum Discussion

IwoMysiak's avatar
IwoMysiak
Copper Contributor
Aug 05, 2020
Solved

Excel Filter function not working in M365

Hello, i have bought Microsoft Family 365 monthly subscription, because i needed =FILTER function, logged in, updated everything, and still THERE IS NO =FILTER() function, only =filterxml(). How do i...
excel
  • IngeborgHawighorst's avatar
    IngeborgHawighorst
    Aug 06, 2020

    Abiola1 Dynamic Arrays are very much in Microsoft 365 Family. I have been running this for a while.

     

    IwoMysiak Try restarting your computer. When you activate a new license, it may take a while for all features to arrive if you already have an existing installation of Excel.

     

    Restarting Excel should be sufficient, but restarting the computer will be better.

     

     

IngeborgHawighorst's avatar
IngeborgHawighorst
MVP
Aug 06, 2020

Abiola1 Dynamic Arrays are very much in Microsoft 365 Family. I have been running this for a while.

 

IwoMysiak Try restarting your computer. When you activate a new license, it may take a while for all features to arrive if you already have an existing installation of Excel.

 

Restarting Excel should be sufficient, but restarting the computer will be better.

 

 

JoeMcDaid's avatar
JoeMcDaid
Icon for Microsoft rankMicrosoft
Aug 06, 2020

IngeborgHawighorst Spot on. Dynamic Arrays and the supporting function are available to all subscription users. 

  • Abiola1's avatar
    Abiola1
    MVP
    Aug 06, 2020
    I think there is need for more clarify so that user's will understand the features and functions in Microsoft 365 Family, Personal, Enterprise etc. Because all this can be very confusing to understand

Resources