LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Changing cell references in formulas to names and back again. Aaron Excel Discussion (Misc queries) 4 April 25th 06 11:12 PM
Automatically Changing Cell Reference's when Pasting in Excel No I'm Spartacus Excel Discussion (Misc queries) 0 February 13th 06 01:01 PM
increase the value of a cell by a percentage ba Excel Discussion (Misc queries) 2 January 5th 06 10:29 PM
Possible Lookup Table Karen Excel Worksheet Functions 5 June 8th 05 09:43 PM
Syntax for inferred cell references donesquire Excel Worksheet Functions 4 April 4th 05 09:29 PM


All times are GMT +1. The time now is 10:41 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"