Forum Discussion
Solved
Excel cell reference
Hi there,
I would like to copy a cell reference to a cell that is 5 cells below. at the same time, however, the reference is changed by 5 cells downwards. For example: Cell A1 =C1. If you copy this =C1 into cell A6, it says =C6. But I would like to have =C2 inserted there.
Thank You.
The row numbers of the cells with the formulas increase by 25 (rows 5, 34, ...) and the column numbers increase by 12 (B=column 2, N=column 14, Z=column 26). We have 3 entries per row, so the index number in column AR increases by 3 for each row.
In B5:
=INDEX($AR:$AR;3*(ZEILE(B5)-5)/29+(SPALTE(B5)-2)/12+1)
8 Replies
- Thanks,
I put the comma after C:C through ; replaced. Otherwise it wouldn't have worked. But then I get the message #Name?.Which language does your Excel use?
