FILTER in Excel & Google Sheets
Returns every row of a range that meets a condition, and spills the results into the cells below. Updates live when the data changes.
Syntax
=FILTER(array, include, [if_empty]) Example: Orders over 100
=FILTER(A2:C20, C2:C20>100, "None") =FILTRAR(A2:C20; C2:C20>100; "None") Returns every row where the amount in column C is greater than 100.
FILTER in Spanish
In Spanish Excel and Google Sheets, FILTER is called FILTRAR. It's the same function: files translate automatically when opened in another language. When you type it by hand, the name and the argument separator change.
| English | Spanish | |
|---|---|---|
| Function | FILTER | FILTRAR |
| Separator | , | ; |
| Example | =FILTER(A2:C20, C2:C20>100, "None") | =FILTRAR(A2:C20; C2:C20>100; "None") |
The separator depends on regional settings: Spanish versions usually use semicolons, but countries with a decimal point (like Mexico) may use commas.
Translate another formulaArguments
FILTER FAQ
What is FILTER in Spanish?
In Spanish, FILTER is FILTRAR. When you type it by hand in a Spanish Excel, arguments are usually separated by semicolons (;): =FILTRAR(A2:C20; C2:C20>100; "None")
Does FILTER work in Google Sheets?
Yes. FILTER works in Google Sheets with the same syntax as in Excel. In a sheet set to Spanish it's called FILTRAR. The separator (comma or semicolon) follows the sheet's locale, under File → Settings.