View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
jwk515
 
Posts: n/a
Default cell references increase by 3 per row "=I1" then "=I4"

I am trying to create a spreadsheet that takes the output of column "I" and
will then display it in columns "J-L". I would like columnd J to have I1,
I4, I7... and column K to have I2, I5,... going down. How can I create a
formula or refence that will automatically fill these columns in? I have
approximately 3000 entries in column I of which they are concatenate formulas
from the entries in columns A-H.

Another question I have is when using the concatenate formulas, is there
away to display the various references with in the cell in different fonts or
have some in boldface vs regular?

Thanks for your help
John K.