Diagram in Excel

1. Re: Diagram in Excel

this is for Index 2
Main
Formula:
`Please Login or Register  to view this content.`

Index 2
Formula:
`Please Login or Register  to view this content.`

Change (\$J\$7=2) to (\$J\$7>=2)

For Index 3 change Index 2 in blue as below and add before last, \$B\$7,"")

Change to \$K\$7 to \$K\$7*2 and (\$J\$7=2) to (\$J\$7>=3) and keep adding more for each row and each index if you need
Sorry, I'm not doing this, the repeated work is not fun.

2. Re: Diagram in Excel

Ok, I got it right for Index=3 , I got them 3 times but Index move bellow 24 (\$C\$4)

I believe, at ..... = \$C\$4 (numbers of rows)

If this is hard to fix then please see attached in 25
I have to add in Formula, 20 lines for INDEX and 15 lines for W's

Range1 work super in attached #25
There should be easy to do it in Range2 from Range1 (for Index)
There is no more "U shape", no nothing, formulas in Range1 take care of all
They just need to be Index="multiplication" times at Index Pitch
All is per individual cell
Here is simple logic : Look in Range1 at any cell, copy that cell in Range2, and then Index times at Index Pitch
In this way we look in Range1 in any cell, at Wi in Coulmn B, At Wi Index in Column J and Index Pitch in Column K

3. Re: Diagram in Excel

Hope this work.

O4

Formula:
`Please Login or Register  to view this content.`

4. Re: Diagram in Excel

I think, this will do it ! I will keep testing it today but so far is super ok.
.... except one little think, which apply ONLY when Action(Column L)/Index/Index Pitch
With this, it do what is should but somehow it skip last row, it doesn't write in 24 (\$C\$4)

But, with Action="Y"(column I) and Action="n" (column L) all is super OK, it write in last row
When Action="Y" (column L) and push w's down, it work, it start from top, but it skip 24

I was trying to replace here and there, \$C\$4 with \$C\$4+1 but doesn't do it
Some were else must be an +1 or -1, only for Index/Index Pitch

Thank you

5. Re: Diagram in Excel

Change in blue

Formula:
`Please Login or Register  to view this content.`

6. Re: Diagram in Excel

Millions o THANKS, all works great now.
Thank you and sorry for so many questions.

I trying to find this : what is ... INDIRECT("C1:C"&\$J\$8 .......) and I mean, I have moved all columns, for example Column C is at Column F now, but still the Formula is working !!!!
\$J\$8 is freezed so it moved but "C1:C" is not updating with column move so why is still working ?

7. Re: Diagram in Excel

Assume that J8 = 2 , G8 =3

"C1:C"&\$J\$8 = "C1:C2"
Row(INDIRECT("C1:C2",)) = {1,2}

ROW(INDIRECT("1:"&\$G\$7)
ROW(INDIRECT("1:3") ={1;2;3}

Row(INDIRECT("C1:C2",))+ ROW(INDIRECT("1:3")

= {1,2} + {1;2;3} = {1,2;3,4;4;5}

{1,2;
3,4;
4;5}

I use this to creating a 2D array when the index is more than 1.

Page 3 of 3 First 1 2 3

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1