Embedded Files
Description
Description
Here we have a suite of functions that are 'column-aware' which means they know which array column they are under or over. This eliminates the need to first select an array column with CHOOSECOLS().
The first function in this suite is ProcessColλ. ProcessColλ is extremely versatile because it is a LAMBDA helper function like BYROW in that it can apply many of Excel's functions or a LAMBDA we create to each element in the array column.
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.
Syntax
Syntax
ProcessColλ( Array, [Function] )
Arguments
Arguments
Array
(Required) The range this function is over or under.
Function
(Optional) An Excel function or LAMBDA formula to process the array's row. This defaults to SUM().
The following functions all share the same syntax: SumCλ, AvgCλ, MinCλ, MaxCλ, AndCλ, OrCλ
SumCλ( Array )
Arguments
Arguments
Array
(Required) The range this function is over or under.
Example
Example
When ProcessColλ is placed in the same column as an array's column, it applies its function, in this case, STDEV.P, to that column. SumCλ, AvgCλ, MinCλ, MaxCλ, AndCλ, OrCλ do the same thing but they are restricted to the function they are named after.
Page updated
Google Sites
Report abuse