Copy formula,but skip every second column

[Sephie]

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!!

 

[Stormseed]

You can use:
http://www.mrexcel.com/forum/showthread.php?t=350522&highlight=copy+formula+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.

 

[Peter_SSs]

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?

 

[Sephie]

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

Ill try

cheers