Forum Discussion
Solved
Change the row-to-row increment value when copying down a column, from +1 to +10
OK, I'm learning about certain functions etc and I'm having a brain fart. I assume the ROW or INDEX will help me but I'm tired! Essentially I have a Sheet which pulls data from other sheets to cr...
Usually there are more than one way to get to Rome. Here is another possibility with OFFSET():
A1=OFFSET(Sheet1!A$90,ROW()*10,0) resp. G1=OFFSET(Sheet1!G$90,ROW()*10,0)
GettingThereSlowly Although you have already accepted a solution, try this in A1:
=INDEX(Sheet1!A:A,IF(ROW()=1,100,100+ROW()*10-10))In B1, just update the column reference to G:G.
Thank you - always happy to get more its such a simple thing that im sure the different ways will have their usages!