Results 1 to 3 of 3

Thread: generate numbers without reversing the dozen on the same line

  1. #1
    Member
    Join Date
    Aug 2012
    Posts
    72
    Rep Power
    13

    generate numbers without reversing the dozen on the same line

    Hi.
    I need to create random numbers with 10 columns and 10 rows.


    But for each line can not be the number opposite each decade.
    79 22 48 70 04 98 09 41 32 56
    59 17 42 67 5 67 94 47 46 21
    85 66 70 90 89 83 84 50 81 36
    83 50 36 3 57 55 20 39 51 77
    23 67 39 29 12 86 68 18 87 73
    90 3 54 26 72 17 69 13 44 36
    10 11 37 98 84 19 63 54 22 59
    65 26 3 55 68 61 9 76 75 69
    33 28 38 59 87 74 63 60 41 90
    94 50 01 29 59 8 33 47 87 91
    see the first line was generated as the number 79, then this same line, can not generate the number 97.


    number 22 in this case is OK.


    The first line was generated the number 84, then this is not the same line, you can generate the number 48.


    The first line was generated the number 07, then this is not the same line, you can generate the number 70.


    and so
    97 22 84 07 40 98 90 14 23 65
    Cross-Post
    generate numbers without reversing the dozen on the same line

  2. #2
    Administrator Admin's Avatar
    Join Date
    Mar 2011
    Posts
    1,123
    Rep Power
    10
    Hi

    So what's the logic not to have 97 against 79, whereas can have 48 against 84 ?
    Cheers !

    Excel Range to BBCode Table
    Use Social Networking Tools If You Like the Answers !

    Message to Cross Posters

    @ Home - Office 2010/2013/2016 on Win 10 (64 bit); @ Work - Office 2016 on Win 10 (64 bit)

  3. #3
    Member
    Join Date
    Aug 2012
    Posts
    72
    Rep Power
    13
    Hi.

    if on the same line, can not have.

    the same line I have, 97 I can not have 79, the same line I'm 48 I can not have 84

Similar Threads

  1. Wrap Text On Spaces Up To A Maximum Number Of Characters Per Line
    By Rick Rothstein in forum Rick Rothstein's Corner
    Replies: 15
    Last Post: 12-20-2016, 09:47 AM
  2. Replies: 6
    Last Post: 06-01-2013, 03:24 PM
  3. VBA Code to Generate Events at Specific frequency
    By ChiswickBridge in forum Excel Help
    Replies: 0
    Last Post: 02-11-2013, 08:20 AM
  4. Replies: 3
    Last Post: 05-14-2012, 11:30 AM
  5. Generate random numbers in Excel
    By Mahesh in forum Excel Help
    Replies: 3
    Last Post: 10-06-2011, 11:24 AM

Posting Permissions

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