Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Feb 2002
    Location
    Taranaki, New Zealand
    Posts
    193
    Thanks
    3
    Thanked 0 Times in 0 Posts

    drag formula (2003)

    I'm working on this spreadhseet with many graphs. On one sheet people will fill out the results and on another sheet they are being linked into the results page.
    The formula at the moment is =Sheet3!b3 next cell =Sheet3!b16. Everytime there are 13 rows .
    Is there a way to do this quickly when i do the next graph, or do I link every single result.

    So what I want is for the next graph to only type in (or link) =Sheet3!B4, drag it and it automatically knows, the next cell should be 13 more.

    Hope this makes sense.

    Thanks

    "Go Team New Zealand !!!!"

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: drag formula (2003)

    You could start with this formula:

    =OFFSET(Sheet3!$B$3,13*(ROW()-ROW($A$1)),0)

    This assumes that you enter the formula in a cell in row 1. If you enter it in a cell in row 7, use $A$7 instead of $A$1.
    You can fill down this formula as far as needed.

  3. #3
    2 Star Lounger
    Join Date
    Feb 2002
    Location
    Taranaki, New Zealand
    Posts
    193
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Re: drag formula (2003)

    I'm dragging the formula to the right.. Its not working as I would have hoped

  4. #4
    2 Star Lounger
    Join Date
    Feb 2002
    Location
    Taranaki, New Zealand
    Posts
    193
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Re: drag formula (2003)

    Attached a cut down version of the spreadsheet
    As you can see I kinda messed up the formula
    Thanks so much for your help
    Attached Files Attached Files

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: drag formula (2003)

    I had assumed that you wanted to fill down.
    If you enter the formula

    =OFFSET(Sheet3!$B$3,13*(COLUMN()-COLUMN($B$3)),ROW()-ROW($B$3))

    in cell B3, you can fill both down and right.

Posting Permissions

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