| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
increment Address formula
="Reference " & ADDRESS(ROW(),1,4,TRUE)
-- Gary''s Student - gsnu200776 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
increment Address formula
Thanks Gary,
Worked like a charm. "Gary''s Student" wrote: ="Reference " & ADDRESS(ROW(),1,4,TRUE) -- Gary''s Student - gsnu200776 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Am trying to autofill a formula and it will not increment down? | Excel Worksheet Functions | |||
| increment an index in a formula | Excel Discussion (Misc queries) | |||
| Increment formula for time | Excel Discussion (Misc queries) | |||
| How do I increment a formula? | Excel Worksheet Functions | |||
| how to make cell address reference increment? | Excel Worksheet Functions | |||
Linear Mode
