Description

Here we have a suite of functions that are 'row-aware' which means they know which array row they are next to. This eliminates the need to first select an array row with CHOOSEROWS().

The first function in this suite is  ProcessRowλ. ProcessRowλ is extremely versatile because it is a LAMBDA helper function like BYCOL in that it can apply many of Excel's functions or a LAMBDA we create to each element in the array row. 

The other functions work identically but fix the function they apply which makes them very simple to use.

NOTE! If you need one function to process all rows see the Array Aware Suite. 

Example

When ProcessRowλ is placed in the same row as an array's row, it applies its function, in this case, STDEV.P, to that row. SumRλ, AvgRλ, MinRλ, MaxRλ, AndRλ, OrRλ do the same thing but they are restricted to the function they are named after.