FilterArray

Description of formula:
FILTERARRAY function returns an array of values for which the given condition is met.

Syntax:
FILTERARRAY(check_array, condition)

Parameters:
check_array(type: array of values)

Values for which the condition will be check

condition(type:Text)

A logical expression that specifies which items to return. Use the 'value' keyword to refer to the item being checked.

Returned type:

Array of values

Examples:
=filterarray(array('example', 'test', 'array'),value='test')
=filterarray(secion1.A1:A3,value='test')

=filterarray(secion1.A1:A3,value='section1.B1')