+ Reply to Thread
Results 1 to 3 of 3

generate random, but with the criteria of a maximum of 5 row and 5 column number

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

    generate random, but with the criteria of a maximum of 5 row and 5 column number

    generate random, but with the criteria of a maximum of 5 row and 5 column numbers, polymers only one of them cannot have the pair ex 23,32 or 23 or 32 numca both together so we have two criteria
    https://www.excelforum.com/attachmen...1&d=1589972195
    Attached Files Attached Files

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

    Re: generate random, but with the criteria of a maximum of 5 row and 5 column number

    you have to look at the matrix of 10 columns and 10 rows and the double polymers that will be the base
    in each line of 50 numbers generated cannot have
    * more than 5 per row and 5 per column and is only a number of the polymrome pair, it cannot have two numbers
    * ex 23,32 only or 23 or 32 number both together
    the macro under these criteria should generate more than 2 thousand lines of 50 numbers

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

    Re: generate random, but with the criteria of a maximum of 5 row and 5 column number

    hello please!

+ 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. Replies: 9
    Last Post: 05-03-2016, 04:43 PM
  2. Replies: 6
    Last Post: 08-31-2015, 03:08 PM
  3. Generate random number to column A in different sheets
    By Oweineh in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-08-2014, 12:48 AM
  4. Replies: 8
    Last Post: 11-18-2013, 04:24 PM
  5. Replies: 5
    Last Post: 06-21-2013, 10:40 AM
  6. [SOLVED] Generate random 6-16-byte random hexadecimal number
    By jsamuelshn in forum Excel General
    Replies: 6
    Last Post: 07-20-2012, 10:38 AM
  7. generate a random number and use if function to generate new data
    By Dogdoc1142 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-25-2006, 10:50 PM

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