Combine all products with different varieties

[motilulla]

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>

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>

 

[Marcelo Branco]

I'm glad it now worked!

All the best.

M.