Is this possible? How hard would it be?

BornInTheFlame

New Member
Joined
Aug 28, 2020
Messages
4
Office Version
  1. 365
Platform
  1. 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 :)
 

Attachments

  • Screen Shot 2020-08-28 at 1.54.12 PM.png
    Screen Shot 2020-08-28 at 1.54.12 PM.png
    145 KB · Views: 13
Last edited by a moderator:

Some videos you may like

Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.

jasonb75

Well-known Member
Joined
Dec 30, 2008
Messages
11,909
Office Version
  1. 365
Platform
  1. Windows
There is a similar question with several suggestions that you should be able to adapt to your data.

 

BornInTheFlame

New Member
Joined
Aug 28, 2020
Messages
4
Office Version
  1. 365
Platform
  1. MacOS
There is a similar question with several suggestions that you should be able to adapt to your data.



Thanks Jason - looking into this thread now. Quick question - how do i calculate the amount of possible combinations (assuming all columns have an equal about of values). What would the math formula be?
 

jasonb75

Well-known Member
Joined
Dec 30, 2008
Messages
11,909
Office Version
  1. 365
Platform
  1. Windows
I believe that it would be =5^5 or =Number of rows ^ Number of columns.

This is on the assumption that the columns remain in order, if you wanted combinations like "John Walks, Karen Walks" and "Karen Walks, John Walks" then it will be much higher.
 

BornInTheFlame

New Member
Joined
Aug 28, 2020
Messages
4
Office Version
  1. 365
Platform
  1. MacOS
I believe that it would be =5^5 or =Number of rows ^ Number of columns.

This is on the assumption that the columns remain in order, if you wanted combinations like "John Walks, Karen Walks" and "Karen Walks, John Walks" then it will be much higher.

Thank you very much Jason, they would all remain in order. I will mark this thread as [SOLVED] and post the solution I used from the thread you linked once i get it working.

:)
 

BornInTheFlame

New Member
Joined
Aug 28, 2020
Messages
4
Office Version
  1. 365
Platform
  1. MacOS
Update: This thread has been solved using the following answer in thread (kudos to Jason)

 

Watch MrExcel Video

Forum statistics

Threads
1,122,471
Messages
5,596,347
Members
414,060
Latest member
hermanseck

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top