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
Bookmarks