FILTER

FILTER is a helper function that can be used as a parameter of the EXTRACTPROPERTIESBYFILTER and FINDKEYSBYFILTER functions. For example, to return a specific property from an XML variable you can use EXTRACTPROPERTIESBYFILTER, in which the filter is supplied by the FILTER function. Or, or you can use EXTRACTPROPERTIES, in which the filter forms part of the function.

You can use Boolean functions to combine multiple FILTER functions and so create complex filters. If you use a FILTER function in a cell, it returns #VALUE!.

The arguments of the FILTER function are Key, Property, and Value. They fulfil the same purpose as the second, third, and fourth arguments of EXTRACTPROPERTIES and FINDKEYS functions.

Syntax

=FILTER("Key","Property","Value")