Hello,</SPAN></SPAN>
Combine all products with different varieties to achieve a special offer price package </SPAN></SPAN>
I am looking for a solution on how many special offer price packages can be prepared from the product and variety list of D5:F12, Note: there is Product A To H & Variety X To Z in the offer packages there must be all Products present from A To H one of each, but only one variety price can be chosen from X to Z </SPAN></SPAN>
Here are a few examples...</SPAN></SPAN>
Column H if we make a lowest price offer package than we can pick the lowest price of one variety product and then combine it with one of each product A to H which can be the 135 $</SPAN></SPAN>
Column J if we make a highest price offer package than we can pick the highest price of one variety product and than combine picking one of each product A to H which can be the 476 $</SPAN></SPAN>
Made some offer price packages in Columns L, N, P, R, T and Y, question is how many special offer price packages can be prepared? Or in the range say 135$ to 199, 200$ to 299$, 300$ to 399$ or 400$ to 476$ may be?</SPAN></SPAN>
Below is shown example data...</SPAN></SPAN>
Thanks In Advance </SPAN></SPAN>
Using version 2000</SPAN></SPAN>
Regards,</SPAN></SPAN>
Moti</SPAN></SPAN>
Combine all products with different varieties to achieve a special offer price package </SPAN></SPAN>
I am looking for a solution on how many special offer price packages can be prepared from the product and variety list of D5:F12, Note: there is Product A To H & Variety X To Z in the offer packages there must be all Products present from A To H one of each, but only one variety price can be chosen from X to Z </SPAN></SPAN>
Here are a few examples...</SPAN></SPAN>
Column H if we make a lowest price offer package than we can pick the lowest price of one variety product and then combine it with one of each product A to H which can be the 135 $</SPAN></SPAN>
Column J if we make a highest price offer package than we can pick the highest price of one variety product and than combine picking one of each product A to H which can be the 476 $</SPAN></SPAN>
Made some offer price packages in Columns L, N, P, R, T and Y, question is how many special offer price packages can be prepared? Or in the range say 135$ to 199, 200$ to 299$, 300$ to 399$ or 400$ to 476$ may be?</SPAN></SPAN>
Below is shown example data...</SPAN></SPAN>
Book1 | ||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | |||
1 | ||||||||||||||||||||||||
2 | Min Offer Package | Max Offer Package | Offer Package | Offer Package | Offer Package | Offer Package | Offer Package | Offer Package | ||||||||||||||||
3 | Variety X | Variety Y | Variety Z | Price $ | Price $ | Price $ | Price $ | Price $ | Price $ | Price $ | Price $ | |||||||||||||
4 | Price $ | Price $ | Price $ | 135 | 476 | 157 | 212 | 243 | 311 | 334 | 392 | |||||||||||||
5 | Product A | 9 | 13 | 78 | 9 | 78 | 13 | 9 | 78 | 78 | 78 | 78 | ||||||||||||
6 | Product B | 23 | 34 | 43 | 23 | 43 | 23 | 23 | 43 | 23 | 23 | 23 | ||||||||||||
7 | Product C | 5 | 84 | 11 | 5 | 84 | 5 | 11 | 11 | 11 | 11 | 84 | ||||||||||||
8 | Product D | 59 | 26 | 15 | 15 | 59 | 26 | 26 | 15 | 59 | 26 | 59 | ||||||||||||
9 | Product E | 12 | 20 | 68 | 12 | 68 | 12 | 12 | 12 | 68 | 68 | 20 | ||||||||||||
10 | Product F | 27 | 33 | 40 | 27 | 40 | 27 | 27 | 40 | 27 | 27 | 27 | ||||||||||||
11 | Product G | 33 | 32 | 35 | 32 | 35 | 32 | 35 | 32 | 33 | 32 | 32 | ||||||||||||
12 | Product H | 12 | 69 | 19 | 12 | 69 | 19 | 69 | 12 | 12 | 69 | 69 | ||||||||||||
Sheet2 |
Thanks In Advance </SPAN></SPAN>
Using version 2000</SPAN></SPAN>
Regards,</SPAN></SPAN>
Moti</SPAN></SPAN>
Last edited: