FILTER practice

What you will practise

A six-row condition chooses which complete records spill into the report. Original records remain untouched.

FILTER(array, include, [if_empty])

The syntax above is a guide. Read the data and each task to choose the right arguments for your formula.

Original formula and spill examples

These examples use the original practice data. Fresh data changes the source; follow the current task. Enter one formula at the anchor. The workbook derives the entire spill without overwriting the source.

Exercise 1 · anchor D2

=FILTER(A2:C7,B2:B7="Studio")

Expected spill D2:F4 · 3 rows × 3 columns.

Exercise 2 · anchor D2

=FILTER(A2:C7,C2:C7>=10)

Expected spill D2:F4 · 3 rows × 3 columns.

Exercise 3 · anchor D2

=FILTER(A2:C7,(B2:B7="Studio")*(C2:C7>=7),"No matching orders")

Expected spill D2:F2 · 1 row × 3 columns.

3 exercises in this lesson

1. Exercise 1 · answer in D2

   In D2, use FILTER to return all three columns of Studio records from A2:C7, in source order.

2. Exercise 2 · answer in D2

   In D2, use FILTER to return complete records from A2:C7 with Units greater than or equal to 10. Preserve source order.

3. Exercise 3 · answer in D2

   In D2, use FILTER to return Studio records from A2:C7 with Units at least 7. Combine both conditions and return "No matching orders" when none qualify.

Before you check your answer

• Write one anchor formula. Enter the formula in D2. Every derived spill cell is read-only and points back to that same editor. Keep the source intact.
• Check the whole shape. Inspect every row and column of the result, including repeated records, order, text casing and padding. A matching first cell alone is not enough.
• Recover a blocked spill. A #SPILL! error identifies an occupied cell or the worksheet edge. Correct the formula to fit the requested shape; keep immutable source notes. View source and View spill help you inspect both areas.

How the answer is checked

The workbook checks every row and column, the complete dimensions, each typed value and the spill placement. It requires the taught function to execute and tests reusable formulas against changed trusted source data. Fixed results, a function in an unused branch, edited source or submitted derived cells cannot earn completion. Equivalent reusable formulas can pass. Account progress is saved only after the server verifies the same task and access rules.

Use progressive hints when you need help, then try the task again with fresh data. Correctly solving a step opens the next exercise.