Thanks Thanks:  0
Likes Likes:  0
Results 1 to 6 of 6

Thread: Offset--a beginning question

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    13
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Not realy understand when to use Offset function and how to use it, special when combine another function with offset, such as "=sum(offset(rng1, 0, rng2-1)", what does Offset really mean? Thanks a lot

  2. #2
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    83,653
    Post Thanks / Like
    Mentioned
    33 Post(s)
    Tagged
    6 Thread(s)

    Default

    On 2002-04-29 13:28, WYTT wrote:
    Not realy understand when to use Offset function and how to use it, special when combine another function with offset, such as "=sum(offset(rng1, 0, rng2-1)", what does Offset really mean? Thanks a lot
    Did you have a look in Excel's Help file? It's pretty good exposed.

    And what is rng1 and rng2 in the formula you mention?

  3. #3
    New Member
    Join Date
    Mar 2002
    Posts
    13
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Read Excel Help of Offset function a couple of times, but still have a problem to apply it! in what kind of circumstance should use it? also how to combine offset with other functions?

    Rng1 and Rng2 is defined name of two datas. The name can be changed base on your perference.

  4. #4
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    83,653
    Post Thanks / Like
    Mentioned
    33 Post(s)
    Tagged
    6 Thread(s)

    Default

    On 2002-04-29 14:05, WYTT wrote:
    Read Excel Help of Offset function a couple of times, but still have a problem to apply it! in what kind of circumstance should use it? also how to combine offset with other functions?

    Rng1 and Rng2 is defined name of two datas. The name can be changed base on your perference.
    The OFFSET worksheet function has lots of uses. One particular use is constructing dynamic name ranges and similarly when you want to apply functions to ranges that change. I use it a lot myself. See a contrib of mine at

    http://www.mrexcel.com/board/viewtop...c=6611&forum=2

    BTW, You didn't tell what rng1 and rng2 stand for!

  5. #5
    New Member
    Join Date
    Mar 2002
    Posts
    13
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks a lot.
    Rng1 is named for "product range", Rng2 for "choice range". Sorry not clarify it last post

  6. #6
    New Member
    Join Date
    Mar 2002
    Posts
    13
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Aladin,

    Read your link, it is very helpful. Ask a stupid question, the formula that you used is:

    =sum(offset($B$2, match(d2, A:A, 0)-e1-1, 0,E1, 1)

    Why $B$2 not $B$1? What is $B$1 and $B$2?

    Thanks a bunch!!!!!

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •