The Excel Dynamic Array FILTER function filters a range of data based on the supplied criteria, and extracts matching records. It’s a huge improvement over the legacy filter features in that the filtered results are displayed in a different range than the original data and the variety input data to result in the filter criteria.