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