Returns a reference to a range that is a specified number of rows and columns from a cell or range of cells.
構文
OFFSET(reference, rows, cols, [height], [width])引数
reference必須
The starting reference from which you want to base the offset.
rows必須
The number of rows, up or down, that you want the upper-left cell to refer to.
cols必須
The number of columns, to the left or right, that you want the upper-left cell to refer to.
The OFFSET function does not move any cells or change the selection; it simply returns a reference. It is a volatile function that recalculates every time the worksheet changes, making it useful for creating dynamic ranges.
=OFFSET(A1, 2, 1)→B3Returns the value in the cell two rows down and one column to the right of A1.
Define the base reference
Select the starting cell or range that will serve as the anchor for your offset.
Specify the offset distance
Enter the number of rows and columns to move from the base reference.
Yes, OFFSET recalculates every time any change is made to the worksheet, which can slow down large workbooks.