View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Brad Brad is offline
external usenet poster
 
Posts: 846
Default 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?