CHOOSECOLS (PQL - xl)

The function returns the specified columns from an array

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

Syntax

CHOOSECOLS(array, col num1, OPTIONAL col num2)

Function Arguments

Name

Description

Type

Optional

array

Refers to the array containing the rows to be returned

StringOrNumber

col num1

Refers to the first column to be returned. Required

Number

col num2

Refers to the additional columns to be returned

Number

Y

Comments

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