What is FILTER called in Spanish?

It has the same name: FILTER. Functions that started in Google Sheets keep their English name even in a Spanish spreadsheet. What changes is the separator: Spain and much of Latin America separate arguments with semicolons.

Why does FILTER use semicolons in some spreadsheets?

It depends on each spreadsheet's locale, under File > Settings. Where the comma is the decimal mark (Spain, much of South America), arguments are separated by semicolons. Mexico and United States locales use commas.

Google Sheets FILTER function

Returns only the rows that meet the conditions and spills them downward. It has the same name in Spanish Sheets.

Syntax

English Sheets

=FILTER(range, condition1, [condition2], …)

Spanish Sheets (Mexico locale)

=FILTER(intervalo, condición1, [condición2], …)

Spanish Sheets (Spain, Latin America)

=FILTER(intervalo; condición1; [condición2]; …)

Argument	What it is
range	The data to filter, without headers.
condition1	A column of conditions the same height, like B2:B11="CDMX".
condition2optional	More conditions; all must hold.

Example

FILTER(range, condition) returns only the rows that meet the condition and spills them downward. The condition compares a whole column, like B2:B11="CDMX". When the data changes, the result updates.

=FILTER(A2:D11,B2:B11="Monterrey")

Common mistake

If nothing matches it returns #N/A; wrap it in IFERROR. For "either one", add the conditions: (A2:A10="X")+(A2:A10="Y").

About Ads

This site uses Google AdSense to display ads. These ads help us keep WebHerramientas completely free. Ads are managed by Google and meet strict security and privacy standards.

Practice FILTER

Type the formula in the sheet and check it instantly. Spanish or English function names both work. See all lessons

Your progress0/59

My spreadsheet is inGoogle Sheets functions in English and Spanish

FILTER

FILTER(range, condition) returns only the rows that meet the condition and spills them downward. The condition compares a whole column, like B2:B11="CDMX". When the data changes, the result updates.

Example=FILTER(A2:D11,B2:B11="CDMX")FILTER: same name in Spanish

In F2, show the full rows of the orders from Monterrey.

	A	B	C	D	F
1	Order	City	Seller	Amount	Orders from Monterrey
2	P-101	Monterrey	Carmen	1200
3	P-102	Guadalajara	Jorge	850
4	P-103	CDMX	Carmen	2300
5	P-104	Monterrey	Lucía	640
6	P-105	CDMX	Jorge	1750
7	P-106	Guadalajara	Lucía	980
8	P-107	Monterrey	Jorge	1500
9	P-108	CDMX	Lucía	410
10	P-109	Guadalajara	Carmen	1320
11	P-110	Monterrey	Carmen	760
12

The dotted outline shows how far the result should spill.

Frequently asked questions

What is FILTER called in Spanish?: It has the same name: FILTER. Functions that started in Google Sheets keep their English name even in a Spanish spreadsheet. What changes is the separator: Spain and much of Latin America separate arguments with semicolons.
Why does FILTER use semicolons in some spreadsheets?: It depends on each spreadsheet's locale, under File > Settings. Where the comma is the decimal mark (Spain, much of South America), arguments are separated by semicolons. Mexico and United States locales use commas.
What is the most common FILTER mistake?: If nothing matches it returns #N/A; wrap it in IFERROR. For "either one", add the conditions: (A2:A10="X")+(A2:A10="Y").