I want to understand how to use Offset and how to ...

Discussion in 'General Discussions' started by _32445, Jun 25, 2018.

  1. _32445

    _32445 Member

    Joined:
    Jun 16, 2018
    Messages:
    6
    Likes Received:
    0
    I want to understand how to use Offset and how to get my project completed.
     
    #1
  2. Shohini_1

    Shohini_1 Well-Known Member
    Simplilearn Support

    Joined:
    Sep 24, 2018
    Messages:
    72
    Likes Received:
    4
    Hi Lakshmi,

    Greetings!

    The OFFSET function in Excel returns a cell or range of cells that is a specified number of rows and columns from a cell or range of cells.

    Example:

    The OFFSET function below returns the cell that is 3 rows below and 2 columns to the right of cell A2. The OFFSET function returns a cell because the height and width are both set to 1.

    [​IMG]

    For project completion, based on the given problem statement you have to create a .xsl file and upload under Project tab.
     
    #2

Share This Page