Results 1 to 4 of 4

Copy formula,but skip every second column

This is a discussion on Copy formula,but skip every second column within the Excel Questions forums, part of the Question Forums category; Hi guys, Difficult one.. I need to copy a formula to the right in a spreadsheet ,but the input data ...

  1. #1
    New Member
    Join Date
    Apr 2009
    Posts
    5

    Default Copy formula,but skip every second column

    Hi guys,

    Difficult one..
    I need to copy a formula to the right in a spreadsheet ,but the input data to the formula is located in another spreadsheet in every third column, so i cant just copy the formula to the right in my ouput sheet.
    Is there a way of getting around this problem within the formula?
    Thnx allot!!

  2. #2
    Banned
    Join Date
    Sep 2006
    Location
    Bombay, India
    Posts
    3,274

    Default Re: Copy formula,but skip every second column

    You can use:
    Formula to skip every Nth cell

    The formula on the page is to skip every 6th cell and you can modify the formula in order to skip every second cell. Moreover, do a search for your keywords and you will find hundreds of posts that relate to your problem.
    Last edited by Stormseed; May 25th, 2009 at 05:20 AM.

  3. #3
    MrExcel MVP
    Moderator
    Peter_SSs's Avatar
    Join Date
    May 2005
    Location
    Macksville, Australia
    Posts
    26,073

    Default Re: Copy formula,but skip every second column

    Quote Originally Posted by Sephie View Post
    Hi guys,

    Difficult one..
    I need to copy a formula to the right in a spreadsheet ,but the input data to the formula is located in another spreadsheet in every third column, so i cant just copy the formula to the right in my ouput sheet.
    Is there a way of getting around this problem within the formula?
    Thnx allot!!
    Yes. If the link provided does not solve your problem, please provide details of your formula, which cell it starts in and which columns in the other sheet it needs to refer to. Perhaps you could tell us what the first three formulas would be if you were doing each one manually?
    Hope this helps, good luck.
    Peter

    - Read: Posting Guidelines, Forum Rules & FAQs
    - Want to post a small screen shot? Try one of these Excel jeanie, MrExcel HTML Maker or Borders-Copy-Paste (To test: Test Here)
    - If posting vba code, please use Code Tags - like this [code]Paste code here[/code] - or use the VBHTML Maker

  4. #4
    New Member
    Join Date
    Apr 2009
    Posts
    5

    Default Re: Copy formula,but skip every second column

    Hey thnx man!!!
    My one just needs to copy right not down,but this would work

    Ill try

    cheers

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
  •  


DMCA.com