+ Reply to Thread
Results 1 to 2 of 2

Is This Possible? (Combination Generator)

  1. #1
    Registered User
    Join Date
    08-28-2020
    Location
    London
    MS-Off Ver
    15.13
    Posts
    1

    Is This Possible? (Combination Generator)

    Hi Gents,

    I would like to ask a question on whether this is possible to do in Excel and also how hard it would be? A major thank you in advance to anyone who is willing to take the time to drop/share some knowledge here. For anyone who can help me with this (if it is possible) - I'd love to buy you a coffee (gift certificate) or something in return. So, let me get on to the question:

    I would like to create a sort of 'Combination Generator' in Excel. As shown in my screenshot below I have 5 columns, all having 5 values each. What I am seeking to do is to somehow look at the cells in these columns, and then somehow generate a list of all possible combinations (if that makes sense). As seen in "Output Example 1" and "Output Example 2" i have done two random combinations to kind of give you an idea of what im trying to do. I'm not sure what the math would be, but im sure there would end up being hundred's of different combinations generated.

    Would anyone be so kind to let me know how difficult this would be to do and whether its even possible? Please also let me know if this is confusing/not clear? I tried my best but I can clarify further if needed.

    Thank You

    Update: Solved using 'permutation calculator' from Google
    Attached Images Attached Images
    Attached Files Attached Files
    Last edited by BornInTheFlame; 08-28-2020 at 04:59 PM.

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,705

    Re: Is This Possible? (Combination Generator)

    Quote Originally Posted by BornInTheFlame View Post
    I'd love to buy you a coffee (gift certificate) or something in return.
    We do not permit back-channel payments in the Forum. In the future, if you would like to offer someone payment to solve a problem, please post it in the Commercial Services subforum. There is a FAQ there explaining how it works.

+ 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. [SOLVED] Combination Generator Macro
    By ssjagger in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-13-2018, 10:41 AM
  2. Combination Generator
    By lorber123 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-19-2016, 06:32 AM
  3. Combination Generator
    By Willyp133 in forum Excel General
    Replies: 0
    Last Post: 03-18-2015, 09:23 AM
  4. [SOLVED] Combination Generator
    By kenny.fsw in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-09-2014, 12:33 PM
  5. 'In order' combination Generator
    By daisytiara in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-20-2013, 12:03 PM
  6. Combination generator needed...
    By ej2012 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-24-2011, 09:07 PM
  7. combination generator needed
    By smiso24 in forum Excel General
    Replies: 16
    Last Post: 04-12-2010, 07:18 PM

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