FUNCTION CATALOGUE / LOOKUP & REFERENCE
FILTER Excel function
Returns rows or columns that meet criteria.
Correct sentence to use
Return rows from [array] where [condition] is true.
Modify this query in PlainFormula →Example formula
=FILTER(A2:D100,B2:B100="London")
Returns matching records as a dynamic array.
Syntax
FILTER(array, include, [if_empty])
Argument signature: array, include, [if_empty]
Availability note
Available in supported Microsoft 365 / newer Excel versions; verify the exact release and platform.