+ Reply to Thread
Results 1 to 4 of 4

Generate all the formations a number each letter.

  1. #1
    Forum Contributor
    Join Date
    11-29-2014
    Location
    brasil
    MS-Off Ver
    excel 2016
    Posts
    2,175

    Generate all the formations a number each letter.

    Generate all the formations a number each letter
    * Example we have in the letter A = 4 NUMBERS 01,05,17 21
    Letter b == 2,6,18,22
    C = 3.7, 19.23
    D = 4,8,20,24
    And
    Up to h =
    Formations = 01,18,23,24
    We have a number for each group, this is the criterion

  2. #2
    Forum Contributor
    Join Date
    11-29-2014
    Location
    brasil
    MS-Off Ver
    excel 2016
    Posts
    2,175

    Re: Generate all the formations a number each letter.

    https://www.excelforum.com/attachmen...1&d=1528128636
    Attached Files Attached Files

  3. #3
    Forum Contributor
    Join Date
    11-29-2014
    Location
    brasil
    MS-Off Ver
    excel 2016
    Posts
    2,175

    Re: Generate all the formations a number each letter.

    use the criterion of formation = only one number in each of the 8 letters, each letter has 4 numbers exeto letter h

  4. #4
    Forum Contributor
    Join Date
    11-29-2014
    Location
    brasil
    MS-Off Ver
    excel 2016
    Posts
    2,175

    Re: Generate all the formations a number each letter.

    I forgot to mention if the 1st number of a group is from the 1st the other 3 numbers can not be from the same position
    1st 2nd 3rd 4th*
    1 5 17 21 = a
    2 6 18 22 = b
    3 7 19 23 = c
    4 8 20 24 = d
    9 13 25 5 = e
    10 14 26 30 = f
    11 15 27 31 = g
    12 16 28 = L
    * In group (L) only 3 because it goes up to 31
    * So if I choose 05 it's from the 2nd position and I can not repeat the 2nd position
    * In the others.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Generate all formations in sequences = triple and quadruple doubles from 01 to 31
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-16-2018, 10:30 AM
  2. Generate all possible formations using strings 0 to 3 whose sum is 14 .
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-13-2018, 09:21 AM
  3. How to generate a letter as an output instead of a number?
    By limpfisch in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-17-2017, 07:56 PM
  4. Request = generate positional pairs identifying by the 24 formations
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-18-2017, 07:11 AM
  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. Replies: 28
    Last Post: 12-08-2016, 04:39 AM
  7. Need formula that will generate Cell number and Letter
    By Jetpilot69 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 05-14-2014, 04:04 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1