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 (Text)
Values for which the condition will be check
condition (Text)
A logical expression that specifies which items to return. Use the 'value' keyword to refer to the item being checked.
Returned type:
Text
Examples:
=filterarray(array('example', 'test', 'array'),value='test')
=filterarray(secion1.A1:A3,value='test')
=filterarray(secion1.A1:A3,value='section1.B1')
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk