Returns a reference to a range that is a specified number of rows and columns from a cell or range of cells.
この関数は Google スプレッドシートでも Excel と同じように機能します。構文も引数も同じです。
OFFSET(reference, rows, cols, [height], [width])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)結果: B3
Returns the value in the cell two rows down and one column to the right of A1.
Yes, OFFSET recalculates every time any change is made to the worksheet, which can slow down large workbooks.