offset

Reference offset by rows and columns.

Syntax

v = offset(reference, rows, cols, height, width)

Description

Returns a reference offset from reference by rows rows and cols columns, optionally resized to height × width. Common for building dynamic ranges that follow recently-added data.

Example

offset(A1, 5, 0, 3, 1)    % A6:A8

See also

• index — Element of an array by row and column position.
• indirect — Reference resolved from a text string.