+ Reply to Thread
Results 1 to 5 of 5

Copying sets of formulas

  1. #1
    Registered User
    Join Date
    10-05-2009
    Location
    Lofoten, Norway
    MS-Off Ver
    Excel 2007
    Posts
    19

    Copying sets of formulas

    If I want to copy a formula every 5th column, and still make the formulas count +1 column. How is it done?

    For example, this is how it is displayed if i copy them now:
    A4=B2/B3
    F4=G2/G3
    J4=K2/K3

    But i want them like this:
    A4=B2/B3
    F4=C2/C3
    J4=D2/D3

    So that the cells in the formula is +1column, even if the formula moves +5columns. Is this possible? How?
    I have 800 formulas to do it with so i don't want to do it manually
    Attached Images Attached Images
    Last edited by SpareBank1; 10-08-2009 at 11:03 PM.

  2. #2
    Registered User
    Join Date
    10-05-2009
    Location
    Lofoten, Norway
    MS-Off Ver
    Excel 2007
    Posts
    19

    Re: Copying sets of formulas

    DonkeyOte, I could really use your help on this one

  3. #3
    Registered User
    Join Date
    10-05-2009
    Location
    Lofoten, Norway
    MS-Off Ver
    Excel 2007
    Posts
    19

    Re: Copying sets of formulas

    any volunteers on this one?:P

  4. #4
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Copying sets of formulas

    In A4: =INDEX(2:2, INT(COLUMN()/5)+2) / INDEX(3:3, INT(COLUMN()/5) +2)
    Entia non sunt multiplicanda sine necessitate

  5. #5
    Registered User
    Join Date
    10-05-2009
    Location
    Lofoten, Norway
    MS-Off Ver
    Excel 2007
    Posts
    19

    Re: Copying sets of formulas

    Hmm im not quite sure i understand the formula. Well I've attached a picture below who shows, I want to Copy B1:F12, to H1:L12. As it stands now the formulas in the blue model is wrong.

    Ill take an example with one formula in the picture:
    D5 =SUM('Start:PL 2002-2003'!E554)
    E5 =SUM('Start:PL 2002-2003'!F554)
    F5 =SUM('Start:PL 2002-2003'!G554)

    Now I want
    J5 =SUM('Start:PL 2002-2003'!H554)
    K5 =SUM('Start:PL 2002-2003'!I554)
    L5 =SUM('Start:PL 2002-2003'!J554)
    but since the same cell in the model is 4 cells to the right it from K554 to M554.
    I dont want to do this manually because i need many more models like this on the side.

    I'm not a good explainer i know, but i hope you understand what i'm after
    What should D5, E5 and F5 say, to make J5, K5 and L5, start with the next cells, and not the 4th next?
    Attached Images Attached Images

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1