Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Changing cell references in formulas to names and back again. | Excel Discussion (Misc queries) | |||
Automatically Changing Cell Reference's when Pasting in Excel | Excel Discussion (Misc queries) | |||
increase the value of a cell by a percentage | Excel Discussion (Misc queries) | |||
Possible Lookup Table | Excel Worksheet Functions | |||
Syntax for inferred cell references | Excel Worksheet Functions |