BornInTheFlame
New Member
 Joined
 Aug 28, 2020
 Messages
 4
 Office Version

 365
 Platform

 MacOS
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). 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
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). 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
Attachments
Last edited by a moderator: