Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change row and column when copying formula
I want to fill down a formula where the row and column both incriment by one:
=CONCATENATE(FK6,G6,GQ6) =CONCATENATE(FL7,H7,GR7) How can I do this? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change row and column when copying formula
tested and works
=INDIRECT("R"&ROW()&"C"&199+ROW()-6,0)&INDIRECT("R"&ROW()&"C"&7+ROW()-6,0)&INDIRECT("R"&ROW()&"C"&167+ROW()-6,0) This is assuming that the first equation is put on row 6... and copied down.... -- Wag more, bark less "benjampm" wrote: I want to fill down a formula where the row and column both incriment by one: =CONCATENATE(FK6,G6,GQ6) =CONCATENATE(FL7,H7,GR7) How can I do this? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change row and column when copying formula
The 199 should be in the third indirect and the 167 should be in the first
indirect. Sorry about that.... -- Wag more, bark less "Brad" wrote: tested and works =INDIRECT("R"&ROW()&"C"&199+ROW()-6,0)&INDIRECT("R"&ROW()&"C"&7+ROW()-6,0)&INDIRECT("R"&ROW()&"C"&167+ROW()-6,0) This is assuming that the first equation is put on row 6... and copied down.... -- Wag more, bark less "benjampm" wrote: I want to fill down a formula where the row and column both incriment by one: =CONCATENATE(FK6,G6,GQ6) =CONCATENATE(FL7,H7,GR7) How can I do this? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change row and column when copying formula
Another option, place this in any starting cell, say in B3:
=OFFSET(FK6,,ROWS($1:1)-1)&OFFSET(G6,,ROWS($1:1)-1)&OFFSET(GQ6,,ROWS($1:1)-1) Copy B3 down -- Max Singapore http://savefile.com/projects/236895 Downloads:16,000 Files:354 Subscribers:53 xdemechanik --- "benjampm" wrote: I want to fill down a formula where the row and column both incriment by one: =CONCATENATE(FK6,G6,GQ6) =CONCATENATE(FL7,H7,GR7) How can I do this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 -- Copying a formula to Paste Special into column cell | Excel Discussion (Misc queries) | |||
Change Month formula from column to column | Excel Discussion (Misc queries) | |||
Copying a formula to column using a value from a particular cell | Excel Discussion (Misc queries) | |||
Same formula in each cell of column; insert rows w/o copying down | Excel Discussion (Misc queries) | |||
Copying a Formula into Every other Cell In a Column | Excel Worksheet Functions |