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 *

    EC Analytics will help your business make better decisions by providing expert-level business intelligence (BI) services. Forecasting, strategy, optimization, performance analysis, trend analysis, customer analysis, budget planning, financial reporting and more. EC Analytics also offers Advanced Data Analytics training in corporate and retail.

    Social Media

    ECAnalytics-facebookECAnalytics_Linkedin

    Address:

    NM 23, SECTOR 14, OLD DLF COLONY,
    GURGAON (HARYANA)
    0124- 4601426

    EC Analytics Consulting @ 2019 ALL RIGHTS RESERVED