DROP (PQL - xl)

The function excludes a specified number of rows or columns from the start or end of an array. You might find this function useful to remove headers and footers in a worksheet report to return only the data

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

Syntax

DROP(array, rows, OPTIONAL columns)

Function Arguments

Name

Description

Type

Optional

array

Refers to the array from which to drop rows or columns

StringOrNumber

rows

Refers to the number of rows to drop. A negative value drops from the end of the array

Number

columns

Refers to the number of columns to exclude. A negative value drops from the end of the array

Number

Y

Comments

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