+ Reply to Thread
Results 1 to 2 of 2

How to create a random list based on weighted values with no dups?

  1. #1
    Registered User
    Join Date
    03-26-2012
    Location
    Boston
    MS-Off Ver
    Excel 2010
    Posts
    1

    How to create a random list based on weighted values with no dups?

    Hello all,

    I am looking to generate random combinations of weighted values. For example:

    I want A to appear in 9 different combinations
    B in 8 different combinations
    C in 8
    D in 7
    E in 5
    F in 6
    G in 10
    H in 3

    If I wanted to generate random groupings of 5 letters (with no repeated in the same grouping) with their weighted values, how would I do this?

    Thank you in advance,

    -Jeff

  2. #2
    Valued Forum Contributor
    Join Date
    03-14-2012
    Location
    Arizona USA
    MS-Off Ver
    Excel 2000/2007
    Posts
    408

    Re: How to create a random list based on weighted values with no dups?

    It is not too easy. But the way to do this is;
    1. Sequence through your list one at a time(A, then B, then C, and so on)
    2. For A you will need generate nine 5 digit, non-repeating strings that contain A once and do not contain B through H.

    From item 2, you can tell this is VERY rule based. I could do this but not for free.

+ 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.6.0 RC 1