Embedded Files
Description
Description
FilterContainsλ() applies a function by column to a Values array filtered by a Labels array containing specified text
Syntax
Syntax
FilterContainsλ( ValuesToFilter, ValueLabels, FilterByText, [IgnoreCase?])
Arguments
Arguments
ValuesToFilter
(Required) An array of values to be filtered
ValueLabels
(Required) An array containing the values' labels
FilterByText
(Required) A unique letter, word or phrase to find contained in ValueLabels
IgnoreCase?
(Optional) A flag to determine if Text's case is important. Default is TRUE
Example
Example
In this example we are filtering all the values in the depreciation schedule array where the word "Depreciation" is found in the labels array.
Page updated
Google Sites
Report abuse