FILTER.SORTED function

Filter.Sorted filters out subsets of sorted data using multiple extended conditions.

FILTER.SORTED is a simpler way of using FILTER.IFS when the first criteria is sorted.

FILTER.SORTED Syntax

FILTER.SORTED(InputRange,ReturnCol,CriteriaColumn1,Criteria1,
CriteriaColumn2,Criteria2, …, ["#OR#", nsortedCols,] CriteriaColumnx, Criteriax, …)

See FILTER.IFS for definitions of the parameters for FILTER.SORTED

Copyright © 2023 Decision Models Ltd