|
FILTER.MATCH function
FILTER.MATCH returns pairs of numbers (1-based relative position and number of rows) for each contiguous block of rows that meet the criteria.
FILTER.MATCH should be entered as a 2-column multi-row array formula, using Ctrl-Shift-Enter.
The first column contains the relative position (first row is 1) within the InputRange of the first row in the block that meets all the criteria. The second column contains the number of rows in the contiguous block.
The number of pairs returned by FILTER.MATCH is dependent on the data and the criteria being used.
The number pairs can be used by OFFSET to return the block of rows.
FILTER.MATCH Syntax
FILTER.MATCH(nsortedCols, InputRange, CriteriaColumn1, Criteria1,
CriteriaColumn2, Criteria2, …, ["#OR#", nsortedCols,] CriteriaColumnx, Criteriax, …)
See FILTER.IFS for definitions of the parameters for FILTER.MATCH
FILTER.MATCH Example
.png)
|
