The FILTER Function in Excel The FILTER function of Excel returns all the rows corresponding to a specific criteria. It's possible because of the Dynamic Arrays of Microsoft 365