increment Address formula
 

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?

increment Address formula
 

="Reference " & ADDRESS(ROW(),1,4,TRUE)
--
Gary''s Student - gsnu200776

increment Address formula
 

="Reference " & ADDRESS(ROW(I1),1,4,TRUE)
copy down

"Gizmo" wrote:

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?

increment Address formula
 

="Reference " & ADDRESS(ROW(),1,4,TRUE)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Gizmo" wrote in message ...
| 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?

increment Address formula
 

Try this:

="Reference " & ADDRESS(Rows($1:1),1,4)

"True" is superfluous in this case, since it's omission also returns the A1
style.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Gizmo" wrote in message
...
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?

increment Address formula
 

Thanks Gary,

Worked like a charm.

"Gary''s Student" wrote:

="Reference " & ADDRESS(ROW(),1,4,TRUE)
--
Gary''s Student - gsnu200776