Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Drop-Down List Choice Affects Multiple Cells? | Excel Worksheet Functions | |||
Excel 2003 - XML List Formatting Problem | Excel Discussion (Misc queries) | |||
How to Change List Based on Value Chosen in Another List | Excel Worksheet Functions | |||
Filtered list & maximum no columns problem | Excel Discussion (Misc queries) | |||
Update master list with other lists | Excel Worksheet Functions |