Functions
OFFSET
Returns a range offset from a reference
When to use it
When should I use OFFSET?
Use OFFSET to return a range that is shifted a given number of rows and columns from a starting reference — ideal for building dynamic named ranges or sliding-window aggregations.
Used in
Syntax
OFFSET(reference, rows, cols, [height], [width])