Forum Discussion
IwoMysiak
Aug 05, 2020Copper Contributor
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...
- 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.
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.
Abiola1
Aug 06, 2020MVP
Recently when training a client using the version mentioned, I checked for the DA functions and XLOOKUP but they weren't available! That informed my thinking that DA functions were only available in Beta and Current Channels