Hello everyone; If I could please ask for a little further help on the wonderful formula/macro of Mr shg found here https://app.box.com/s/47b28f19d794b25511be ; I was able to easily customize this table and add some more columns etc. and it works like a charm. Thank you shg! The next thing I'm trying to do is apply some filter(s) to the produced permutation list.
So say on that list, Egg roll and Rice noodles don't (cannot) go together and also (there could be more impossible combinations) Wonton Soup, Roast Duck and Fortune Cookie also cannot go together. This was not hard to do using filters; I was able to apply the filters one set after the other and colour the first impossibility group say red, next group say blue etc. and also create another row on top called 'Filtered' as seen here:
<tbody>
</tbody>
So then my filtered list would drop down to 77 rows instead of 90 etc. The lists I'm working on are in the thousands of rows and 8 or more columns and the filters obviously are crucial.
So would it be possible to write some vba code that would automatically do this: as soon as you colour the impossibility items the same colour (egg roll and rice noodles red) it would say 10 in the far right row of Filtered: and repopulate the list and so on.
Sorry for the long explanation. Thank you.
So say on that list, Egg roll and Rice noodles don't (cannot) go together and also (there could be more impossible combinations) Wonton Soup, Roast Duck and Fortune Cookie also cannot go together. This was not hard to do using filters; I was able to apply the filters one set after the other and colour the first impossibility group say red, next group say blue etc. and also create another row on top called 'Filtered' as seen here:
| Filtered: | 77 | | 3 | 10 |
| Cum: | 90 | 30 | 6 | 2 |
| Cnt: | 3 | 5 | 3 | 2 |
| Header: | Appetizer | Main Course | Rice | Dessert |
| Inputs: | Dumplings | Kung Pao Shrimp | Fried rice | Fortune Cookie |
| | Egg roll | Orange Beef | Steamed rice | Ice Cream |
| | Wonton soup | Pork Lo Mein | Rice noodles | |
| | | Roast Duck | | |
| | | Szechuan Chicken | | |
<tbody>
</tbody>
So then my filtered list would drop down to 77 rows instead of 90 etc. The lists I'm working on are in the thousands of rows and 8 or more columns and the filters obviously are crucial.
So would it be possible to write some vba code that would automatically do this: as soon as you colour the impossibility items the same colour (egg roll and rice noodles red) it would say 10 in the far right row of Filtered: and repopulate the list and so on.
Sorry for the long explanation. Thank you.
