OFFSET (PQL - xl)

This function returns a reference to a range. The range is a specified number of rows and columns from a cell or range of cells. The function returns a single cell or a range of cells

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

Syntax

OFFSET(reference, rows, cols, OPTIONAL height, OPTIONAL width)

Function Arguments

Name

Description

Type

Optional

reference

The location from which to base the offset

CellRange

rows

Number of rows to which the upper left cell refers

Number

cols

Number of columns to which the upper left cell refers

Number

height

Number of returned rows; if omitted, same as reference

Number

Y

width

Number of returned columns; if omitted, same as reference

Number

Y

Comments

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