G
Gizmo
Excel 2003
I have the following formula.
="Reference " & ADDRESS(1,1,4,TRUE)
When I try to drag the formula down to copy it to more cells, the formula
doesn't increment the row.
ex:
Cell "I1" ="Reference " & ADDRESS(1,1,4,TRUE)
Cell "I2" ="Reference " & ADDRESS(1,1,4,TRUE)
etc.
I want:
Cell "I1" ="Reference " & ADDRESS(1,1,4,TRUE)
Cell "I2" ="Reference " & ADDRESS(2,1,4,TRUE)
etc.
What am I doing wrong?
I have the following formula.
="Reference " & ADDRESS(1,1,4,TRUE)
When I try to drag the formula down to copy it to more cells, the formula
doesn't increment the row.
ex:
Cell "I1" ="Reference " & ADDRESS(1,1,4,TRUE)
Cell "I2" ="Reference " & ADDRESS(1,1,4,TRUE)
etc.
I want:
Cell "I1" ="Reference " & ADDRESS(1,1,4,TRUE)
Cell "I2" ="Reference " & ADDRESS(2,1,4,TRUE)
etc.
What am I doing wrong?