How to Use Offset Function

Share Now


Offset Function

Offset function returns the reference to a range that is a given number of rows and columns from the given reference. Offset have five parameters. It also helps us to create dynamic ranges with the help of 4th and 5th parameter.

The syntax of Offset function

=Offset(Reference, Rows, Columns,[ Height], [Width])

Reference – Reference is any starting cell from where the offset will be applied.

Rows – The number of rows move down/up from the reference cell in the range.

Columns – The number of columns move Right/left from the reference cell in the range.

[Height] – The number of rows in the range. This is optional; if we leave this parameter then height will be a single cell.

[Width] – The number of columns in the range. This is optional; if we leave this parameter then height will be a single cell.

Based on the above example, offset function in cell F2 would return

=offset(B4,3,2) – “Yash Pal”(Would return the cell D7 value)



Share Now
November 16, 2019

0 responses on "How to Use Offset Function"

    Leave a Message

    Your email address will not be published. Required fields are marked *

    Tableau Training in Delhi

    All Rights Reserved. EC Analytics Consulting 2014 - 2019.

    NM 23, Sector 14, OLD DLF Colony - Gurgaon (Haryana) India. 9582876837 | Privacy Policy