Search code examples
excelexcel-formulaoffice365dynamic-arrays

Consolidate (Append) two dynamic array formulas in excel

How to combine two dynamic array formula (like filter functions) one below another?

=FILTER(A5:B14,A5:A14>5)
=FILTER(Sheet2!A5:B14,Sheet2!A5:A14>8)

I want the results to come one below another irrespective of number of rows picked up. Is it possible ?

Solution

  • Recently Office365 introduced two functions HSTACK and VSTACK. We can use VSTACK function for this requirement.

     =VSTACK(FILTER(A5:B14,A5:A14>5),FILTER(Sheet2!A5:B14,Sheet2!A5:A14>8))