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.