Dynamic arrays

Excel FILTER Function With Multiple Criteria, Sorted With SORT and SORTBY

Filter Excel data on several conditions with FILTER, keep only the columns you need, and sort the result with SORT and SORTBY, with fixes for #CALC!, #SPILL! and #VALUE!.