+ Reply to Thread
Page 3 of 3 FirstFirst 1 2 3
Results 31 to 37 of 37

Diagram in Excel

  1. #31
    Valued Forum Contributor Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    BKK, Thailand
    MS-Off Ver
    Excel2016
    Posts
    1,319

    Re: Diagram in Excel

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


    Index 2
    Formula: copy to clipboard
    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.
    Last edited by Bo_Ry; 01-17-2019 at 09:50 AM.
    Bo

  2. #32
    Forum Contributor
    Join Date
    05-20-2016
    Location
    Detroit
    MS-Off Ver
    2016
    Posts
    239

    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
    Last edited by ionelz; 01-17-2019 at 09:06 PM.

  3. #33
    Valued Forum Contributor Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    BKK, Thailand
    MS-Off Ver
    Excel2016
    Posts
    1,319

    Re: Diagram in Excel

    Hope this work.

    O4

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Attached Files Attached Files

  4. #34
    Forum Contributor
    Join Date
    05-20-2016
    Location
    Detroit
    MS-Off Ver
    2016
    Posts
    239

    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
    Attached Files Attached Files
    Last edited by ionelz; 01-18-2019 at 09:43 AM.

  5. #35
    Valued Forum Contributor Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    BKK, Thailand
    MS-Off Ver
    Excel2016
    Posts
    1,319

    Re: Diagram in Excel


    Change in blue

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Attached Files Attached Files

  6. #36
    Forum Contributor
    Join Date
    05-20-2016
    Location
    Detroit
    MS-Off Ver
    2016
    Posts
    239

    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 ?
    Last edited by ionelz; 01-18-2019 at 05:28 PM.

  7. #37
    Valued Forum Contributor Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    BKK, Thailand
    MS-Off Ver
    Excel2016
    Posts
    1,319

    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.

+ Reply to Thread
Page 3 of 3 FirstFirst 1 2 3

Thread Information

Users Browsing this Thread

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

Bookmarks

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