
description:
Returns a reference to a range that is given a number of rows and columns from a given reference. |
syntax:
=OFFSET( reference, rows, cols, [height], [width] ) |
required arguments:
reference | The starting point supplied as a cell reference or range. |
rows | The number of rows to offset below the starting reference. |
cols | The number of columns to offset to the right of the starting reference. |
optional arguments:
[height] | The height in rows of the returned reference. |
[width] | The width in columns of the returned reference. |
