+ Reply to Thread
Results 1 to 3 of 3

copy a formula that skips rows

  1. #1
    Registered User
    Join Date
    03-14-2008
    Posts
    3

    copy a formula that skips rows

    Hi all

    I would like to copy a formula that skips every 3 rows down a column.

    My current formula is in cell D104: =(1+'Datasheet Monthly'!D307/100)+(1+'Datasheet Monthly'!D308/100)*(1+'Datasheet Monthly'!D309/100)-1

    In D105, I would like to have: =(1+'Datasheet Monthly'!D310/100)+(1+'Datasheet Monthly'!D311/100)*(1+'Datasheet Monthly'!D312/100)-1

    and then repeating down the column the same.

    Any help is appreciated.

    thanks
    Mo2982

  2. #2
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,655

    Re: copy a formula that skips rows

    Try this.....
    Please Login or Register  to view this content.
    Regards
    sktneer


    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.

  3. #3
    Registered User
    Join Date
    03-14-2008
    Posts
    3

    Re: copy a formula that skips rows

    yes, thank you very much, this is the formula i needed.

    Is this same reference able to be copied across the current worksheet? For example in cell E104, I would like the same formula

+ 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. [SOLVED] Drag Formula that skips every 12 Rows
    By kqball in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 08-01-2013, 12:35 PM
  2. IF function randomly skips rows - why?
    By Heirak in forum Excel General
    Replies: 3
    Last Post: 03-05-2012, 08:09 AM
  3. Rows Not Visible: Enumeration Skips
    By jefftanner in forum Excel General
    Replies: 2
    Last Post: 10-08-2008, 05:31 PM
  4. How to copy formulas when it skips rows?
    By ladyjammie in forum Excel General
    Replies: 3
    Last Post: 01-29-2008, 07:06 PM
  5. Counting number of rows (with skips)
    By MasterMonk in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-04-2007, 04:11 PM

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