+ Reply to Thread
Results 1 to 3 of 3

Thread: To generate random numbers with some conditions

  1. #1
    Registered User
    Join Date
    01-12-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    2

    To generate random numbers with some conditions

    Please see if you could find time in solving this problem. Solutions will be highly solicited.

    * Generate a random number ranging from 1 to 12 in any four columns. (viz. A, B, C, D)
    * A1 and A2 should not be equal or consecutive number
    * A1 and B1 should not be equal and should be from 2 group of numbers. Group1 (1 to 6) and Group2 (7 to 12)

    for example
    4 - 8
    1 - 10
    12 - 6
    9 - 5
    7 - 2
    10 - 4
    3 - 9
    5 - 11
    6 - 7
    8 - 1
    4 - 8
    11 - 3



    if will be of immense use to allot practical experiments numbering from 1 to 12 in a random fashion.
    Last edited by premkumarjulien; 01-12-2012 at 12:20 PM.

  2. #2
    Valued Forum Contributor Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Excel 2007
    Posts
    685

    Re: To generate random numbers with some conditions

    What are the rules/restrictions for columns C and D?

    Pete

  3. #3
    Registered User
    Join Date
    01-12-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: To generate random numbers with some conditions

    Thanks pete same rules applies to C and D

+ Reply to Thread

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.2.0