Home › FILTER

FILTER in every language

Lookup and referenceMicrosoft 365Last verified 2026-11-04

LanguageNameSyntaxLibreOfficeSheets
EnglishFILTERFILTER(array, include, [if_empty])——
GermanFILTERFILTER(Matrix; einschließen; [wenn_leer])FILTERNFILTER
FrenchFILTREFILTRE(tableau; inclure; [si_vide])FILTREFILTER
SpanishFILTRARFILTRAR(matriz; incluir; [si_vacío])FILTRARFILTER
Portuguese (Brazil)FILTROFILTRO(matriz; incluir; [se_vazio])FILTROFILTER
DutchFILTERFILTER(matrix; opnemen; [als_leeg])FILTERFILTER
ItalianFILTROFILTRO(matrice; includi; [se_vuoto])FILTROFILTER

Names and arguments from Microsoft Support; the LibreOffice and Google Sheets columns are those products' own localized names. Array-constant separators and localized error values are not yet covered.

Translate a formula with FILTER