Exceljet

Quick, clean, and to the point

Beta

The functions below are beta, available only through the Office Insiders channel of Excel 365.

Excel BYCOL function

The Excel BYCOL function applies a LAMBDA function to each column in a given array and returns one result per column as a single array. In the example shown, data is the named range C5:H9....

Excel BYROW function

The Excel BYROW function applies a LAMBDA function to each column of a given array and returns one result per column in a single array. In the example shown, data is the...

Excel LAMBDA function

The Excel LAMBDA function provides a way create custom functions that can be reused throughout a workbook, without VBA or macros.

Excel MAKEARRAY function

The Excel MAKEARRAY function returns a array with specified rows and columns, based on a custom LAMBDA calculation. MAKEARRAY can be used to create arrays with variable dimensions where values...

Excel MAP function

The Excel MAP function "maps" a custom LAMBDA function to each value in a supplied array. The LAMBDA is applied to each value, and the result from MAP is an array of results with the same dimensions as the original...

Excel REDUCE function

The Excel REDUCE function applies a custom LAMBDA function to each element in a given array and accumulates results to a single value.

Excel SCAN function

The SCAN function applies a custom LAMBDA function to each element in a given array and returns an array that contains the intermediate values created during the...