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)
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)
- Oooo This one is very elegant I like this!
