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?

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?

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?

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?