I need to make 1 column in excel equal to another but I have 2 issues: - columns are in different sheets - values in the first columns are placed in direct successive rows, but values in the other are placed in cells incremented by 4 rows each time
means if columns are in A & B, we should have A1=B2, A2=B6, A3=B10, ...
Thank u in advance
2 Answers
In A1:
=INDEX(Sheet2!B:B,(ROW(A1)*4-2)6
If you use OFFSET then the rules might be easier to follow, e.g.
=OFFSET('Crank D'!B$4,(ROWS(B$8:B8)-1)*4,0)
The bold parts are those that are variable....
'Crank D'!B$4 is the first value you want
B8 is the first cell in which you enter the formula
4 is the number of rows between each entry you want
Change those 3 as required
