Hi People!
First I apologize if this question has alreasy been asked and answered but today I've had trouble searching and even browsing the page; keeps on telling me I need to wait 30 seconds before performing a new search and only allows one search criteria. Nevermind.
I find my question is a little difficult to explain so I'll try with an example.
I have a value in a variable start cell, i.e.cell 'Sheet1'!O152, I know that the next desired value is a 144 cells below. I do not really have the option of 'dragging' down; I work with a large table/databse and only have the option of dragging across. What I want is something like:
With a step of 144 cells and a start cell like 'Sheet1'!O152
='Sheet1'!O296
='Sheet1'!O440
I've, naively, tried
='Sheet1'!O(B7+B8*E4)
Where B7 is the start cell in column O, B8 being the number of the next cell and E4 being the scale, i.e 2nd step E4 = 2, 3rd step E4 0 3.
I really hope somebody knows how to do this. It would save me hours of slave labour.
Thanks,
Johnston81
Bookmarks