Spread.NET 17 Formula Reference
Formula Functions / Functions A to C / BYROW
In This Topic
    BYROW
    In This Topic

    This function applies a LAMBDA to each row and returns an array of the results.

    Syntax

    BYROW(array, lambda(row))

    Argument

    This function has the following arguments:

    Argument Description
    array An array to be separated by row.
    lambda

    A LAMBDA that takes a row as a single parameter and calculates one result. The LAMBDA takes a single parameter:

    row: A row from array

    Remarks

    If an invalid LAMBDA function or an incorrect number of parameters are provided, it returns a #VALUE! error called "Incorrect Parameters". Not providing a LAMBDA function or anything but a single value returned from the LAMBDA function returns a #CALC error.

    Data Types

    Returns numerical value.

    Examples

    BYROW(A1:C2, LAMBDA(array, MAX(array)))

    BYROW(A1:C2, LAMBDA(array, SUMSQ(array)))

    Version Available

    This function is available in product version 15 or later.