## How to use Excel OFFSET function

Introduction OFFSET function in excel is a reference function. This function is used to refer data from a cell or range of cells to a defined range. The number of rows and columns to be returned is also specified. Reference returned by offset function is in parts: start point, row and column offset and height and width in rows and columns. It is also used with function which use dynamic calculation values. Syntax =OFFSET (Reference, Rows, Cols, Height, Width) Argument…