Sophrozyne
New Member
Hi everyone!
I'm looking for the best way make sure I skip an X amount of columns when dragging a formula to the right.
I've attached some mock data. The idea is to adapt the formula in there so that I have an idea of how many "label 1" people were coded as label_1, label_2 etc... but considering that each range (column) is every 5 column, I'd need to adapt the formula so that I wouldn't need to manually modify each cell.
Does anyone have any suggestions?
Thanks,
So
I'm looking for the best way make sure I skip an X amount of columns when dragging a formula to the right.
I've attached some mock data. The idea is to adapt the formula in there so that I have an idea of how many "label 1" people were coded as label_1, label_2 etc... but considering that each range (column) is every 5 column, I'd need to adapt the formula so that I wouldn't need to manually modify each cell.
Does anyone have any suggestions?
Thanks,
So