+ Reply to Thread
Results 1 to 3 of 3

Calculate Combinations

  1. #1
    Registered User
    Join Date
    05-06-2016
    Location
    Copenhagen, Denmark
    MS-Off Ver
    MS 2013
    Posts
    27

    Calculate Combinations

    Hi,

    I have three columns with values in all cells.

    I would like to see all possible combinations of 1 value from column A, 1 from column B and 1 from column C. Thus the order does not matter (I am looking for combinations, not permutations).

    Please find attached an example sheet with a few of the values from my data (2 from column A, 3 from column B and 4 from column C). I have listed the 24 possible combinations "manually" myself. I would like Excel to be able to return these combinations, though, as for all my data the total amount of possible combinations is 8,820 and this number could potentially increase to +100,000 in the future.

    Best regards
    Kasper
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,062

    Re: Calculate Combinations

    Please Login or Register  to view this content.
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

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

    Re: Calculate Combinations

    There's a workbook at https://app.box.com/s/47b28f19d794b25511be that has both VBA- and formula-based methods for doing that.
    Entia non sunt multiplicanda sine necessitate

+ 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. Calculate most common combinations
    By michael.p in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 02-08-2016, 02:16 AM
  2. Calculate possible combinations where the total sum equals 30
    By Buksh in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-01-2013, 09:45 AM
  3. Getting Excel to Calculate All Combinations of a Set of Data?
    By marello in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 04-19-2013, 02:21 PM
  4. Calculate Combinations
    By Adebishop in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-11-2011, 10:09 AM
  5. Replies: 3
    Last Post: 01-24-2011, 04:15 PM
  6. How to Calculate Combinations ?
    By Jacko in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-12-2005, 01:06 PM
  7. how to calculate a value for 49 possible combinations
    By crimsonkng in forum Excel General
    Replies: 4
    Last Post: 07-18-2005, 09:05 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