+91-8826547882

How to Use Offset Function

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)

December 19, 2012

0 Responses on How to Use Offset Function"

Leave a Message

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

© copyright www.excelcrazy.com. All rights reserved. Design and Development by www.creativebrainweb.com

Your Name (required)

Your Email (required)

Your Phone no. (required)

Your Location (required)

Your Message for us...

captcha