BYCOL (PQL - xl)

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

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

Syntax

BYCOL(array, function)

Function Arguments

Name

Description

Type

Optional

array

An array to be separated by column

StringOrNumber

function

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

String

Comments

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