Excel FunctionsLesson 83Free preview

FILTER

This lesson is part of Excel · All levels

Summary

A FILTER is a dynamic Excel function that displays some of the rows of a range based on a certain criterion and the result spreads (spill) to several cells. The syntax is. This function is available in Excel 365 and Excel 2021 above.

Key points

Syntax: FILTER(array, include, [if_empty])
The result is a dynamic array that extends into the empty cell next to it.
The logical conditions are combined with * for AND and + for OR
The if_empty argument displays a message if there is no matching data

Full lesson

Code examples and quizzes

Full lessons, code examples, and quizzes are available to subscribers. 5 questions.