What is FILTER called in Spanish?

In Spanish Excel it is FILTRAR. The formula =FILTER(A2:C11,B2:B11=F1) is written =FILTRAR(A2:C11;B2:B11=F1) (or with commas in Mexico).

Why does FILTER use semicolons in some Excel versions?

It depends on regional settings. Where the comma is the decimal mark (Spain, much of South America), Excel separates arguments with semicolons. English Excel and Mexican Spanish Excel use commas.

Excel FILTER function

Returns only the rows that meet a condition; the result spills and updates by itself. In Spanish Excel it is called FILTRAR.

Syntax

English Excel

=FILTER(array, include, [if_empty])

Spanish Excel (Mexico)

=FILTRAR(matriz, incluir, [si_está_vacío])

Spanish Excel (Spain, Latin America)

=FILTRAR(matriz; incluir; [si_está_vacío])

Argument	What it is
array	The range to filter.
include	The per-row condition, such as B2:B100="North".
if_emptyoptional	What to show when nothing matches.

Example

FILTER(range, condition) returns only the rows that meet the condition. The condition compares a whole column with a value, like B2:B11=F1, and is checked row by row.

=FILTER(A2:C11,B2:B11=F1)

Common mistake

For several conditions do not use AND: multiply them, (B2:B100="North")*(C2:C100>5000). With no matches and no third argument it returns #CALC!.

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/94

My Excel is inExcel functions in English and Spanish

FILTER

FILTER(range, condition) returns only the rows that meet the condition. The condition compares a whole column with a value, like B2:B11=F1, and is checked row by row.

Example=FILTER(A2:C11,B2:B11=F1)FILTRAR = FILTER

In E3, show the sales (all three columns) for the region in F1.

	A	B	C	E	F
1	Salesperson	Region	Amount	Region	North
2	Carmen	North	18,500
3	Jorge	South	4,200
4	Lucía	North	3,900
5	Andrés	Central	21,000
6	Paola	South	17,800
7	Ricardo	North	6,400
8	Elena	Central	5,900
9	Mateo	North	19,900
10	Sofía	West	800
11	Diego	Central	4,600
12

Tip: while typing, click a cell or drag across several to insert their reference.

Frequently asked questions

What is FILTER called in Spanish?: In Spanish Excel it is FILTRAR. The formula =FILTER(A2:C11,B2:B11=F1) is written =FILTRAR(A2:C11;B2:B11=F1) (or with commas in Mexico).
Why does FILTER use semicolons in some Excel versions?: It depends on regional settings. Where the comma is the decimal mark (Spain, much of South America), Excel separates arguments with semicolons. English Excel and Mexican Spanish Excel use commas.
What is the most common FILTER mistake?: For several conditions do not use AND: multiply them, (B2:B100="North")*(C2:C100>5000). With no matches and no third argument it returns #CALC!.