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 th...
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)
Thanks,
I put the comma after C:C through ; replaced. Otherwise it wouldn't have worked. But then I get the message #Name?.
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?
- German