Results 1 to 7 of 7

Make unique combinations of 1 column with 1 contraint. VBA

Threaded View

  1. #1
    Registered User
    Join Date
    10-12-2022
    Location
    Copenhagen
    MS-Off Ver
    365
    Posts
    24

    Cool Make unique combinations of 1 column with 1 contraint. VBA

    Hi Excel geniuses

    I need help with generating unique combinations of digit values in column "A":

    A ("Input")
    0.660
    0.742
    0.825
    0.990
    1.155
    1.237
    1.253

    I have attached my workbook. I have used a vba code from a teaching webside, which worked out ok.
    The result is marked with light red in my workbook.

    However, I have encountered 3 problems:
    1. The combinations are stored together in one single cell. Once outputted, I would like them separated in different columns, so I can make a sum total of the combinations. The Blue table is my end goal.
    2. The VBA code does not allow each input from the yellow column ("A") to be used more than once. I need each width to be able being used more than once.
    3. I would like a constraint inside the VBA code, so only combinations with sum total less than (=<) 3.85 are generated. Is this possible?

    I made The Blue table manually to illustrate my end goal. I hope the task makes sense.

    1664998082208.png
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 1
    Last Post: 03-29-2020, 03:31 PM
  2. [SOLVED] Matching unique column combinations of data with VBA
    By insomniac53 in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 05-03-2015, 07:48 PM
  3. [SOLVED] Pull unique two column combinations and skip particular value
    By volfied in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-30-2013, 11:02 AM
  4. Make and regularly update a list of all combinations of two lists of unique values
    By Sherelle in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-19-2012, 07:21 PM
  5. How to populate multiple column listbox with unique combinations only
    By shuvajit in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-06-2012, 12:37 AM
  6. Replies: 7
    Last Post: 02-11-2011, 06:58 AM
  7. Generating combinations from a column of unique numbers
    By mistermat in forum Excel General
    Replies: 1
    Last Post: 08-31-2008, 06:54 AM

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