Skip to content

All-Access: every lesson, no ads. $8.25€8.25US$8.25$4.08US$4.08$2.41US$2.41₹224.91MX$74.91 a month, billed yearly. Free to start. Cancel any time

See plans
All-Access, no ads: every lesson, course and template. $8.25€8.25US$8.25$4.08US$4.08$2.41US$2.41₹224.91MX$74.91 a month. + GST at checkoutSee the plans →

Lookup Functionslesson 88 of 95

FILTER Function

0daysLet's get rolling!

Loading the data...

0streak
0 XP today
All Lessons

FILTER Function - Excel Practice Online

This interactive exercise teaches you FILTER Function in Excel through 6 hands-on steps. Instead of watching a video, you type the real formula into a live spreadsheet grid and get instant feedback on every answer. It is part of the Lookup Functions track and works right in your browser - no Excel install and no download. Start free.

Practising FILTER Function this way builds the muscle memory that transfers straight to using Excel at work, in interviews, or for certification prep. Work through the steps above, then keep going with the next lesson to build a complete Excel practice course.

What you'll practice in this FILTER Function lesson

  1. FILTER returns only the rows that match. The second argument is a condition, not a value - it has to say B2:B6="East", not just "East". Spill the East-region names with =FILTER(A2:A6,B2:B6="East"). - array is the names. include is TRUE on every East row. FILTER spills Lee and Chen down from E2. The source table is not filtered in place.
  2. Return the whole row this time — name, region, and sales — for every East region: =FILTER(A2:C6,B2:B6="East"). - The array is now three columns wide, so FILTER spills Lee/East/800 and Chen/East/610 as a block. include still has to be one column, the same height as the array.
  3. Filter on a number. Keep rows where sales are greater than 500: =FILTER(A2:C6,C2:C6>500). - C2:C6>500 is TRUE for 800, 610 and 900. Patel (420) and Ortiz (150) drop out.
  4. AND two conditions by multiplying them. East and sales over 500: =FILTER(A2:C6,(B2:B6="East")*(C2:C6>500)). - TRUE*TRUE becomes 1, anything times FALSE becomes 0. Only Lee (East, 800) and Chen (East, 610) survive. Kim is over 500 but West.
  5. No South rows exist. Avoid #CALC! by passing a fallback: =FILTER(A2:A6,B2:B6="South","None"). - The third argument is if_empty. When nothing matches, FILTER returns that text instead of #CALC!. Always add it on dashboards.
  6. OR uses addition. East or North: =FILTER(A2:C6,(B2:B6="East")+(B2:B6="North")). - TRUE+FALSE is 1, so a row is kept if either condition is true. Lee, Chen, and Ortiz come back. West rows stay out.

FILTER Function practice - FAQ

How do I practice FILTER Function in Excel?

Open this LogicExcel exercise and work through 6 interactive steps. You type the real formula into a live spreadsheet grid and get instant feedback on whether it is correct, plus an explanation. You need no Excel install.

Is the FILTER Function exercise free?

Your first two lessons are free with a free account. After that the pass opens all 95 lessons, the Academy and the accounting course. Lessons you finish stay open.

What will I learn in this FILTER Function lesson?

This lesson covers FILTER Function as part of the Lookup Functions track. You practice the syntax step by step until it becomes muscle memory you can use at work.