Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #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.
  #2   Report Post  
Posted to microsoft.public.excel.misc
Max
 
Posts: n/a
Default cell references increase by 3 per row "=I1" then "=I4"

"jwk515" wrote:
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 columns 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.


Put in J1: =INDEX(I:I,ROW(A1)*3-2)
Put in K1: =INDEX(I:I,ROW(A1)*3-1)
Select J1:K1, fill down as far as required to exhaust the data in col I
(until zeros appear)

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


AFAIK, no ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
  #3   Report Post  
Posted to microsoft.public.excel.misc
jwk515
 
Posts: n/a
Default cell references increase by 3 per row "=I1" then "=I4"

Thanks for your help.

John K.

"Max" wrote:

"jwk515" wrote:
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 columns 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.


Put in J1: =INDEX(I:I,ROW(A1)*3-2)
Put in K1: =INDEX(I:I,ROW(A1)*3-1)
Select J1:K1, fill down as far as required to exhaust the data in col I
(until zeros appear)

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


AFAIK, no ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

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

"jwk515" wrote:
Thanks for your help.
John K


You're welcome, John !
Thanks for feeding back ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
Reply
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 02:01 PM
increase the value of a cell by a percentage ba Excel Discussion (Misc queries) 2 January 5th 06 11: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 03:21 PM.

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

About Us

"It's about Microsoft Excel"