FILTER function in Google Sheets - Cheat Sheet & Quick Revision

Recall & Review

beginner

What does the FILTER function do in Google Sheets?

The FILTER function returns only the rows or columns from a range that meet a specific condition or set of conditions.

beginner

Syntax of the FILTER function?

FILTER(range, condition1, [condition2, ...])<br><br>Where range is the data to filter, and condition1, condition2, etc. are logical tests that decide which rows or columns to keep.

beginner

How to filter rows where column A is greater than 10?

Use =FILTER(A1:B10, A1:A10 > 10).<br>This returns rows from A1:B10 where values in column A are more than 10.

intermediate

What happens if no rows meet the FILTER condition?

FILTER returns a #N/A error saying "No matches are found in FILTER evaluation." You can handle this with IFERROR to show a friendly message.

intermediate

Can FILTER use multiple conditions? How?

Yes! You can add multiple conditions separated by commas, which act like AND.<br>Example: =FILTER(A1:C10, A1:A10>5, B1:B10="Yes") filters rows where column A is >5 AND column B equals "Yes".

What does the FILTER function return?

A Only the data rows that meet the condition

B All data regardless of condition

C Only the first row of data

D A sum of all values

FILTER returns only rows or columns that satisfy the given condition(s).

Which is the correct syntax for FILTER?

A FILTER(range)

B FILTER(range, condition1, condition2, ...)

C FILTER(condition1, range)

D FILTER(range, condition1 + condition2)

FILTER requires the range first, then one or more conditions separated by commas.

How do you filter rows where column B equals "Yes"?

A =FILTER(A1:C10, B1:B10="Yes")

B =FILTER(A1:C10, B1:B10>"Yes")

C =FILTER(A1:C10, B1:B10<"Yes")

D =FILTER(A1:C10, B1:B10<>"Yes")

Use the equality condition B1:B10="Yes" to filter rows where column B is exactly "Yes".

What does FILTER return if no data matches the condition?

A The entire range

B An empty cell

C Zero

D #N/A error

FILTER returns a #N/A error with message "No matches are found in FILTER evaluation."

How to apply multiple conditions in FILTER?

A Use semicolons between conditions

B Add conditions with plus signs (+)

C Separate conditions by commas (AND logic)

D Put all conditions inside one string

Multiple conditions are separated by commas and act like AND, meaning all must be true.

Explain how to use the FILTER function to show only rows where sales are above 100.

Think about the range of data and the condition that checks sales values.

Describe what happens when FILTER finds no matching data and how to handle it.

Consider what the user sees and how to show a friendly message instead.