# Need help figuring out a way to copy formula down column in a pattern?

1. ## Need help figuring out a way to copy formula down column in a pattern?

Hi there,

I don't know how to phrase this question but I'm hoping someone could help me figure out a way to copy a formula down columns using a pattern of different cell references. I have over 50 categories in my data set and each category consists of 13 columns - 1st and 2nd columns are hidden, 3rd column is visible, 4th 5th 6th 7th 8th are hidden, 9th 10th 11th 12th 13th are visible. I need help figuring out a way to copy down a formula that references each of the 50 categories separately..

I'm sorry for the terrible explanation... I would reference the file attached to actually understand what I'm trying to do. Row 2 is the formula that I'm trying to copy down for each category (only 2 categories in the example file) and row 1 is what I would ideally hope the result would be.

Thank you!

2. ## Re: Need help figuring out a way to copy formula down column in a pattern?

You could put this formula in cell C1:

=\$J3&C4

and then you could copy this and paste it into cells J1 to N1.

Similarly for cell P1:

=\$W3&P4

and copy this into W1:AA1

Hope this helps.

Pete

3. ## Re: Need help figuring out a way to copy formula down column in a pattern?

I have more than 50 of these categories... I feel like there should be a more efficient way to do this then typing in the formula and copy and pasting for each category.

There are a couple of other spreadsheets that I need to create that are similar to this one, that's why I'm posting to see if anyone knows an efficient way to create a pattern with formulas.

4. ## Re: Need help figuring out a way to copy formula down column in a pattern?

Maybe you should re-attach a more realistic sample workbook.

Pete

5. ## Re: Need help figuring out a way to copy formula down column in a pattern?

Please try at C1 and copy to the right

=IF((MOD(COLUMNS(\$C1:C1)-2,13)>5)*(MOD(COLUMNS(\$C1:C1)-2,13)<>11),OFFSET(C3,,7-MOD(COLUMNS(\$C1:C1)-1,13))&C4,"")

6. ## Re: Need help figuring out a way to copy formula down column in a pattern?

Thank you that worked perfectly!!! I appreciate your help.

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