Forum Discussion
Excel SORT() and FILTER() functions are missing
I'm not sure exactly what triggered it, but found FILTER(), SORT() and UNIQUE() to be working in Excel this morning, after signing up as described.
HOWEVER, there's one caveat.
In Google Sheets, where I first discovered FILTER(), I'm able to apply multiple array filters in the form:
= FILTER (A1:A10, A1:A10>0, B1:B10>5, C1:C10>10)
It looks as those Excel's equivalent can filter by one array only. Is that correct?
Sorry, I don't know what's the reason. I'd suggest to send s frown.
SergeiBaklan I have updated Excel to version 16.41.2008190 and it indicates that it's up to date.
To my knowledge deployment is finished at the beginning of August, dynamic arrays shall be available now for all subscription levels on all platforms. Please try to update Office. If won't help send a frown.
SergeiBaklan I just bought Microsoft 365 for Mac with Insider Fast and the Filter function is still not available. It says that it will be available to Microsoft 365 subscribers in Semi-Annual Enterprise Channel starting in July 2020.
When do I get this?
simondavidmiller , you are welcome
Works! Thank you.
