Description

Arrayλ() is a LAMBDA helper function. Its purpose is to automatically determine if a function should process an array by row or by column based on Arrayλ's position relative to the array. If placed below, Arrayλ assumes we want to process the array by column. If placed in the same row as the array, Arrayλ assumes we want to process by row. 

We can leverage Arrayλ to make commonly used functions more intuitive when applied to dynamic arrays. 5g functions that leverage Arrayλ are: SumAλ, AndAλ, OrAλ, AvgAλ, MinAλ, and MaxAλ. 

I suspect my LAMBDA creator friends will point out that BYCOL and BYROW, especially the eta reduced versions of these functions, are relatively trivial to use in achieving the same result. While very true for those of us familiar with LAMBDA, 5g is about making Excel as easy to use as possible for any Excel user, especially those starting out with dynamic arrays, and so, 5g takes every opportunity, no matter how small, to make their work easier and more robust.

Example

When Arrayλ is placed in the same row as the array's first row, it applies its function, in this case, MIN, to each row. When copied below the array it applies MIN to each column. We can use any eta reduced compatible function, such as STDEV.P, or a LAMBDA formula as Arrayλ's function.