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