Excel Dynamic Array Functions: How to Use the
One in our series on dynamic array functions. Show how to use the hashtag cell reference with dynamic array functions. Simplify your nested array formulas. More concise and easy to read. Examples include: FILTER with SORT and UNIQUE and MAP with REDUCE. The last two are LAMBDA helpers. You can get my practice file here: https://1drv.ms/x/s!ApJhDBkcRuUOoCcWw....