Hello, I have a list of items that I want to make all possible combinations with, but the number of times each ingredient is used is restricted by the quantity owned. Order of ingredients does not matter.
Bellow is an example:
Thanks in advance!
Bellow is an example:
Book1 | |||||||||
---|---|---|---|---|---|---|---|---|---|
B | C | D | E | F | G | H | |||
2 | Fruit | Quantity | Fruit 1 | Fruit 2 | Fruit 3 | Fruit 4 | |||
3 | Strawberry | 5 | Strawberry | Strawberry | Strawberry | Strawberry | |||
4 | Apple | 1 | Strawberry | Strawberry | Strawberry | Apple | |||
5 | Banana | 3 | Strawberry | Strawberry | Strawberry | Banana | |||
6 | Strawberry | Strawberry | Apple | Banana | |||||
7 | Strawberry | Strawberry | Banana | Banana | |||||
8 | Strawberry | Apple | Banana | Banana | |||||
9 | Strawberry | Banana | Banana | Banana | |||||
10 | Apple | Banana | Banana | Banana | |||||
Sheet1 |
Thanks in advance!