FILTER function

Category: Lookup and reference
Introduced: Excel 2021

Summary

Filters a range of data based on criteria you define

Syntax

FILTER(A5:D20,C5:C20=H2,"")

Example

=FILTER(A5:D20,(C5:C20=H1)*(A5:A20=H2),"").
=SORT(FILTER(A5:D20,(C5:C20=H1)*(A5:A20=H2),""),4,-1)
=SORT(FILTER(A5:D20,(C5:C20=H1)+(A5:A20=H2),""),4,-1).

Microsoft Support Page

https://support.microsoft.com/en-us/office/filter-function-f4f7cb66-82eb-4767-8f7c-4877ad80c759

Back to Functions