The FILTRE (FILTER), UNIQUE, TRIER (SORT) and TRIERPAR (SORTBY) functions are dynamic array functions. FILTRE extracts the rows that meet a condition, UNIQUE removes duplicates, TRIER and TRIERPAR sort the results. They can be combined and recalculate with the data.
Example
=TRIER(UNIQUE(FILTRE(A2:A100;B2:B100>1000)))