OFFSET Function Explained
The OFFSET function in Microsoft Excel returns a reference to a range that is a specified number of rows and columns from a given reference cell. It takes five arguments: a reference cell, a row offset, a column offset, a height, and a width. The reference cell is the starting point for the offset, and the row and column offsets are the number of rows and columns to move from the reference cell. The height and width arguments determine the size of the range that is returned.
OFFSET Function Syntax
OFFSET(reference, rows, cols, [height], [width])
- reference: The starting cell from which the offset will be applied.
- rows: The number of rows to offset from the reference cell.
- cols: The number of columns to offset from the reference cell.
- height: (Optional) The number of rows that the returned range should be.
- width: (Optional) The number of columns that the returned range should be.