+ Reply to Thread
Results 1 to 7 of 7

random number for group

Hybrid View

  1. #1
    Registered User
    Join Date
    05-18-2014
    MS-Off Ver
    Excel 2003
    Posts
    4

    random number for group

    hello guy...im new about excel..i want to learn on how to generate random 50 number with 10 group..thank you

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 insider Version 2504 Win 11
    Posts
    24,705

    Re: random number for group

    What does this mean?

    generate random 50 number with 10 group
    Please provide a fuller explanation. Do you want 10 groups of 50 numbers? Or do you just want 50 numbers? Is there a range between which these numbers should appear?
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Registered User
    Join Date
    05-18-2014
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: random number for group

    sorry i'm weak in english language..i hope u can understand.. a list of number from 1 until 50..then i want to make 10 group randomly with 5 numbers for each group..and each number dont repeat..
    for example :

    from number 1 until 50, i can generate randomly

    group 1 : 20,11,23,9,13
    group 2 : 1,5,35,4,32
    group 3 : .....
    group 4 : .....
    until
    group 10

    thank you very much..

  4. #4
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 insider Version 2504 Win 11
    Posts
    24,705

    Re: random number for group

    Here is a spreadsheet on creating 50 random numbers.
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    05-18-2014
    MS-Off Ver
    Excel 2003
    Posts
    4

    Red face Re: random number for group

    thanks...it's really help me...thanks again...

  6. #6
    Registered User
    Join Date
    05-18-2014
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: random number for group

    alansidman..how if i want to change the output to word? for example the rank is 1, then change to "a".
    example:
    5 = x
    34 = q
    42 = z

    thanks

  7. #7
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 insider Version 2504 Win 11
    Posts
    24,705

    Re: random number for group

    Create a table of what each number is equivalent to on a separate sheet. Then apply the vlookup function.

+ 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: 5
    Last Post: 06-21-2013, 10:40 AM
  2. [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
  3. Replies: 2
    Last Post: 12-07-2010, 04:29 PM
  4. Generating a Random Number of Random Numbers
    By Garrus in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-10-2010, 09:39 AM
  5. How do I find random number in list of random alpha? (Position is.
    By jlahealth-partners in forum Excel General
    Replies: 0
    Last Post: 02-08-2005, 02:06 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