OFFSET Function or OFFSET Formula in Excel with example

OFFSET Function or OFFSET Formula in Excel with  example

OFFSET

Is a Excel Worksheet inbuilt function which returns a range based on row, column specified from the reference range. Offset function can return one or multiple values as array.

Syntax

=OFFSET(reference, row, column, [height], [width])

Parameters

  1. reference: mandatory parameter as range type, refers to base point from where we want to perform offset.
  2. row: mandatory parameter as number, refers to up and down direction from the base (reference parameter) point. It can be a positive or negative number.
  3. column: its mandatory parameter as number, refers to left and right direction from the base (reference parameter) point. It can be a positive or negative number.
  4. height: its an optional parameter, it should be a positive number and refers to number of rows you want to return from offset.
  5. width: its an optional parameter, it should be a positive number and refers to number of columns you want to return from offset.

Data source

Formula

Output

Next >> Flash Fill Vs. Fill Down, Fill Right, Fill Left and Fill Up in Excel Add-in with code example

Leave a Reply

Your email address will not be published.