FILTER formula

Copper Contributor
Is there a way to enable FILTER formula in previous versions of Excel? Thank you!
1 Reply

@PaoxDiiO365 

This is what MS says about it:

Note: This function is currently available to Microsoft 365 subscribers in Current Channel. It will be available to Microsoft 365 subscribers in Semi-Annual Enterprise Channel starting in July 2020. For more information on how features are rolled out to Microsoft 365 subscribers, see When do I get the newest features in for Microsoft 365.

 

So, if you are not an MS365 subscriber, you will not be able to use FILTER.