Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
List Problem--Please Help!
Okay, so I have a list of about sixty items (we'll say they are flavors
of ice cream). Each one is just a single flavor (apple, cherry, cinamon, etc.) Is there a way for me to take this list and have excel create (not calculate) the maximum number of combinations of those individual items, assuming that I don't want more than three flavors total? With the three flavors I mentioned, the output would be something like: apple apple cherry apple cinamon apple cherry cinamon cherry cherry cinamon cinamon Notice there are no duplicates, but it provides all possible variations with up to three flavors. How would I do this? Thanks in advance for your input. Reply With Quote |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
List Problem--Please help? | Excel Discussion (Misc queries) | |||
List box problem | Excel Discussion (Misc queries) | |||
List box problem | Excel Discussion (Misc queries) | |||
List Box Problem | Excel Programming | |||
LIst Problem | Excel Worksheet Functions |