+ Reply to Thread
Results 1 to 4 of 4

Find combinations with different repetitions for each cateogories

  1. #1
    Registered User
    Join Date
    07-08-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    17

    Find combinations with different repetitions for each cateogories

    I have 5 categories and 6 subjects and I need to arrange them such that for 59 rows, each row has a 1 subject in one of the categories, with one repeat. The tricky part is that they need to be in each category a certain total percentage (repeats column is how many times each subject is in a category to make that % work for 59 rows) :

    Category Repeats % Breakdown
    1 6 10
    2 17 30
    3 18 30
    4 12 20
    5 6 10



    How can I do this quickly in excel without just guess and check endlessly?

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: Find combinations with different repetitions for each cateogories

    For example, ...?
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Registered User
    Join Date
    07-08-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    17

    Re: Find combinations with different repetitions for each cateogories

    Quote Originally Posted by shg View Post
    For example, ...?


    Rows 1-3 in order from subject 1-6

    1 2 3 4 5 2
    2 3 4 5 1 3
    3 1 5 3 2 4

    I don't care what order they are in for each column just as long as I can get the distribution to equal that percent breakdown.

  4. #4
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: Find combinations with different repetitions for each cateogories

    Maybe I'm missing something, but just list the numbers down col A the desired number of times, and then make cols B:F 1, 2, 3, 4, 5:

    A
    B
    C
    D
    E
    F
    1
    1
    1
    2
    3
    4
    5
    2
    1
    1
    2
    3
    4
    5
    3
    1
    1
    2
    3
    4
    5
    4
    1
    1
    2
    3
    4
    5
    5
    1
    1
    2
    3
    4
    5
    6
    1
    1
    2
    3
    4
    5
    7
    2
    1
    2
    3
    4
    5
    8
    2
    1
    2
    3
    4
    5
    9
    2
    1
    2
    3
    4
    5
    10
    2
    1
    2
    3
    4
    5
    11
    2
    1
    2
    3
    4
    5
    12
    2
    1
    2
    3
    4
    5
    13
    2
    1
    2
    3
    4
    5
    14
    2
    1
    2
    3
    4
    5
    15
    2
    1
    2
    3
    4
    5
    16
    2
    1
    2
    3
    4
    5
    17
    2
    1
    2
    3
    4
    5
    18
    2
    1
    2
    3
    4
    5
    19
    2
    1
    2
    3
    4
    5
    20
    2
    1
    2
    3
    4
    5
    21
    2
    1
    2
    3
    4
    5
    22
    2
    1
    2
    3
    4
    5
    23
    2
    1
    2
    3
    4
    5
    24
    3
    1
    2
    3
    4
    5
    25
    3
    1
    2
    3
    4
    5
    26
    3
    1
    2
    3
    4
    5
    27
    3
    1
    2
    3
    4
    5
    28
    3
    1
    2
    3
    4
    5
    29
    3
    1
    2
    3
    4
    5
    30
    3
    1
    2
    3
    4
    5
    31
    3
    1
    2
    3
    4
    5
    32
    3
    1
    2
    3
    4
    5
    33
    3
    1
    2
    3
    4
    5
    34
    3
    1
    2
    3
    4
    5
    35
    3
    1
    2
    3
    4
    5
    36
    3
    1
    2
    3
    4
    5
    37
    3
    1
    2
    3
    4
    5
    38
    3
    1
    2
    3
    4
    5
    39
    3
    1
    2
    3
    4
    5
    40
    3
    1
    2
    3
    4
    5
    41
    3
    1
    2
    3
    4
    5
    42
    4
    1
    2
    3
    4
    5
    43
    4
    1
    2
    3
    4
    5
    44
    4
    1
    2
    3
    4
    5
    45
    4
    1
    2
    3
    4
    5
    46
    4
    1
    2
    3
    4
    5
    47
    4
    1
    2
    3
    4
    5
    48
    4
    1
    2
    3
    4
    5
    49
    4
    1
    2
    3
    4
    5
    50
    4
    1
    2
    3
    4
    5
    51
    4
    1
    2
    3
    4
    5
    52
    4
    1
    2
    3
    4
    5
    53
    4
    1
    2
    3
    4
    5
    54
    5
    1
    2
    3
    4
    5
    55
    5
    1
    2
    3
    4
    5
    56
    5
    1
    2
    3
    4
    5
    57
    5
    1
    2
    3
    4
    5
    58
    5
    1
    2
    3
    4
    5
    59
    5
    1
    2
    3
    4
    5


    It's a pretty boring parade.

+ 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. find duplicate combinations
    By jrmc in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-24-2015, 10:44 PM
  2. [SOLVED] Find all combinations of an exact sum
    By gt7string in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-12-2015, 02:22 PM
  3. Macros to find combinations
    By sriram170 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-06-2013, 08:07 PM
  4. Find Possible Sum Combinations That Equal Given Value
    By mdsyam in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 10-11-2012, 04:21 AM
  5. Find all possible combinations of letters
    By Double-R in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-26-2010, 09:09 AM
  6. Trying to find the all possible combinations
    By mutu in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-29-2009, 11:11 AM
  7. [SOLVED] how can i find all possible combinations
    By nomi in forum Excel General
    Replies: 3
    Last Post: 02-13-2006, 08:35 AM

Tags for this Thread

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