Results 1 to 4 of 4

Thread: Generating numbers from a number list

  1. #1
    Junior Member
    Join Date
    Sep 2017
    Posts
    2
    Rep Power
    0

    Generating numbers from a number list

    Hello all,
    New to the board. I would like help with coming up with a formula which will help me generate
    5 two digit number groups.. yes, this is lottery related... lol.....

    anyway, say I have a number list, which could vary in length, starting in A1 and could go down as many as 50 numbers.
    numbers in the list could be any number between 01 to 60, never higher then 60. So it could look like this:
    12
    10
    09
    03
    11
    14
    02
    05
    19
    14
    06
    on down....

    From this list I would like to generate sets of 5 2 digit groups, like this:
    02 03 09 11 14
    02 05 11 14 19
    02 05 11 12 19

    I would like a box or drop down option where I could select the how many number groups are generated, 5, 10, 15, 20, and if possible, generate the maximum possible variations of those numbers from the list.

    Thank you for any help offered.

    Dave

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

    Please have a look at this http://www.xtremevbtalk.com/tutors-c...binations.html
    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
    Junior Member
    Join Date
    Sep 2017
    Posts
    2
    Rep Power
    0
    Quote Originally Posted by Admin View Post
    Hi Dave,

    Please have a look at this http://www.xtremevbtalk.com/tutors-c...binations.html
    Hello,
    thank you for pointing me in the right direction... I will have to register there and ask about those macros... I have no clue which one to use or what to do with them.. It looks like they might be what I'm looking for, I just don't have enough knowledge to implement them.

    can you help me?

    Dave

  4. #4
    Junior Member
    Join Date
    Nov 2017
    Posts
    1
    Rep Power
    0
    Did you ever solve this, Dave? I'm looking to do something very similar and I'm having the same issue.

Similar Threads

  1. Replies: 2
    Last Post: 09-03-2013, 11:30 PM
  2. Replies: 4
    Last Post: 07-27-2013, 02:04 PM
  3. Replies: 2
    Last Post: 07-18-2013, 04:04 AM
  4. Replies: 3
    Last Post: 04-05-2013, 08:54 AM
  5. Replies: 0
    Last Post: 03-06-2012, 04:25 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
  •