Combinations/Permutations
Greetings Everyone. I have attached a workbook that I created to breakout unique Part Numbers Based on Size Options and Color Codes. It seems pretty clunky so I know there has to be a better way to code this than what I have done. Can someone provide some feedback for learning here? Thanks!
Permutations1.7.3.xls
Permutations1.7.3.xls
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi d-glitch. The base part numbers are dynamic. They vary depending on the manufacturer we are dealing with. The same applies to the Size Options and Color Codes. Maybe I should have went with a free text for all columns. Would that have been a better approach?
Also, I should not have placed the word permutation in the title since I am really going after combinations. None of the values change, I am simply looking for a concatenated list that has all three columns combined in every possible combination.
Also, I should not have placed the word permutation in the title since I am really going after combinations. None of the values change, I am simply looking for a concatenated list that has all three columns combined in every possible combination.
Did you try to adapt that recursive function to your code?
ASKER
I am still tinkering with it a bit.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Great help from everyone. I took a little from each and ultimately finished with a database. Thanks for all of your help Gents!
What are the possible colors and sizes?
Do you need a serial number as well? Or do all the red, size 10 shirts have the same Part No.