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

Thread: drag and fill nightmares

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

    Default

    Two related questions, please.

    (1) I have data in cells B1:H1, say.
    In A2, I would like to reference B1.
    In A3, I would like to reference C1.
    In A4, I would like to reference D1.
    and so on.
    Is there any way of using a drag or fill to complete the rest of the references?

    (2) I have data in cells B1:H1, say.
    In B2, I would like to reference H1.
    In C2, I would like to reference G1.
    In D2, I would like to reference F1.
    and so on.
    Again, is there a way to drag and fill this?

    Thanks very much for your help!


  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    (1) Enter =OFFSET($A$1,,ROW(A1)) into cell A2 and fill down.

    (2) Enter =OFFSET($H$1,,8-COLUMN(H1)) into cell B2 and fill right.

  3. #3
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Millbank, London, UK
    Posts
    1,790
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi Mark,

    wow

    OFFSET

    they say you learn something new every day... too right on this board !

    My question : does the OFFSET function only apply to the current worksheet ? The help file says errors if it points past the edge of the sheet, does this mean you can't still use it in conjunction with naming another sheet in the workbook

    like : offset(sheet2!A1,1,2,3,4)

    thanks mate
    Chris


    ==========

    hey, ignore this, I just tried it with the function wizard and it does. Function-of-the-day award in my book. Thanks Mark.

    [ This Message was edited by: Chris Davison on 2002-02-20 13:18 ]

  4. #4
    New Member
    Join Date
    Feb 2002
    Posts
    11
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks very much for your help. OFFSET seems like a very useful function!

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
  •