Google Sheets reference

FILTER in Google Sheets

Minor differences1 worked example

Worked examples (1)

These formulas work in Google Sheets with the differences noted above.

Array Formulasintermediate

=FILTER(A2:C100,B2:B100="East","No results")

Also in Excel

See the full FILTER reference for Excel — including all worked examples, common errors, and FAQ.