X
Excel Zero to Hero Interactive Learning Platform
0%
dynamic-array

FILTER Function

intermediate Excel 365

FILTER Function

🎯Purpose

Filters an array or range based on a Boolean criteria array and spills the matching results into neighboring cells.

Syntax

EXCEL 
=FILTER(array, include, [if_empty])

Example

EXCEL 
=FILTER(CallData, CallData[Satisfaction rating] = 5, "No 5-star calls")
← Back to Formula Library