BYROW (PQL - xl)

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

  • Library: PQL \ Spreadsheet \ Logical
  • Compatibility: Any content (regardless of data source) in the Tabulate spreadsheet module

Syntax

BYROW(array, function)

Function Arguments

Name

Description

Type

Optional

array

An array to be separated by row

StringOrNumber

function

A LAMBDA that takes a row and calculates one result. The LAMBDA takes the following parameter: row - A row from array

String

Comments

This function is the same as the Microsoft Excel 'BYROW' function - using the same inputs, logic and outputs.