Dynamic arrays can be used in combination with Excel functions.
In the dataset of accounts of a store, we can use FILTER() function in conjunction with dynamic array to filter GL Amount > 3000
UNIQUE() in conjunction with dynamic arrays can return unique GL Accounts:
SORT() can be used in conjunction with dynamic array to sort a range based on a column such as GL Account.
UNIQUE() can be used to group GL Account, then AVERAGEIFS() can be used to aggregate GL Amount