+ Reply to Thread
Results 1 to 5 of 5

Continuing a pattern on autofil without pattern re-starting

  1. #1
    Registered User
    Join Date
    06-21-2016
    Location
    UK
    MS-Off Ver
    2013
    Posts
    2

    Continuing a pattern on autofil without pattern re-starting

    Hello,

    Hoping this is an easy fix for someone out there. I am having trouble getting excel to continue a formula I have manually typed. On my sheet titled "Input" I have values in the following cells:

    G12
    G13
    G17
    G18
    G22
    G23
    G27
    G28
    G32
    G33
    (and so on in increments of five as per the above pattern)

    On a second sheet titled "output" I would like the following:

    D14 = sum of G12 + G13
    D15 = sum of G17 + G18
    D16 = sum of G22 + G23
    D17 = sum of G27 + G28
    D18 = sum of G32 + G33
    (and so on up to approx. D100)

    Can anybody advise of the formula to start with in D14 that I can then autofill down and will continue. My attempts so far have been unsuccessful.

    Thanks in advance.

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,064

    Re: Continuing a pattern on autofil without pattern re-starting

    I love this sort of problem!!

    Does this work?

    in D14
    =INDEX(G12:G1000,(ROW()-14)*5+12,1)+INDEX(G12:G1000,(ROW()-14)*5+12+1,1)
    and copy down

    NOTE: Increase G1000 if required
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  3. #3
    Registered User
    Join Date
    06-21-2016
    Location
    UK
    MS-Off Ver
    2013
    Posts
    2

    Re: Continuing a pattern on autofil without pattern re-starting

    Hi Special-K,

    Thanks for the quick response. I'm afraid it didn't work. Could it be to do with the info being across two sheets?

    Thanks.

  4. #4
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,064

    Re: Continuing a pattern on autofil without pattern re-starting

    Oops! Sorry, didn't see the reference to second sheet
    Yep, that's the problem just insert Sheet2 or whatever it's called
    Like
    =INDEX(Sheet2!G12:G1000,(ROW()-14)*5+12,1)+INDEX(Sheet2!G12:G1000,(ROW()-14)*5+12+1,1)

  5. #5
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,933

    Re: Continuing a pattern on autofil without pattern re-starting

    What exactly does your data look like?
    Can you upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How to complete a large formula by continuing a pattern
    By Crystal Barker in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 02-15-2016, 05:58 PM
  2. [SOLVED] When pattern changes...?
    By athinaida in forum Excel General
    Replies: 2
    Last Post: 08-02-2015, 11:23 AM
  3. Macro to insert pattern based on value and select based on pattern
    By CB569 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-15-2015, 12:36 PM
  4. [SOLVED] Lookup and return rows based on pattern start and pattern end
    By JDI in forum Excel General
    Replies: 18
    Last Post: 11-16-2014, 11:44 PM
  5. [SOLVED] continuing and starting new with
    By xcel_rider in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-08-2014, 11:49 AM
  6. Copy down hypertext cell range pattern & cell reference formula pattern
    By Underexcelling in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-10-2014, 03:23 AM

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