+ Reply to Thread
Results 1 to 8 of 8

All the maximum formations up to 4 letters in each of the groups ABCDE F G H I J *

  1. 03-17-2018, 02:47 PM #1
    jorel
    jorel is offline
    Forum Contributor
    Join Date
    11-29-2014
    Location
    brasil
    MS-Off Ver
    excel 2016
    Posts
    2,175

    All the maximum formations up to 4 letters in each of the groups ABCDE F G H I J *

    All the maximum formations up to 4 letters in each of the groups
    ABCDE
    F G H I J
    * We have two groups
    1st group = abcde
    * 2nd group = fghij
    Make all formations of a maximum of 4 letters
    Abcd, abce, aabb .. aaaa aaab .....
    Fghi fghj, ffgg, ffff fffg .....
    After ready = cross Cartesian type
    Abcd / fghi
    Reply With QuoteRegister To Reply
  2. 03-17-2018, 04:04 PM #2
    shg
    shg is offline
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: All the maximum formations up to 4 letters in each of the groups ABCDE F G H I J *

    A
    B
    C
    D
    E
    1
    2
    A
    A
    A
    A
    		 A2: =CHAR(65 + MOD(INT(5 * (ROWS($D$2:Me) - 1) / 5 ^ COLUMNS($D$2:Me)), 5))
    3
    A
    A
    A
    B
    4
    A
    A
    A
    C
    5
    A
    A
    A
    D
    6
    A
    A
    A
    E
    7
    A
    A
    B
    A
    8
    A
    A
    B
    B
    9
    A
    A
    B
    C
    10
    A
    A
    B
    D
    11
    A
    A
    B
    E
    Last edited by shg; 03-17-2018 at 04:06 PM.
    Entia non sunt multiplicanda sine necessitate
    Reply With QuoteRegister To Reply
  3. 03-17-2018, 04:48 PM #3
    jorel
    jorel is offline
    Forum Contributor
    Join Date
    11-29-2014
    Location
    brasil
    MS-Off Ver
    excel 2016
    Posts
    2,175

    Re: All the maximum formations up to 4 letters in each of the groups ABCDE F G H I J *

    Okay, this is correct but you have to do all the training until eeee
    after the other group = fghij
    Reply With QuoteRegister To Reply
  4. 03-17-2018, 06:17 PM #4
    jorel
    jorel is offline
    Forum Contributor
    Join Date
    11-29-2014
    Location
    brasil
    MS-Off Ver
    excel 2016
    Posts
    2,175

    Re: All the maximum formations up to 4 letters in each of the groups ABCDE F G H I J *

    hello SHG, please
    Reply With QuoteRegister To Reply
  5. 03-17-2018, 07:36 PM #5
    shg
    shg is offline
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: All the maximum formations up to 4 letters in each of the groups ABCDE F G H I J *

    Try changing the 65 in the formula.
    Reply With QuoteRegister To Reply
  6. 03-17-2018, 09:24 PM #6
    jorel
    jorel is offline
    Forum Contributor
    Join Date
    11-29-2014
    Location
    brasil
    MS-Off Ver
    excel 2016
    Posts
    2,175

    Re: All the maximum formations up to 4 letters in each of the groups ABCDE F G H I J *

    Ok, SHG, for what value?
    Reply With QuoteRegister To Reply
  7. 03-18-2018, 05:53 PM #7
    shg
    shg is offline
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: All the maximum formations up to 4 letters in each of the groups ABCDE F G H I J *

    May I respectfully suggest that you experiment?
    Reply With QuoteRegister To Reply
  8. 03-19-2018, 12:50 AM #8
    kvsrinivasamurthy
    kvsrinivasamurthy is offline
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,587

    Re: All the maximum formations up to 4 letters in each of the groups ABCDE F G H I J *

    In A1:E1= A B C D E
    In A4, Drag Upto D4

    =INDEX($A$1:$E$1,1+MOD(INT((ROWS(A$4:A4)-1)/(COLUMNS($A$1:$E$1)^((COLUMNS(A$4:$D$4)-1)))),COLUMNS($A$1:$E$1)))

    The drag downtillresult is EEEE
    Attached Files Attached Files
    Pl note
    Array formula should be confirmed with Ctrl+Shift+Enter keys together.
    If answere is satisfactory press * to add reputation.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. ask, how many formations are possible is which are, no more than 4 letters
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 33
    Last Post: 01-10-2018, 07:56 PM
  2. Request = build up to 5 letters maximum
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-23-2017, 12:55 PM
  3. [SOLVED] Request = generate the maximum formations 3 letters of the 10 letters
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 09-12-2017, 09:20 PM
  4. Order = maximum 3 letters per decade
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 09-04-2017, 02:56 PM
  5. [SOLVED] Generate random formations, but without repeating the letters in the columns and in the ro
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 22
    Last Post: 04-13-2017, 01:15 PM
  6. Creating groups from a list based on conditions with the maximum amount of variation
    By ShallowJamm in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-07-2015, 03:26 PM
  7. How do I specify maximum No. of letters in a cell?
    By evalon in forum Excel General
    Replies: 5
    Last Post: 11-15-2008, 04:13 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1