Logical
★ 30 · ◉ 16 · Excel 365
=BYCOL()
Applies a LAMBDA function to each column and returns an array of the results
=BYCOL (array, lambda(column))
Advanced Formulas
Advanced Formulas
11 functions for this use case · out of 12 defined
Logical
★ 12 · ◉ 10 · Excel 365
=MAKEARRAY()
Returns a calculated array of a specified row and column size, by applying a LAMBDA function
=MAKEARRAY(rows, cols, lambda(row, col))
Numbering & Sample Data
Advanced Formulas
Logical
★ 50 · ◉ 8 · Excel 365
=LAMBDA()
LAMBDA function
=LAMBDA([parameter1, parameter2, …,] calculation)
Advanced Formulas
Logical
★ 60 · ◉ 8 · Excel 2021
=LET()
LET function
=LET(name1, name_value1, calculation_or_name2, [name_value2, calculation_or_name3...])
Advanced Formulas
Math & Trig
★ 10 · ◉ 7 · All versions
=MMULT()
The MMULT function returns the matrix product or multiplication of two arrays. The result is an array with the same number of rows as array1 and the same number of columns as array2. The way you enter the formula depends on which version of Office 365 you are using.
=MMULT(array1, array2)
Advanced Formulas
Scientific & Unit Conversion
Information
★ 5 · ◉ 6 · Excel 365
=ISOMITTED()
The value you want to test, such as a LAMBDA parameter.
=ISOMITTED(argument)
Error Handling
Advanced Formulas
Logical
★ 20 · ◉ 6 · Excel 365
=REDUCE()
Reduces an array to an accumulated value by applying a LAMBDA function to each value and returning the total value in the accumulator
=REDUCE([initial_value], array, lambda(accumulator, value, body))
Advanced Formulas
Logical
★ 25 · ◉ 5 · Excel 365
=SCAN()
Scans an array by applying a LAMBDA function to each value and returns an array that has each intermediate value
=SCAN ([initial_value], array, lambda(accumulator, value, body))
Advanced Formulas
Logical
★ 35 · ◉ 4 · Excel 365
=BYROW()
Applies a LAMBDA function to each row and returns an array of the results
=BYROW(array, lambda(row))
Advanced Formulas
Text
★ 15 · ◉ 3 · All versions
=CALL()
value returned by a previously executed REGISTER or REGISTER.ID function.
=CALL(register_id,[argument1],...)
Advanced Formulas
Logical
★ 30 · ◉ 1 · Excel 365
=MAP()
Returns an array formed by 'mapping' each value in the array(s) to a new value by applying a lambda to create a new value
=MAP (array1, lambda_or_array<#>)
Advanced Formulas